describe 'Ridgepole::Client#diff -> migrate' do
  context 'when execute' do
    let(:dsl) {
      erbh(<<-EOS)
        create_table "authors", <%= i cond('>= 5.1',id: :integer) + {force: :cascade} %> do |t|
          t.string "name", null: false
        end

        create_table "books", <%= i cond('>= 5.1',id: :integer) + {force: :cascad} %>e do |t|
          t.string  "title", null: false
          t.integer "author_id", null: false
          t.index ["author_id"], name: "idx_author_id", <%= i cond(5.0, using: :btree) %>
        end
      EOS
    }

    let(:dsl_with_execute) {
      erbh(<<-EOS)
        create_table "authors", <%= i cond('>= 5.1',id: :integer) + {force: :cascade} %> do |t|
          t.string "name", null: false
        end

        create_table "books", <%= i cond('>= 5.1',id: :integer) + {force: :cascad} %>e do |t|
          t.string  "title", null: false
          t.integer "author_id", null: false
          t.index ["author_id"], name: "idx_author_id", <%= i cond(5.0, using: :btree) %>
        end

        execute("ALTER TABLE books ADD CONSTRAINT fk_author FOREIGN KEY (author_id) REFERENCES authors (id)") do |c|
          c.raw_connection.query("SELECT 1 FROM information_schema.key_column_usage WHERE TABLE_SCHEMA = '<%= TEST_SCHEMA %>' AND CONSTRAINT_NAME = 'fk_author' LIMIT 1").each.length.zero?
        end
      EOS
    }

    before { subject.diff(dsl).migrate }
    subject { client }

    it {
      delta = subject.diff(dsl_with_execute)
      expect(delta.differ?).to be_truthy
      expect(subject.dump).to match_ruby dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS)
        CREATE TABLE `books` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` int(11) NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) <%= cond(5.0, 'USING BTREE') %>
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS

      delta.migrate

      expect(subject.dump).to match_fuzzy (dsl + (<<-EOS))
        add_foreign_key "books", "authors", name: "fk_author"
      EOS

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS)
        CREATE TABLE `books` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` int(11) NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) <%= cond(5.0, 'USING BTREE') %>,
          CONSTRAINT `fk_author` FOREIGN KEY (`author_id`) REFERENCES `authors` (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS
    }
  end

  context 'when not execute' do
    let(:dsl) {
      erbh(<<-EOS)
        create_table "authors", <%= i cond('>= 5.1',id: :integer) + {force: :cascade} %> do |t|
          t.string "name", null: false
        end

        create_table "books", <%= i cond('>= 5.1',id: :integer) + {force: :cascad} %>e do |t|
          t.string  "title", null: false
          t.integer "author_id", null: false
          t.index ["author_id"], name: "idx_author_id", <%= i cond(5.0, using: :btree) %>
        end
        add_foreign_key "books", "authors", name: "fk_author"
      EOS
    }

    let(:dsl_with_execute) {
      erbh(<<-EOS)
        create_table "authors", <%= i cond('>= 5.1',id: :integer) + {force: :cascade} %> do |t|
          t.string "name", null: false
        end

        create_table "books", <%= i cond('>= 5.1',id: :integer) + {force: :cascad} %>e do |t|
          t.string  "title", null: false
          t.integer "author_id", null: false
          t.index ["author_id"], name: "idx_author_id", <%= i cond(5.0, using: :btree) %>
        end

        execute("ALTER TABLE books ADD CONSTRAINT fk_author FOREIGN KEY (author_id) REFERENCES authors (id)") do |c|
          c.raw_connection.query("SELECT 1 FROM information_schema.key_column_usage WHERE TABLE_SCHEMA = '<%= TEST_SCHEMA %>' AND CONSTRAINT_NAME = 'fk_author' LIMIT 1").each.length.zero?
        end

        add_foreign_key "books", "authors", name: "fk_author"
      EOS
    }

    before { subject.diff(dsl_with_execute).migrate }
    subject { client }

    it {
      delta = subject.diff(dsl_with_execute)
      expect(delta.differ?).to be_truthy
      expect(subject.dump).to match_ruby dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS)
        CREATE TABLE `books` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` int(11) NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) <%= cond(5.0, 'USING BTREE') %>,
          CONSTRAINT `fk_author` FOREIGN KEY (`author_id`) REFERENCES `authors` (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS

      migrated, out = delta.migrate
      expect(migrated).to be_falsey
      expect(subject.dump).to match_ruby dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS)
        CREATE TABLE `books` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` int(11) NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) <%= cond(5.0, 'USING BTREE') %>,
          CONSTRAINT `fk_author` FOREIGN KEY (`author_id`) REFERENCES `authors` (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS
    }
  end

  context 'when execute (noop)' do
    let(:dsl) {
      erbh(<<-EOS)
        create_table "authors", <%= i cond('>= 5.1',id: :integer) + {force: :cascade} %> do |t|
          t.string "name", null: false
        end

        create_table "books", <%= i cond('>= 5.1',id: :integer) + {force: :cascad} %>e do |t|
          t.string  "title", null: false
          t.integer "author_id", null: false
          t.index ["author_id"], name: "idx_author_id", <%= i cond(5.0, using: :btree) %>
        end
      EOS
    }

    let(:dsl_with_execute) {
      erbh(<<-EOS)
        create_table "authors", <%= i cond('>= 5.1',id: :integer) + {force: :cascade} %> do |t|
          t.string "name", null: false
        end

        create_table "books", <%= i cond('>= 5.1',id: :integer) + {force: :cascad} %>e do |t|
          t.string  "title", null: false
          t.integer "author_id", null: false
          t.index ["author_id"], name: "idx_author_id", <%= i cond(5.0, using: :btree) %>
        end

        execute("ALTER TABLE books ADD CONSTRAINT fk_author FOREIGN KEY (author_id) REFERENCES authors (id)") do |c|
          c.raw_connection.query("SELECT 1 FROM information_schema.key_column_usage WHERE TABLE_SCHEMA = '<%= TEST_SCHEMA %>' AND CONSTRAINT_NAME = 'fk_author' LIMIT 1").each.length.zero?
        end
      EOS
    }

    before { subject.diff(dsl).migrate }
    subject { client }

    it {
      delta = subject.diff(dsl_with_execute)
      expect(delta.differ?).to be_truthy
      expect(subject.dump).to match_ruby dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS)
        CREATE TABLE `books` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` int(11) NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) <%= cond(5.0, 'USING BTREE') %>
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS

      migrated, sql = delta.migrate(:noop => true)
      expect(migrated).to be_truthy
      expect(subject.dump).to match_ruby dsl

      expect(sql).to match_fuzzy "ALTER TABLE books ADD CONSTRAINT fk_author FOREIGN KEY (author_id) REFERENCES authors (id)"

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS)
        CREATE TABLE `books` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` int(11) NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) <%= cond(5.0, 'USING BTREE') %>
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS
    }
  end

  context 'when not execute (noop)' do
    let(:dsl) {
      erbh(<<-EOS)
        create_table "authors", <%= i cond('>= 5.1',id: :integer) + {force: :cascade} %> do |t|
          t.string "name", null: false
        end

        create_table "books", <%= i cond('>= 5.1',id: :integer) + {force: :cascad} %>e do |t|
          t.string  "title", null: false
          t.integer "author_id", null: false
          t.index ["author_id"], name: "idx_author_id", <%= i cond(5.0, using: :btree) %>
        end
        add_foreign_key "books", "authors", name: "fk_author"
      EOS
    }

    let(:dsl_with_execute) {
      erbh(<<-EOS)
        create_table "authors", <%= i cond('>= 5.1',id: :integer) + {force: :cascade} %> do |t|
          t.string "name", null: false
        end

        create_table "books", <%= i cond('>= 5.1',id: :integer) + {force: :cascad} %>e do |t|
          t.string  "title", null: false
          t.integer "author_id", null: false
          t.index ["author_id"], name: "idx_author_id", <%= i cond(5.0, using: :btree) %>
        end

        execute("ALTER TABLE books ADD CONSTRAINT fk_author FOREIGN KEY (author_id) REFERENCES authors (id)") do |c|
          c.raw_connection.query("SELECT 1 FROM information_schema.key_column_usage WHERE TABLE_SCHEMA = '<%= TEST_SCHEMA %>' AND CONSTRAINT_NAME = 'fk_author' LIMIT 1").each.length.zero?
        end

        add_foreign_key "books", "authors", name: "fk_author"
      EOS
    }

    before { subject.diff(dsl_with_execute).migrate }
    subject { client }

    it {
      delta = subject.diff(dsl_with_execute)
      expect(delta.differ?).to be_truthy
      expect(subject.dump).to match_ruby dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS)
        CREATE TABLE `books` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` int(11) NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) <%= cond(5.0, 'USING BTREE') %>,
          CONSTRAINT `fk_author` FOREIGN KEY (`author_id`) REFERENCES `authors` (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS

      migrated, sql = delta.migrate(:noop => true)
      expect(migrated).to be_falsey
      expect(subject.dump).to match_ruby dsl

      expect(sql).to match_fuzzy ""

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS)
        CREATE TABLE `books` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` int(11) NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) <%= cond(5.0, 'USING BTREE') %>,
          CONSTRAINT `fk_author` FOREIGN KEY (`author_id`) REFERENCES `authors` (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS
    }
  end
end