public void execute_migration()
{
var sqlserver = new SqlServerCommander(CreateDatabaseConnection);
database = sqlserver.Create();
sqlserver.ExecuteMigration(new Migration
{
Number = "20150101",
Sql = "create table test (id int primary key clustered)"
});
using (IDbConnection connection = CreateConnection())
{
connection.Open();
using (IDbCommand cmd = connection.CreateCommand())
{
cmd.CommandText = string.Format("select count(*) from {0}.sys.tables where name='test'", database);
object result = cmd.ExecuteScalar();
Assert.AreEqual(1, result);
}
}
}
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);
}
