raw sql query-update

rubyonrails-talk
1

Hi people

I need to write a raw sql query in rails 3. But I don't know where should I do this, in the model or in the controller?

Thanks

2

If you are not sure where it should be then firstly I would ask whether you are sure you need to write a raw sql query. If you do need to do that then almost always it should be in a model. However without knowing more details of what it does and why, it is impossible to give an absolute answer.

Colin

3

Well

I have two non related models, but I need to update an attribute value of one model using a value from the other one. I've tried using callbacks(after_create update_attribute), but it didn't work because they are not related and because I need "extra" conditions. So I think I could solve this using a raw sql query

4

Please don't top post, it makes it difficult to follow the thread. Insert your reply at appropriate point(s) in previous post. Thanks.

Well

I have two non related models, but I need to update an attribute value of one model using a value from the other one. I've tried using callbacks(after_create update_attribute), but it didn't work because they are not related and because I need "extra" conditions. So I think I could solve this using a raw sql query

Having a value in one table dependent on the value in another is often a sign of non-optimal database design. Are you sure that this could not be improved?

Even if that is the best solution I don't see why that requires raw sql, or why it could not be done in a callback.

Colin