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
On 9 August 2011 18:34, Angelo C. [email protected] wrote:
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?
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
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
On 9 August 2011 21:47, Angelo C. [email protected] wrote:
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