How to execute a raw update sql with dynamic binding in rails

by

It doesn’t look like the Rails API exposes methods to do this generically. You could try accessing the underlying connection and using it’s methods, e.g. for MySQL:

st = ActiveRecord::Base.connection.raw_connection.prepare("update table set f1=? where f2=? and f3=?")
st.execute(f1, f2, f3)
st.close

I’m not sure if there are other ramifications to doing this (connections left open, etc). I would trace the Rails code for a normal update to see what it’s doing aside from the actual query.

Using prepared queries can save you a small amount of time in the database, but unless you’re doing this a million times in a row, you’d probably be better off just building the update with normal Ruby substitution, e.g. 

ActiveRecord::Base.connection.execute("update table set f1=#{ActiveRecord::Base.sanitize(f1)}")

or using ActiveRecord like the commenters said.

More Related Contents:

  1. Rails ActiveRecord methods in different places [closed]
  2. accepts_nested_attributes_for with find_or_create?
  3. ActiveRecord.find(array_of_ids), preserving order
  4. When to use a “has_many :through” relation in Rails?
  5. Rails 5: ActiveRecord OR query
  6. Ruby on Rails. How do I use the Active Record .build method in a :belongs to relationship?
  7. ActiveRecord Find By Year, Day or Month on a Date field
  8. How to query a model based on attribute of another model which belongs to the first model?
  9. How does Rails ActiveRecord chain “where” clauses without multiple queries?
  10. Rails: ActiveRecord query based on association value
  11. How to test for (ActiveRecord) object equality
  12. query , can not select column count
  13. How to use ActiveRecord in a ruby script outside Rails?
  14. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  15. Validate uniqueness of multiple columns
  16. Rails: How do I create a default value for attributes in Rails activerecord’s model? [duplicate]
  17. Using helpers in model: how do I include helper dependencies?
  18. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  19. Rails – Validate Presence Of Association?
  20. Do rails rake tasks provide access to ActiveRecord models?
  21. Rails 3 migrations: Adding reference column?
  22. Converting an array of objects to ActiveRecord::Relation
  23. how to add records to has_many :through association in rails
  24. How to implement bulk insert in Rails 3
  25. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  26. Is there a way to avoid automatically updating Rails timestamp fields?
  27. Non persistent ActiveRecord model attributes
  28. Rails best way to get previous and next active record object
  29. How can I use ActiveRecord on a database that has a column named ‘valid’? (DangerousAttributeError)
  30. Rails Object Relationships and JSON Rendering

Leave a Comment