spec/scripts/database/schema_validator_spec.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

# frozen_string_literal: true

require 'fast_spec_helper'

require_relative '../../../scripts/database/schema_validator'

RSpec.describe SchemaValidator, feature_category: :database do
  subject(:validator) { described_class.new }

  describe "#validate!" do
    before do
      allow(validator).to receive(:committed_migrations).and_return(committed_migrations)
      allow(validator).to receive(:run).and_return(schema_changes)
    end

    context 'when schema changes are introduced without migrations' do
      let(:committed_migrations) { [] }
      let(:schema_changes) { 'db/structure.sql' }

      it 'terminates the execution' do
        expect { validator.validate! }.to raise_error(SystemExit)
      end
    end

    context 'when schema changes are introduced with migrations' do
      let(:committed_migrations) { ['20211006103122_my_migration.rb'] }
      let(:schema_changes) { 'db/structure.sql' }
      let(:command) { 'git diff db/structure.sql -- db/structure.sql' }
      let(:base_message) { 'db/structure.sql was changed, and no migrations were added' }

      before do
        allow(validator).to receive(:die)
      end

      it 'skips schema validations' do
        expect(validator.validate!).to be_nil
      end
    end

    context 'when skipping validations through ENV variable' do
      let(:committed_migrations) { [] }
      let(:schema_changes) { 'db/structure.sql' }

      before do
        stub_env('ALLOW_SCHEMA_CHANGES', true)
      end

      it 'skips schema validations' do
        expect(validator.validate!).to be_nil
      end
    end

    context 'when skipping validations through commit message' do
      let(:committed_migrations) { [] }
      let(:schema_changes) { 'db/structure.sql' }
      let(:commit_message) { "Changes db/strucure.sql file\nskip-db-structure-check" }

      before do
        allow(validator).to receive(:run).and_return(commit_message)
      end

      it 'skips schema validations' do
        expect(validator.validate!).to be_nil
      end
    end
  end
end