This page is not available in every language. Missing translations are disabled in the language selector.

Quick reference

Rails ActiveRecord Models Cheatsheet

A comprehensive reference guide for Rails ActiveRecord models: querying scopes, associations, validations, callbacks, dirty tracking, and aggregations.

· Published

ActiveRecord represents the M (Model) in Rails MVC, encapsulating business logic, database queries, associations, and validation rules.

Querying Methods

# Basic finders
User.find(1)                  # Raises RecordNotFound if missing
User.find_by(email: '[email protected]')# Returns nil if missing
User.first
User.last

# Conditions and filters
User.where(active: true)
User.where.not(role: 'banned')
User.where('age >= ?', 18)

# Ordering and slicing
User.order(created_at: :desc).limit(10).offset(20)

# Scopes
class User < ApplicationRecord
  scope :active, -> { where(active: true) }
  scope :recent, -> { order(created_at: :desc) }
end

Associations

class Author < ApplicationRecord
  has_many :books, dependent: :destroy
  has_one :profile
  has_many :reviews, through: :books
end

class Book < ApplicationRecord
  belongs_to :author
  has_and_belongs_to_many :genres
end

Validations

class User < ApplicationRecord
  validates :name, presence: true, length: { minimum: 2 }
  validates :email, presence: true, uniqueness: { case_sensitive: false }, format: { with: URI::MailTo::EMAIL_REGEXP }
  validates :age, numericality: { greater_than_or_equal_to: 13 }
  validates :role, inclusion: { in: %w[admin member guest] }
end

Callbacks

class Order < ApplicationRecord
  before_validation :normalize_currency
  before_create :generate_tracking_code
  after_create_commit :send_receipt_email

  private

  def normalize_currency
    self.currency = currency.upcase
  end
end

Dirty Attribute Tracking

user = User.first
user.name = "New Name"

user.changed?        # => true
user.changed         # => ["name"]
user.changes         # => {"name" => ["Old Name", "New Name"]}
user.name_was        # => "Old Name"

Aggregations & Calculations

Order.count
Order.sum(:total_amount)
Order.average(:rating)
Order.maximum(:price)
Order.minimum(:price)

References

Related topics