How to queries from database without model in Rails3?

Question

How can i solve this problems if i dont't use injection sql command in controller?

More details enter image description here

Steve Rowley · Accepted Answer · 2012-05-09 11:16:53Z

1

See this question:

http://www.stackoverflow.com/questions/4727470/how-to-make-rails-external-database-calls

Basically, the point is that you can define the connection to the other database in database.yml. ActiveRecord::Base will inherit from one by default, but you can use the establish_connection method to connect to the other database that you've configured for a given model.

Then you can use the ActiveRecord API (e.g. find_by_sql) to query the other database.

answered May 9, 2012 at 11:16

Steve Rowley

1,5781 gold badge11 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

lovepong Over a year ago

I thought 'establish_connection' is a good idea to solved. Thanks,

flooooo · Accepted Answer · 2012-05-09 09:09:18Z

1

I think you won't (or at least shouldn't) get around using at least ActiveRecord models and querying them using find_by_sql.

Refer to: http://api.rubyonrails.org/classes/ActiveRecord/Querying.html#method-i-find_by_sql

answered May 9, 2012 at 9:09

flooooo

7094 silver badges14 bronze badges

2 Comments

lovepong Over a year ago

um mayby 'Rails's creator' get read this and solved this problem soon hahaha , Thank for your answer but i still to solve it except sql command.

lovepong Over a year ago

find_by_sql is one of solution you can do then you want to queries other tables that still in rails project (the same database) and will not work within queries to another database.

Collectives™ on Stack Overflow

How to queries from database without model in Rails3?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related