Ok I am trying the following which builds an update using block, but I
get an error...
ds.update do
periods.each do |p| # create updates for all periods
(p|idx) << (p|idx) + v
end
end
the error is...
cycle_stats.rb:166:in `process': undefined method `+' for
#<Sequel::SQL::Subscript:0xb75544cc @f=:day, @sub=[1]> (NoMethodError)
Did I screw up somewhere?
On Dec 14, 11:58 pm, Jim Morris <[EMAIL PROTECTED]> wrote:
> Oops yep that is in the Changelog should have read that first;)
>
> Thnks, that'll make this script I am working on even cleaner,
>
> On Dec 14, 11:52 pm, Jim Morris <[EMAIL PROTECTED]> wrote:
>
> > Will I be able to do this :)
>
> > dataset.update_sql{: exp|2 << :exp|2 + 10} ?
>
> > On Dec 14, 8:52 pm, Sharon Rosner <[EMAIL PROTECTED]> wrote:
>
> > > > So the way to do that right now is:
>
> > > > >> dataset.update_sql(:exp => 'exp + 10'.lit)
>
> > > > => "UPDATE table SET exp = exp + 10"
>
> > > I've added support for blocks for Dataset#update, which lets you do
> > > this much more easily:
>
> > > dataset.update {:exp << :exp + 10}
>
> > > Because of the way Ruby is parsed I had to use the << operator for
> > > assignment. So check out the trunk and let me know if it works for
> > > you.
>
> > > best
> > > Sharon
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
