disabling direct SQL queries in rails

Question

We are running a rails+mysql application. In my specific requirement I want all my developers to access mysql only throught the rails API. I want to disable all direct mysql queries outside ActiveRecord.

This is because we run a lot of callbacks at activerecord to maintain integrity of data.

How to implement this?

I think following link would help you. http://stackoverflow.com/questions/2212709/remove-activerecord-in-rails-3. Thanks. — urjit on rails, May 28 '12 at 08:23
ok....sorry I misunderstood your question. what you want to do is use active record query instead of mysql query? — urjit on rails, May 28 '12 at 08:47
Yes. And even if someone uses my mistake I should have some way to prevent it. — tamizhgeek, May 28 '12 at 09:01

Pavling · Accepted Answer · 2012-05-28T12:10:06.350

4

How to implement this?

Code reviews.

You're not going to prevent "direct mysql queries outside ActiveRecord", because you can do direct SQL queries with ActiveRecord:

Model.find_by_sql("DELETE * FROM admin_table")

Your best approach will probably be to ensure that the code your developers are writing is following the best-practices you determine. Do this by peer-review processes and education.

edited May 28 '12 at 12:10

answered May 28 '12 at 09:09

Pavling

3,933
1
22
25

disabling direct SQL queries in rails

1 Answers1