Elixir ecto naive_datetime error
In my ecto model, I need to specify in the: user_timestamp field the time converted from unix_time. migration:
def change do
alter table(:operations) do
add :user_timestamp, :naive_datetime, null: false
end
end
my operation.ex
schema "operations" do
field :sum, :float
field :name, :string
field :user_timestamp, :naive_datetime
timestamps()
end
def changeset(struct, params \\ %{}) do
struct
|> cast(params, [:name, :sum, :user_timestamp])
|> validate_required([:sum, :user_timestamp])
|> convert_unix_time_to_ecto
end
defp convert_unix_time_to_ecto(changeset) do
put_change(changeset, :user_timestamp, Ecto.DateTime.from_unix!(changeset.changes.user_timestamp, :seconds) |> Ecto.DateTime.to_naive())
end
But when I try to add the requirement to have user_timestamp, I get the error:
[error] #PID<0.492.0> running MyApp.Endpoint terminated
Server: localhost:4000 (http)
Request: POST /api/v1/operations
** (exit) an exception was raised:
** (FunctionClauseError) no function clause matching in Ecto.Type.cast_naive_datetime/1
(ecto) lib/ecto/type.ex:761: Ecto.Type.cast_naive_datetime(1492722276)
(ecto) lib/ecto/changeset.ex:523: Ecto.Changeset.cast_field/8
(ecto) lib/ecto/changeset.ex:482: Ecto.Changeset.process_param/8
(elixir) lib/enum.ex:1325: Enum."-map_reduce/3-lists^mapfoldl/2-0-"/3
(elixir) lib/enum.ex:1325: Enum."-map_reduce/3-lists^mapfoldl/2-0-"/3
(ecto) lib/ecto/changeset.ex:450: Ecto.Changeset.do_cast/7
(my_app) web/models/operation.ex:25: MyApp.Operation.changeset/2
(my_app) web/models/operation.ex:32: MyApp.Operation.create_changeset/2
(my_app) web/controllers/v1/operation_controller.ex:25: MyApp.V1.OperationController.create/2
(my_app) web/controllers/v1/operation_controller.ex:1: MyApp.V1.OperationController.action/2
(my_app) web/controllers/v1/operation_controller.ex:1: MyApp.V1.OperationController.phoenix_controller_pipeline/2
(my_app) lib/my_app/endpoint.ex:1: MyApp.Endpoint.instrument/4
(my_app) lib/phoenix/router.ex:261: MyApp.Router.dispatch/2
(my_app) web/router.ex:1: MyApp.Router.do_call/2
(my_app) lib/my_app/endpoint.ex:1: MyApp.Endpoint.phoenix_pipeline/1
(my_app) lib/plug/debugger.ex:123: MyApp.Endpoint."call (overridable 3)"/2
(my_app) lib/my_app/endpoint.ex:1: MyApp.Endpoint.call/2
(plug) lib/plug/adapters/cowboy/handler.ex:15: Plug.Adapters.Cowboy.Handler.upgrade/4
(cowboy) /home/mars/phoenix_projects/my_app/deps/cowboy/src/cowboy_protocol.erl:442: :cowboy_protocol.execute/4
How can you fix this error?
+3
source to share
2 answers
It doesn't work in cast
before your conversion code gets a chance to run.
Leave the :user_timestamp
cast fields out of the box and use put_change
with the converted value to validate_required
.
def changeset(struct, params \\ %{}) do
struct
|> cast(params, [:name, :sum])
|> convert_unix_time_to_ecto(params["user_timestamp"])
|> validate_required([:sum, :user_timestamp])
end
defp convert_unix_time_to_ecto(changeset, nil), do: changeset
defp convert_unix_time_to_ecto(changeset, timestamp) do
datetime =
timestamp
|> DateTime.from_unix!(:seconds)
|> DateTime.to_naive()
put_change(changeset, :user_timestamp, datetime)
end
+3
source to share