You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
analytics/lib/plausible/clickhouse_event_v2.ex

69 lines
2.1 KiB
Elixir

defmodule Plausible.ClickhouseEventV2 do
@moduledoc """
Event schema for when NumericIDs migration is complete
"""
use Ecto.Schema
import Ecto.Changeset
@primary_key false
schema "events_v2" do
field :name, Ch, type: "LowCardinality(String)"
field :site_id, Ch, type: "UInt64"
field :hostname, :string
field :pathname, :string
field :user_id, Ch, type: "UInt64"
field :session_id, Ch, type: "UInt64"
field :timestamp, :naive_datetime
field :"meta.key", {:array, :string}
field :"meta.value", {:array, :string}
field :revenue_source_amount, Ch, type: "Nullable(Decimal64(3))"
field :revenue_source_currency, Ch, type: "FixedString(3)"
field :revenue_reporting_amount, Ch, type: "Nullable(Decimal64(3))"
field :revenue_reporting_currency, Ch, type: "FixedString(3)"
# Session attributes
field :referrer, :string
field :referrer_source, :string
field :utm_medium, :string
field :utm_source, :string
field :utm_campaign, :string
field :utm_content, :string
field :utm_term, :string
field :country_code, Ch, type: "FixedString(2)"
field :subdivision1_code, Ch, type: "LowCardinality(String)"
field :subdivision2_code, Ch, type: "LowCardinality(String)"
field :city_geoname_id, Ch, type: "UInt32"
field :screen_size, Ch, type: "LowCardinality(String)"
field :operating_system, Ch, type: "LowCardinality(String)"
field :operating_system_version, Ch, type: "LowCardinality(String)"
field :browser, Ch, type: "LowCardinality(String)"
field :browser_version, Ch, type: "LowCardinality(String)"
end
def new(attrs) do
%__MODULE__{}
|> cast(
attrs,
[
:name,
:site_id,
:hostname,
:pathname,
:user_id,
:timestamp,
:"meta.key",
:"meta.value",
:revenue_source_amount,
:revenue_source_currency,
:revenue_reporting_amount,
:revenue_reporting_currency
]
)
|> validate_required([:name, :site_id, :hostname, :pathname, :user_id, :timestamp])
end
end