How to use Exquisite selector?

[eraserewind]

Hi,

I'm having an issue using the exquisite selector. I've written this code, from the README section:

    Amnesia.transaction do
      existing_user = User.where(email == new_mail, select: id) |> Amnesia.Selection.values
      existing_user
    end

My table user: deftable User, [ :id, :email, :name, :password ], type: :ordered_set, index: [:email]

At compilation time i'm getting this error:

== Compilation error on file lib/mnesia.ex ==
** (CompileError) lib/mnesia.ex:51: function email/0 undefined
    (stdlib) lists.erl:1336: :lists.foreach/2
    lib/mnesia.ex:31: (module)

What I am missing? Thanks!

[cjimison]

This is kind of an old question but I figured I would give it a response just because I hit a similar issue.

Try changing it to

      existing_user = User.where(email == new_mail, select: id)
      existing_user  |> Amnesia.Selection.values

I think exquisite is doing some macro programming funness and gets confused when you try to pipe or do other operations besides just the "where" call.

[vitaliel]

For me it worked when I added require statement:

  require Amnesia
  require Database.User
  require Exquisite