Much appreciated, thank you Jeremy!
On Friday, December 15, 2017 at 5:18:36 PM UTC+1, Jeremy Evans wrote:
>
> On Friday, December 15, 2017 at 2:13:06 AM UTC-8, Emil Ahlbäck wrote:
>>
>> Hello everyone
>>
>> I'm struggling to find the right documentation to accomplish an update
>> query which performs updates on many rows in one go. The equal SQL
>> statement looks like this:
>>
>> UPDATE order_lines AS ol
>> SET ol.material_cost = val.material_cost
>> FROM (
>> VALUES (1, 150), (2, 320)
>> ) AS val(id, material_cost)
>> WHERE ol.id = val.id;
>>
>>
>> I'm right now resorting to string interpolation and raw SQL to perform
>> this query but I'd like to write things a little bit more elegant. I'd be
>> very thankful for pointers to the right piece of documentation!
>>
>
> Here you go:
>
> DB.from(Sequel[:order_lines].as(:ol), DB.values([[1, 150], [2,
> 320]]).as(:val, [:id, :material_cost])).
> where{ol[:id] =~ val[:id]}.
> update(Sequel[:ol][:material_cost] => Sequel[:val][:material_cost])
>
> Thanks,
> Jeremy
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
