We need to format attribute values before setting them on the ActiveRecord model to maintain data integrity. This article illustrates how to format values before setting them on the ActiveRecord model.

Format values of attributes on the ActiveRecord model

Rails introduces insert_all and upsert_all methods to perform database operations in bulk. Before this, gems like activerecord-import were being used to perform bulk insertion or updates.

Rails 6 introduces insert_all / upsert_all methods

Sometimes, we need to remove selected columns and select new columns for the query being done. Rails 6 introduces reselect on ActiveRecord#Relation on query methods. This lets us easily select new columns.

Rails 6 adds reselect on ActiveRecord Relation

Often we need to find records based on certain conditions and then delete those records. To perform this, ActiveRecord has introduced delete_by and destroy_by methods in Rails 6.

Rails 6 adds delete_by and destroy_by methods on ActiveRecord

While Rails comes with ActiveRecords that saves us from writing some scary (at least to me :)) SQL logic but still there are times when we need to write raw SQL queries. Here is an example showing how we format SQL queries in our applications.

Activerecord (5 posts)