public void TestDatabaseSimple()
{
var tables = new TestDatabaseSimple().GetTables();
Assert.AreEqual(1, tables.Count);
Assert.AreEqual("Company", tables[0].SchemaAndTableName.TableName);
}
public void TestDatabaseSimple()
{
var tables = new TestDatabaseSimple().GetTables();
var cfks = tables[0].Properties.OfType <CircularFK>().Count();
Assert.AreEqual(0, cfks);
}
protected static DatabaseDefinitions Index_Add_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddWithNewIndex = new TestDatabaseIndex();
ddWithNewIndex.SetVersions(version.GetTypeMapper());
return(new DatabaseDefinitions(ddOriginal, ddWithNewIndex, "TestDatabaseSimple", "TestDatabaseIndex_Index_Add"));
}
protected static DatabaseDefinitions Table_Remove_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
AddTable(ddOriginal);
var ddWithoutNewTable = new TestDatabaseSimple();
ddWithoutNewTable.SetVersions(version.GetTypeMapper());
return(new DatabaseDefinitions(ddOriginal, ddWithoutNewTable, "TestDatabaseSimple", "TestDatabaseSimple_Table_Remove"));
}
protected static DatabaseDefinitions Column_Change_Nullable_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddNullableChanged = new TestDatabaseSimple();
ddNullableChanged.SetVersions(version.GetTypeMapper());
ddNullableChanged.GetTable("Company")["Name"].Type.IsNullable = !ddOriginal.GetTable("Company")["Name"].Type.IsNullable;
return(new DatabaseDefinitions(ddOriginal, ddNullableChanged, "TestDatabaseSimple", "TestDatabaseSimple_Column_Change_Nullable"));
}
protected static DatabaseDefinitions Column_Remove_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddColumnRemoved = new TestDatabaseSimple();
ddColumnRemoved.SetVersions(version.GetTypeMapper());
ddColumnRemoved.GetTable("Company").Columns.Remove("Name");
return(new DatabaseDefinitions(ddOriginal, ddColumnRemoved, "TestDatabaseSimple", "TestDatabaseSimple_Column_Remove"));
}
protected static DatabaseDefinitions Column_Add_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddWithNewColumn = new TestDatabaseSimple();
ddWithNewColumn.SetVersions(version.GetTypeMapper());
ddWithNewColumn.GetTable("Company").AddVarChar("Name2", 100);
return(new DatabaseDefinitions(ddOriginal, ddWithNewColumn, "TestDatabaseSimple", "TestDatabaseSimple_Column_Add"));
}
private static void AddTable(TestDatabaseSimple dd)
{
var newTable = new SqlTable
{
SchemaAndTableName = "NewTableToMigrate"
};
newTable.AddInt32("Id", false).SetPK().SetIdentity();
new PrimaryKeyNamingDefaultStrategy().SetPrimaryKeyName(newTable.Properties.OfType <PrimaryKey>().First());
newTable.AddNVarChar("Name", 100);
dd.AddTable(newTable);
}
protected static DatabaseDefinitions Identity_Change_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddIdentityChanged = new TestDatabaseSimple();
ddIdentityChanged.SetVersions(version.GetTypeMapper());
var identity = ddIdentityChanged.Company.Columns["Id"].Properties.OfType <Identity>().First();
identity.Increment = 2;
return(new DatabaseDefinitions(ddOriginal, ddIdentityChanged, "TestDatabaseSimple", "TestDatabaseSimple_Identity_Change"));
}
protected static DatabaseDefinitions Column_Change2_Length_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
ddOriginal.GetTable("Company").AddNVarChar("Name2", 100);
var ddColumnLengthsChanged = new TestDatabaseSimple();
ddColumnLengthsChanged.SetVersions(version.GetTypeMapper());
ddColumnLengthsChanged.GetTable("Company").AddNVarChar("Name2", 100);
ddColumnLengthsChanged.GetTable("Company")["Name"].Type.Length += 1;
ddColumnLengthsChanged.GetTable("Company")["Name2"].Type.Length += 1;
return(new DatabaseDefinitions(ddOriginal, ddColumnLengthsChanged, "TestDatabaseSimple", "TestDatabaseSimple_Column_Change2_Length"));
}
protected static DatabaseDefinitions Column_Change_DbType_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddDbTypeChanged = new TestDatabaseSimple();
ddDbTypeChanged.SetVersions(version.GetTypeMapper());
if (version == MsSqlVersion.MsSql2016)
{
ddDbTypeChanged.GetTable("Company")["Name"].Type.SqlTypeInfo = MsSqlType2016.NChar;
}
else if (version == OracleVersion.Oracle12c)
{
ddDbTypeChanged.GetTable("Company")["Name"].Type.SqlTypeInfo = OracleType12c.NChar;
}
return(new DatabaseDefinitions(ddOriginal, ddDbTypeChanged, "TestDatabaseSimple", "TestDatabaseSimple_Column_Change_DbType"));
}
protected static DatabaseDefinitions Pk_Add_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseSimple();
ddOriginal.GetTable("Company").Columns["Id"].Properties.Remove(
ddOriginal.GetTable("Company").Columns["Id"].Properties.OfType <Identity>().First()
);
ddOriginal.GetTable("Company").Properties.Remove(
ddOriginal.GetTable("Company").Properties.OfType <PrimaryKey>().First()
);
ddOriginal.SetVersions(version.GetTypeMapper());
var ddWithPk = new TestDatabaseSimple();
ddWithPk.SetVersions(version.GetTypeMapper());
ddWithPk.GetTable("Company").Columns["Id"].Properties.Remove(
ddWithPk.GetTable("Company").Columns["Id"].Properties.OfType <Identity>().First()
);
return(new DatabaseDefinitions(ddOriginal, ddWithPk, "TestDatabaseSimple", "TestDatabaseSimple_Pk_Add"));
}