Phlip
5/20/2009 6:50:00 PM
rilindo foster wrote:
> Is there a correct style of putting in SQL statements in Ruby? My SQL
> statements tend to go around 200-400 columns, which looks *very* ugly.
A> use ActiveRecord, or one of the other SQL generators
B> this:
SELECT FROM users
WHERE is_premier = 1
AND charge_at > NOW()
Notice that all SQL keywords are in UPCASE, just for emphasis, and there's a
vertical gutter in the 6th relative column. The SQL books advocate that gutter,
I think.
Also, if you have 200-400 column strings, you need to get more DRY. That leads
back to ActiveRecord...