How do I perform this ActiveRecord query?

Can you prevent developers from using raw SQL queries in ActiveRecord?

• 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 rails.  I need this because I have a lot of callbacks running at the AR layer. How do I implement this? EDIT 1: I should be more clear. I don't care about someone directly logging into mysql and doing updates. But one should not be able to run a mysql query inside rails using the connection object directly. Is there a way to restrict that? EDIT 2: Our actual problem is like the below, We have a separate read only tables for performance. All the writes to master tables will create callbacks that update the readonly tables. The readonly tables are optimised for read performance. Now when a developer updates the master tables directly through SQL, the activerecord callbacks don't know about it and the readonly table data become inconsistent. This is our problem.

• Answer:

  It sounds like you want to selectively block writing to the database? One way would be to override ActiveRecord::Base#readonly? to check if the active connection is on the master database or not. Alternatively, you could add an `after_find` find callback that blocks updates: def after_find readonly! if self.connection.readonly? end You'll have to add your own readonly? method to the connection object to match your specific conditions.