Skip to content

Instantly share code, notes, and snippets.

@Teino1978-Corp

Teino1978-Corp/example.rb

Created December 11, 2015 07:52
Show Gist options
  • Save Teino1978-Corp/98bcb73a378db1656db8 to your computer and use it in GitHub Desktop.
Save Teino1978-Corp/98bcb73a378db1656db8 to your computer and use it in GitHub Desktop.
Download ZIP
Bulk update example in ActiveRecord Rails
Raw
example.rb
new_values = { 10 => "test1", 20 => "test2" }
value = new_values.map { |product_id, value| "(#{product_id}, #{value})" }.join(",")
ActiveRecord::Base.connection.execute(%(
UPDATE products AS p SET value = v.value
FROM (values #{values}) AS v(id, value)
WHERE p.id = v.id
))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment