SQL in rails without active record ?

rubyonrails-talk
1

How can I do sql inside of rails where active record is not involved ? I have done find_by_sql type things before, but they always return an active record. There may be a need on this project to do a more typical sql select that does a join etc.

2

I think I figured this out, it turned out to be fairly easy ..

3

You might try

ActiveRecord::Base.connection.execute "SELECT..."

Or, in a model file, which is where you probably should be doing this kind of thing, I guess it would just be connection.execute "(query)"

See for more information:

If you just need to do a join, though, you can pass the :join option to active record in whatever query you're doing.

Jedrin wrote:

4

You might try

ActiveRecord::Base.connection.execute "SELECT..."

Or, in a model file, which is where you probably should be doing this kind of thing, I guess it would just be connection.execute "(query)"

select_all returns a more portable result (array of hashes rather than something db specific)

Fred