unless postgresql?
if mysql_awesome_enabled?
  describe 'Ridgepole::Client#diff -> migrate' do
    context 'when change column (add collation)' do
      let(:actual_dsl) {
        <<-RUBY
          create_table "employee_clubs", unsigned: true, force: :cascade do |t|
            t.integer "emp_no",  limit: 4,     null: false
            t.integer "club_id", limit: 4,     null: false, unsigned: true
            t.string  "string",  limit: 255,   null: false
            t.text    "text",    limit: 65535, null: false
          end
        RUBY
      }

      let(:expected_dsl) {
        <<-RUBY
          create_table "employee_clubs", unsigned: true, force: :cascade do |t|
            t.integer "emp_no",  limit: 4,     null: false
            t.integer "club_id", limit: 4,     null: false, unsigned: true
            t.string  "string",  limit: 255,   null: false,                 collation: "ascii_bin"
            t.text    "text",    limit: 65535, null: false,                 collation: "utf8mb4_bin"
          end
        RUBY
      }

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

      it {
        delta = subject.diff(expected_dsl)
        expect(delta.differ?).to be_truthy
        expect(subject.dump).to eq actual_dsl.strip_heredoc.strip
        delta.migrate
        expect(subject.dump).to eq expected_dsl.strip_heredoc.strip
      }
    end

    context 'when change column (delete collation)' do
      let(:actual_dsl) {
        <<-RUBY
          create_table "employee_clubs", unsigned: true, force: :cascade do |t|
            t.integer "emp_no",  limit: 4,     null: false
            t.integer "club_id", limit: 4,     null: false, unsigned: true
            t.string  "string",  limit: 255,   null: false,                 collation: "ascii_bin"
            t.text    "text",    limit: 65535, null: false,                 collation: "utf8mb4_bin"
          end
        RUBY
      }

      let(:expected_dsl) {
        <<-RUBY
          create_table "employee_clubs", unsigned: true, force: :cascade do |t|
            t.integer "emp_no",  limit: 4,     null: false
            t.integer "club_id", limit: 4,     null: false, unsigned: true
            t.string  "string",  limit: 255,   null: false
            t.text    "text",    limit: 65535, null: false
          end
        RUBY
      }

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

      it {
        delta = subject.diff(expected_dsl)
        expect(delta.differ?).to be_truthy
        expect(subject.dump).to eq actual_dsl.strip_heredoc.strip
        delta.migrate
        expect(subject.dump).to eq expected_dsl.strip_heredoc.strip
      }
    end

    context 'when change column (change collation)' do
      let(:actual_dsl) {
        <<-RUBY
          create_table "employee_clubs", unsigned: true, force: :cascade do |t|
            t.integer "emp_no",  limit: 4,     null: false
            t.integer "club_id", limit: 4,     null: false, unsigned: true
            t.string  "string",  limit: 255,   null: false,                 collation: "ascii_bin"
            t.text    "text",    limit: 65535, null: false,                 collation: "utf8mb4_bin"
          end
        RUBY
      }

      let(:expected_dsl) {
        <<-RUBY
          create_table "employee_clubs", unsigned: true, force: :cascade do |t|
            t.integer "emp_no",  limit: 4,     null: false
            t.integer "club_id", limit: 4,     null: false, unsigned: true
            t.string  "string",  limit: 255,   null: false,                 collation: "utf8mb4_bin"
            t.text    "text",    limit: 65535, null: false,                 collation: "ascii_bin"
          end
        RUBY
      }

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

      it {
        delta = subject.diff(expected_dsl)
        expect(delta.differ?).to be_truthy
        expect(subject.dump).to eq actual_dsl.strip_heredoc.strip
        delta.migrate
        expect(subject.dump).to eq expected_dsl.strip_heredoc.strip
      }
    end

    context 'when change column (no change collation)' do
      let(:actual_dsl) {
        <<-RUBY
          create_table "employee_clubs", unsigned: true, force: :cascade do |t|
            t.integer "emp_no",  limit: 4,     null: false
            t.integer "club_id", limit: 4,     null: false, unsigned: true
            t.string  "string",  limit: 255,   null: false,                 collation: "ascii_bin"
            t.text    "text",    limit: 65535, null: false,                 collation: "utf8mb4_bin"
          end
        RUBY
      }

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

      it {
        delta = subject.diff(actual_dsl)
        expect(delta.differ?).to be_falsey
        expect(subject.dump).to eq actual_dsl.strip_heredoc.strip
        delta.migrate
        expect(subject.dump).to eq actual_dsl.strip_heredoc.strip
      }

      describe '#diff' do
        it {
          Tempfile.open("#{File.basename __FILE__}.#{$$}") do |f|
            f.puts(actual_dsl)
            f.flush

            out, status = run_ridgepole('--diff', "'#{JSON.dump(conn_spec)}'", f.path, '--enable-mysql-awesome', '--dump-without-table-options')

            expect(out).to be_empty
            expect(status.success?).to be_truthy
          end
        }
      end
    end
  end
end
end