Is there a way to find a model by SQL? I am having a very hard time trying 
to translate this into a Model finder.

select u.*
from users u left join password_hashes ph on u.id = ph.user_id
where u.email = ? and
ph.hashed_password = crypt( ? , ph.hashed_password)'

I tried starting by doing this  User.join(:password_hashes, :id, :user_id)

But I get a cryptic error

TypeError: no implicit conversion of Symbol into Integer
from 
/Users/tim/.gem/ruby/2.4.1/gems/sequel-5.0.0/lib/sequel/dataset/query.rb:537:in 
`[]'

BTW is there a way to get the full SQL when errors are being reported. I 
get truncated SQLs which are missing important imformation.

Thanks.

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.

Reply via email to