# rubocop:disable Metrics/LineLength
describe 'sql scripts' do
  before do
    allow(SqlMigrations::Config).to receive(:databases) { { default: {}, test2_db: {} } }
  end

  context 'valid scripts set' do
    before do
      Dir.mkdir('/migrations')
      Dir.mkdir('/seeds')

      File.open('/migrations/20150305_154010_first_test_migration.sql', 'w') do |f|
        f.puts 'CREATE TABLE first_test_table(col_int1 INTEGER, col_str1 STRING)'
      end
      File.open('/migrations/20150305_154011_second_test_migration.sql', 'w') do |f|
        f.puts 'CREATE TABLE second_test_table(col_int2 INTEGER, col_str2 STRING)'
      end
      File.open('/seeds/20150305_154010_test_seed.sql', 'w') do |f|
        f.puts 'INSERT INTO first_test_table(col_int1, col_str1) VALUES(123, "test_string1")'
        f.puts 'INSERT INTO second_test_table(col_int2, col_str2) VALUES(456, "test_string2")'
      end

      Dir.mkdir('/migrations/test2_db')
      File.open('/migrations/test2_db/20150511_144000_second_db_test_migration.sql', 'w') do |f|
        f.puts 'CREATE TABLE second_db_test_table(col_int1 INTEGER, col_str1 STRING)'
      end

      Dir.mkdir('/migrations/default')
      File.open('/migrations/default//20150511_144100_default_db_test2_migration.sql', 'w') do |f|
        f.puts 'CREATE TABLE default_db_test2_table(col_int1 INTEGER, col_str1 STRING)'
      end
    end

    it 'should be found' do
      expect { SqlMigrations.scripts }.to \
        output("Migration `/migrations/20150305_154010_first_test_migration.sql` for `default` database\n" \
               "Migration `/migrations/20150305_154011_second_test_migration.sql` for `default` database\n" \
               "Migration `/migrations/default/20150511_144100_default_db_test2_migration.sql` for `default` database\n" \
               "Seed `/seeds/20150305_154010_test_seed.sql` for `default` database\n" \
               "Migration `/migrations/test2_db/20150511_144000_second_db_test_migration.sql` for `test2_db` database\n"
              ).to_stdout
    end

    it 'should raise an error if two files of same type with same timestamp are present' do
      File.open('/migrations/default/20150511_144100_duplicated_timestamp_migration.sql', 'w') do |f|
        f.puts 'CREATE TABLE duplicated_migration(col_int1 INTEGER)'
      end

      expect { SqlMigrations.scripts }.to raise_error(RuntimeError, /Duplicate time for migrations: .*/)
    end
  end

  context 'invalid files' do
    before do
      Dir.mkdir('/migrations')
      File.open('/migrations/20150511_144100_test_migration.sql', 'w') do |f|
        f.puts 'CREATE TABLE test_migration(col_int1 INTEGER)'
      end
      File.open('/migrations/.20150511_144100_testp_migration.sql.swp', 'w') do |f|
        f.puts 'CREATE TABLE testd_migration(col_int1 INTEGER)'
      end
    end

    it 'should not find .*sw? files' do
      expect { SqlMigrations.scripts }
        .to output("Migration `/migrations/20150511_144100_test_migration.sql` for `default` database\n")
        .to_stdout
    end
  end
end
# rubocop:enable Metrics/LineLength