describe 'Ridgepole::Client#diff -> migrate' do
  let(:template_variables) {
    opts = {
      sql_int_type: 'int(11)',
      test_schema: TEST_SCHEMA,
    }

    if condition(:mysql_awesome_enabled)
      opts[:sql_int_type] = 'int(10) unsigned'
    end

    opts
  }

  context 'when execute' do
    let(:dsl) {
      erbh(<<-EOS, template_variables)
        create_table "authors", <%= i unsigned(true) + {force: :cascade} %> do |t|
          t.string "name", <%= i limit(255) + {null: false} %>
        end

        create_table "books", <%= i unsigned(true) + {force: :cascade} %> do |t|
          t.string  "title",     <%= i limit(255) + {null: false} %>
          t.integer "author_id", <%= i limit(4) + {null: false} + unsigned(true) %>
        end

        <%= add_index "books", ["author_id"], name: "idx_author_id", using: :btree %>
      EOS
    }

    let(:dsl_with_execute) {
      erbh(<<-EOS, template_variables)
        create_table "authors", force: :cascade do |t|
          t.string "name", null: false
        end

        create_table "books", force: :cascade do |t|
          t.string  "title",                     null: false
          t.integer "author_id", <%= i limit(4) + {null: false} + unsigned(true) %>
        end

        <%= add_index "books", ["author_id"], name: "idx_author_id", using: :btree %>

        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_fuzzy dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS, template_variables)
        CREATE TABLE `books` (
          `id` <%= @sql_int_type %> NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` <%= @sql_int_type %> NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) 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, template_variables)
        CREATE TABLE `books` (
          `id` <%= @sql_int_type %> NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` <%= @sql_int_type %> NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) 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, template_variables)
        create_table "authors", force: :cascade do |t|
          t.string "name", <%= i limit(255) + {null: false} %>
        end

        create_table "books", force: :cascade do |t|
          t.string  "title",     <%= i limit(255) + {null: false} %>
          t.integer "author_id", <%= i limit(4) + {null: false} %>
        end

        <%= add_index "books", ["author_id"], name: "idx_author_id", using: :btree %>
        add_foreign_key "books", "authors", name: "fk_author"
      EOS
    }

    let(:dsl_with_execute) {
      erbh(<<-EOS, template_variables)
        create_table "authors", force: :cascade do |t|
          t.string "name", null: false
        end

        create_table "books", force: :cascade do |t|
          t.string  "title",                     null: false
          t.integer "author_id", <%= i limit(4) + {null: false} %>
        end

        <%= add_index "books", ["author_id"], name: "idx_author_id", using: :btree %>

        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_fuzzy dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS, template_variables)
        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`) 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_fuzzy dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS, template_variables)
        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`) 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, template_variables)
        create_table "authors", <%= i unsigned(true) + {force: :cascade} %> do |t|
          t.string "name", <%= i limit(255) + {null: false} %>
        end

        create_table "books", <%= i unsigned(true) + {force: :cascade} %> do |t|
          t.string  "title",     <%= i limit(255) + {null: false} %>
          t.integer "author_id", <%= i limit(4) + {null: false} + unsigned(true) %>
        end

        <%= add_index "books", ["author_id"], name: "idx_author_id", using: :btree %>
      EOS
    }

    let(:dsl_with_execute) {
      erbh(<<-EOS, template_variables)
        create_table "authors", force: :cascade do |t|
          t.string "name", null: false
        end

        create_table "books", force: :cascade do |t|
          t.string  "title",                     null: false
          t.integer "author_id", <%= i limit(4) + {null: false} + unsigned(true) %>
        end

        <%= add_index "books", ["author_id"], name: "idx_author_id", using: :btree %>

        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_fuzzy dsl

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

      migrated, sql = delta.migrate(:noop => true)
      expect(migrated).to be_truthy
      expect(subject.dump).to match_fuzzy 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, template_variables)
        CREATE TABLE `books` (
          `id` <%= @sql_int_type %> NOT NULL AUTO_INCREMENT,
          `title` varchar(255) NOT NULL,
          `author_id` <%= @sql_int_type %> NOT NULL,
          PRIMARY KEY (`id`),
          KEY `idx_author_id` (`author_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS
    }
  end

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

        create_table "books", force: :cascade do |t|
          t.string  "title",     <%= i limit(255) + {null: false} %>
          t.integer "author_id", <%= i limit(4) + {null: false} %>
        end

        <%= add_index "books", ["author_id"], name: "idx_author_id", using: :btree %>
        add_foreign_key "books", "authors", name: "fk_author"
      EOS
    }

    let(:dsl_with_execute) {
      erbh(<<-EOS, template_variables)
        create_table "authors", force: :cascade do |t|
          t.string "name", null: false
        end

        create_table "books", force: :cascade do |t|
          t.string  "title",                     null: false
          t.integer "author_id", <%= i limit(4) + {null: false} %>
        end

        <%= add_index "books", ["author_id"], name: "idx_author_id", using: :btree %>

        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_fuzzy dsl

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS, template_variables)
        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`) 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_fuzzy dsl

      expect(sql).to match_fuzzy ""

      expect(show_create_table(:books)).to match_fuzzy erbh(<<-EOS, template_variables)
        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`) USING BTREE,
          CONSTRAINT `fk_author` FOREIGN KEY (`author_id`) REFERENCES `authors` (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      EOS
    }
  end
end