e-metrotel/ex_queb

Generic Ecto Query Builder

ex_queb's Issues

Using ex_queb via github fails to compile

hi,
I have a PR that is pending to be merged, and so I wanted to use my github fork in mix.exs by the following line:

{:ex_queb, [env: :prod, github: "vraravam/ex_queb", hex: :ex_queb, override: true]},   # NOTE: Transitive dependency: Only reqd till the original authors release a new version with my fixes

But, this is the error I am getting:

module Ecto.Query is not loaded and could not be found

Ecto 3.0

Hi there. I see this project still uses ecto ~> 2.0 as a dependency. Will this project be updated to support ecto ~> 3.0? Would you accept a pull request to enable a new version that supports ecto 3.0? Thanks!

hex.pm

Please update all your packages on hex.pm

Use ILIKE instead of LIKE if PG-adapter is used.

LIKE in PostgreSQL is case-sensitive, so in filters would be better to use case-insensitive ILIKE

https://github.com/E-MetroTel/ex_queb/blob/master/lib/ex_queb.ex#L26

Add ecto 2 dependency

ecto dependency is locked to ecto 1 which is causing an issue with ex_admin master

Support :csv action

build_order_bys should support :csv action.

function DateTime.cast/1 is undefined or private

Hi,

I Got DateTime.cast/1 error, I too new to elixir and ecto stuff, so I just report issue and my workaround here, and thank for you shares, it save a lot!

Error Message

** (exit) an exception was raised:
    ** (UndefinedFunctionError) function DateTime.cast/1 is undefined or private
        (elixir) DateTime.cast("2019-11-30 00:00:00.000000")
        (elixir) lib/enum.ex:1948: Enum."-reduce/3-lists^foldl/2-0-"/3
        (elixir) lib/enum.ex:1440: Enum."-map_reduce/3-lists^mapfoldl/2-0-"/3
        (elixir) lib/enum.ex:1440: Enum."-map_reduce/3-lists^mapfoldl/2-0-"/3
        (elixir) lib/enum.ex:1948: Enum."-reduce/3-lists^foldl/2-0-"/3
        (ecto) deps/ecto/lib/ecto/repo/queryable.ex:161: Ecto.Repo.Queryable.execute/4
        (ecto) deps/ecto/lib/ecto/repo/queryable.ex:17: Ecto.Repo.Queryable.all/3
        (ecto) deps/ecto/lib/ecto/repo/queryable.ex:97: Ecto.Repo.Queryable.one/3
        (scrivener_ecto) deps/scrivener_ecto/lib/scrivener/paginater/ecto/query.ex:53: Scrivener.Paginater.Ecto.Query.total_entries/3

Workaround

  defp _build_date_filter(query, fld, value, :gte) do
        where(query, [q], fragment("? >= ?", field(q, ^fld), ^value))
        # where(query, [q], fragment("? >= ?", field(q, ^fld), type(^value, DateTime)))
  end

  defp _build_date_filter(query, fld, value, :lte) do
        where(query, [q], fragment("? <= ?", field(q, ^fld), ^value))
       # where(query, [q], fragment("? <= ?", field(q, ^fld), type(^value, DateTime)))
  end