I am trying to DRY up some Sequel code and re-use common SQL
expressions across different models. Ran into the following issue:
estimated_traffic_cost = lambda{(:a__avg_cpc *
count(:distinct, :visit_id){})}
gross_profit = lambda{sum(:commission) - estimated_traffic_cost}
DB[:a].select(&gross_profit)
Sequel::Error: can't express #<Proc:0x03d7a8f4@(irb):119> as a SQL
literal
This works:
gross_profit = lambda{sum(:commission) -
Sequel.virtual_row(&estimated_traffic_cost)}
Is there a better solution?
Maybe if Sequel encounters a proc in an expression it could call
Sequel.virtual_row on it?
Thanks, Rohit
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
