Contents

require "spec_helper"

describe Scheman::Diff do
  let(:instance) do
    described_class.new(args)
  end

  let(:args) do
    {
      before: before_schema,
      after: after_schema,
      type: type,
    }
  end

  let(:type) do
    "mysql"
  end

  let(:before_schema) do
    <<-EOS.strip_heredoc
      CREATE TABLE `table1` (
        `column1` INTEGER(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
        `column2` DATETIME DEFAULT NOW()
      );

      CREATE TABLE `table2` (
        `column1` INTEGER(11) NOT NULL AUTO_INCREMENT,
        PRIMARY KEY (`column1`)
      );
    EOS
  end

  let(:after_schema) do
    <<-EOS.strip_heredoc
      CREATE TABLE `table1` (
        `column1` CHAR(11) NOT NULL AUTO_INCREMENT,
        `column2` DATETIME DEFAULT CURRENT_TIMESTAMP(),
        `column3` VARCHAR(255) NOT NULL DEFAULT "a",
        PRIMARY KEY (`column2`)
      );

      CREATE TABLE `table3` (
        `column1` INTEGER(11) NOT NULL AUTO_INCREMENT,
        PRIMARY KEY (`column1`)
      );
    EOS
  end

  describe "#to_s" do
    subject do
      instance.to_s
    end

    it "returns a diff in SQL" do
      should == <<-EOS.strip_heredoc
        BEGIN;

        SET foreign_key_checks=0;

        CREATE TABLE `table3` (
          `column1` INTEGER(11) NOT NULL AUTO_INCREMENT,
          PRIMARY KEY (`column1`)
        );

        ALTER TABLE `table1` ADD COLUMN `column3` VARCHAR(255) NOT NULL DEFAULT "a",
          CHANGE COLUMN `column1` CHAR(11) NOT NULL AUTO_INCREMENT,
          DROP PRIMARY KEY,
          ADD PRIMARY KEY `column2`;

        DROP TABLE `table2`;

        SET foreign_key_checks=1;

        COMMIT;
      EOS
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
scheman-0.0.6	spec/scheman/diff_spec.rb
scheman-0.0.5	spec/scheman/diff_spec.rb
scheman-0.0.4	spec/scheman/diff_spec.rb