Allows you to test whether your database schema matches the validations in your ActiveRecord models.

You can find documentation at http://www.rubydoc.info/gems/schema_expectations

Add schema_expectations to your Gemfile:

group :test do
  gem 'schema_expectations'
end

The validate_schema_uniqueness matcher tests that an ActiveRecord model has uniqueness validation on columns with database uniqueness constraints, and vice versa.

For example, we can assert that the model and database are consistent on whether record_type and record_id should be unique:

create_table :records do |t|
  t.integer :record_type
  t.integer :record_id
  t.index [:record_type, :record_id], unique: true
end

class Record < ActiveRecord::Base
  validates :record_type, uniqueness: { scope: :record_id }
end

# RSpec
describe Record do
  it { should validate_schema_uniqueness }
end

You can restrict the columns tested:

# RSpec
describe Record do
  it { should validate_schema_uniqueness.only(:record_id, :record_type) }
  it { should validate_schema_uniqueness.except(:record_id, :record_type) }
end

note: if you exclude a column, then every unique scope which includes it will be completely ignored, regardless of whether that scope includes other non-excluded columns. Only works similarly, in that it will ignore any scope which contains columns not in the list

Absence validation on any attribute in a scope absolves requiring uniqueness validation.

The validate_schema_nullable matcher tests that an ActiveRecord model has unconditional presence validation on columns with NOT NULL constraints, and vice versa.

For example, we can assert that the model and database are consistent on whether Record#name should be present:

create_table :records do |t|
  t.string :name, null: false
end

class Record < ActiveRecord::Base
  validates :name, presence: true
end

# RSpec
describe Record do
  it { should validate_schema_nullable }
end

You can restrict the columns tested:

# RSpec
describe Record do
  it { should validate_schema_nullable.only(:name) }
  it { should validate_schema_nullable.except(:name) }
end

The primary key and timestamp columns are automatically skipped.

MIT License