public void current_version_returns_missing_control_table_when_there_is_a_database_but_no_history_table() { database = "db_" + Guid.NewGuid().ToString("N"); var sqlserver = new SqlServerCommander(CreateConnection, null, database); using (IDbConnection connection = CreateConnection()) { connection.Open(); using (IDbCommand cmd = connection.CreateCommand()) { cmd.CommandText = string.Format("create database {0}", database); object result = cmd.ExecuteNonQuery(); } } DatabaseVersion version = sqlserver.CurrentVersion(); Assert.AreEqual(DatabaseVersionType.MissingMigrationHistoryTable, version.Type); }
public void current_version_returns_not_created_when_there_is_no_database() { var sqlserver = new SqlServerCommander(CreateConnection); DatabaseVersion version = sqlserver.CurrentVersion(); Assert.AreEqual(DatabaseVersionType.NotCreated, version.Type); }
public void get_correct_version_number() { var sqlserver = new SqlServerCommander(CreateDatabaseConnection); database = sqlserver.Create(); sqlserver.ExecuteMigration(new Migration { Number = "20150101", Sql = "create table test (id int primary key clustered)" }); sqlserver.ExecuteMigration(new Migration { Number = "20150102", Sql = "create table test2 (id int primary key clustered)" }); DatabaseVersion version = sqlserver.CurrentVersion(); Assert.AreEqual(DatabaseVersionType.VersionNumber, version.Type); Assert.AreEqual("20150102", version.Number); }