Here is the custom type I put together:
defmodule CustomTypes.EctoBigint do
@behaviour Ecto.Type
def type, do: :integer
def cast(string) when is_binary(string), do: _to_integer(string)
def cast(integer) when is_integer(integer), do: {:ok, integer}
def cast(_), do: :error
def load(integer) when is_integer(integer), do: _to_string(integer)
def dump(string) when is_binary(string), do: _to_integer(string)
def dump(integer) when is_integer(integer), do: {:ok, integer}
def dump(_), do: :error
defp _to_integer(string) do
case Integer.parse(string) do
{int, _} -> {:ok, int}
:error -> :error
end
end
defp _to_string(integer) do
{:ok, Integer.to_string(integer)}
end
end
Use it in your Ecto schema like this:
...
alias CustomTypes.EctoBigint, as: Bigint
...
@primary_key false
@derive {Poison.Encoder, only: [:id, ...]}
schema "myschema" do
# Tell Ecto to use Bigint as the type and that id the primary_key.
# `read_after_writes: true` is needed to return the id on insert etc.
field :id, Bigint, primary_key: true, read_after_writes: true
...
# Tell Ecto to use the Bigint type for any relations as well
belongs_to :other_schema, OtherSchema, type: Bigint
end
In the migration:
...
@table "myschema"
def up do
create table(@table, primary_key: false) do
add :id, :bigint, primary_key: true
...
add :other_schema_id, references(:other_schema, type: :bigint)
end
flush()
execute """
ALTER TABLE #{prefix()}.#{@table} ALTER COLUMN id SET DEFAULT #{prefix()}.next_id()
"""
end
def down do
drop table(@table)
end
...
This is what I worked out and everything seemed to be working fine but I haven’t had time lately to work with it much since my initial testing so YMMV.
Sorry for the delay and I hope I didn’t forget anything as I’m pressed for time due to a recent family illness.
