Calendar.DateTime can't be used directly in queries

[stevedomin]

Calendar.DateTime can't be used directly in queries

[stevedomin]

The following code is working:

def upcoming_events(group) do
  {:ok, now} = Calendar.DateTime.now_utc |> Calecto.DateTimeUTC.cast
  from(g in Eager.Group,
    join: e in assoc(g, :events),
    where: e.group_id == ^group.id,
    where: fragment("(?).wall_time > ?", e.start_datetime, type(^now, :datetime)),
    select: e)
end

which I simplified to:

def upcoming_events(group) do
  now = Calendar.DateTime.now_utc
  from(g in Eager.Group,
    join: e in assoc(g, :events),
    where: e.group_id == ^group.id,
    where: fragment("(?).wall_time > ?", e.start_datetime, type(^now, :datetime)),
    select: e)
end

[lau]

It looks like changes are needed in Ecto. Because it is a composite type. Calendar structs should work directly with the other field types.

Until Ecto is changed, it is necessary to convert the DateTime structs to "micro_erl" tupples with DateTime.micro_erl e.g. DateTime.now_utc |> DateTime.to_micro_erl

[josevalim]

@stevedomin can you please try the following:

where: fragment("(?).wall_time > ?", type(u.start_datetime, :datetime), type(^now, :datetime))

If it doesn't work, please try Ecto.DateTime instead of :datetime.

[stevedomin]

@josevalim

def upcoming_events(group) do
  now = Calendar.DateTime.now_utc |> Calecto.DateTimeUTC.cast
  #now = Calendar.DateTime.now_utc |> Calendar.DateTime.to_micro_erl
  from(g in Eager.Group,
    join: e in assoc(g, :events),
    where: e.group_id == ^group.id,
    where: fragment("(?).wall_time > ?", type(e.start_datetime, :datetime), type(^now, :datetime)),
    #where: fragment("(?).wall_time > ?", e.start_datetime, ^now),
    select: e)
end

# error
** (Ecto.Query.CompileError) `type(e.start_datetime(), :datetime)` is not a valid query expression.

* If you intended to call a database function, please check the documentation
  for Ecto.Query to see the supported database expressions

* If you intended to call an Elixir function or introduce a value,
  you need to explicitly interpolate it with ^

Same error with Ecto.DateTime

[josevalim]

Sorry, you should use type only on the last value, the one you interpolate
on.

On Friday, February 19, 2016, Steve Domin [email protected] wrote:

@josevalim https://github.com/josevalim

def upcoming_events(group) do
now = Calendar.DateTime.now_utc |> Calecto.DateTimeUTC.cast #now = Calendar.DateTime.now_utc |> Calendar.DateTime.to_micro_erl
from(g in Eager.Group,
join: e in assoc(g, :events),
where: e.group_id == ^group.id,
where: fragment("(?).wall_time > ?", type(e.start_datetime, :datetime), type(^now, :datetime)), #where: fragment("(?).wall_time > ?", e.start_datetime, ^now),
select: e)end

error** (Ecto.Query.CompileError) type(e.start_datetime(), :datetime) is not a valid query expression.

• If you intended to call a database function, please check the documentation
  for Ecto.Query to see the supported database expressions
• If you intended to call an Elixir function or introduce a value,
  you need to explicitly interpolate it with ^

Same error with Ecto.DateTime

—
Reply to this email directly or view it on GitHub
#18 (comment).

José Valimwww.plataformatec.com.br
http://www.plataformatec.com.br/Founder and Director of R&D