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 UniqueConstraint_Change_NewColumn_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseUniqueConstraint();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddNew = new TestDatabaseUniqueConstraint2();
ddNew.SetVersions(version.GetTypeMapper());
return(new DatabaseDefinitions(ddOriginal, ddNew, "TestDatabaseUniqueConstraint", "TestDatabaseUniqueConstraint2"));
}
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_NotNullableToNullable_WithFk_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseFk();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddFkChanged = new TestDatabaseFk();
ddFkChanged.SetVersions(version.GetTypeMapper());
ddFkChanged.GetTable("Foreign")["PrimaryId"].Type.IsNullable = true;
return(new DatabaseDefinitions(ddOriginal, ddFkChanged, "ForeignKeyComposite", "ForeignKeyComposite2_Column_Change_NotNullableToNullable_WithFk"));
}
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 UniqueConstraint_Change_NewColumn_UcName_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseUniqueConstraint();
ddOriginal.SetVersions(version.GetTypeMapper());
ddOriginal.GetTable("Company").Properties.OfType <UniqueConstraint>().First().Name = "UC_1";
var ddUcChanged = new TestDatabaseUniqueConstraint2();
ddUcChanged.SetVersions(version.GetTypeMapper());
ddUcChanged.GetTable("Company").Properties.OfType <UniqueConstraint>().First().Name = "UC_1";
return(new DatabaseDefinitions(ddOriginal, ddUcChanged, "TestDatabaseUniqueConstraint", "TestDatabaseUniqueConstraint2_Change_NewColumn_UcName_Dds"));
}
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"));
}
protected static DatabaseDefinitions UniqueConstraint_Change_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseUniqueConstraint();
ddOriginal.SetVersions(version.GetTypeMapper());
ddOriginal.GetTable("Company").AddNVarChar("Name2", 100);
var ddNew = new TestDatabaseUniqueConstraint2();
ddNew.SetVersions(version.GetTypeMapper());
return(new DatabaseDefinitions(ddOriginal, ddNew, "TestDatabaseUniqueConstraint_Column_Add", "TestDatabaseUniqueConstraint2"));
}
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 Fk_Change_Composite_NameChange_Dds(SqlEngineVersion version)
{
var ddOriginal = new ForeignKeyComposite();
ddOriginal.GetTable("Order").AddInt32("LineNumber2");
ddOriginal.GetTable("Order").AddUniqueConstraintWithName("UQ_Order_OrderHeaderId_LineNumber_LineNumber2", "OrderHeaderId", "LineNumber", "LineNumber2");
ddOriginal.GetTable("TopOrdersPerCompany").AddInt32("Top2C");
ddOriginal.SetVersions(version.GetTypeMapper());
var ddFkChanged = new ForeignKeyComposite2();
ddFkChanged.SetVersions(version.GetTypeMapper());
return(new DatabaseDefinitions(ddOriginal, ddFkChanged, "ForeignKeyComposite", "ForeignKeyComposite2_Fk_Change_Composite_NameChange"));
}
protected static DatabaseDefinitions Fk_Add_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseFk();
ddOriginal.GetTable("Foreign").Properties.Remove(
ddOriginal.GetTable("Foreign").Properties.OfType <ForeignKey>().First()
);
ddOriginal.SetVersions(version.GetTypeMapper());
var ddWithFK = new TestDatabaseFk();
ddWithFK.SetVersions(version.GetTypeMapper());
return(new DatabaseDefinitions(ddOriginal, ddWithFK, "TestDatabaseFk", "TestDatabaseFk_Fk_Add"));
}
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 Fk_Change_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseFkChange();
ddOriginal.SetVersions(version.GetTypeMapper());
var ddFkChanged = new TestDatabaseFkChange();
ddFkChanged.GetTable("Foreign").Properties.Remove(
ddFkChanged.GetTable("Foreign").Properties.OfType <ForeignKey>().First()
);
ddFkChanged.GetTable("Foreign").Columns["PrimaryId"].SetForeignKeyToTable("Primary2", "FkChange");
ddFkChanged.SetVersions(version.GetTypeMapper());
return(new DatabaseDefinitions(ddOriginal, ddFkChanged, "TestDatabaseFkChange", "TestDatabaseFkChange_Fk_Change"));
}
protected static DatabaseDefinitions Index_Change_Dds(SqlEngineVersion version)
{
var ddOriginal = new TestDatabaseIndexMultiColumn();
ddOriginal.SetVersions(version.GetTypeMapper());
ddOriginal.GetTable("Company").Properties.Remove(
ddOriginal.GetTable("Company").Properties.OfType <Index>().First()
);
ddOriginal.GetTable("Company").AddIndexWithName(false, "IX_Company_Name", "Name1");
var ddWithChangedIndex = new TestDatabaseIndexMultiColumn();
ddWithChangedIndex.SetVersions(version.GetTypeMapper());
ddWithChangedIndex.GetTable("Company").Properties.OfType <Index>().First().Name = "IX_Company_Name";
return(new DatabaseDefinitions(ddOriginal, ddWithChangedIndex, "TestDatabaseIndexMultiColumn", "TestDatabaseIndexMultiColum_Index_Change"));
}
public void DocumentTestIndexMultiColumnAndInclude(SqlEngineVersion version)
{
var db = new TestDatabaseIndexMultiColumnAndInclude();
db.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "TestDatabaseIndexMultiColumnAndInclude");
documenter.Document(db);
}
public void DocumentTestForeignKeyComposite(SqlEngineVersion version)
{
var db = new ForeignKeyComposite();
db.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "ForeignKeyComposite");
documenter.Document(db);
}
public void TableCustomizerTest(SqlEngineVersion version)
{
var db = new TestDatabaseFks();
db.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version, new TableCustomizer()), version, "TestDatabaseFks");
documenter.Document(db);
}
public void DocumentTestUniqueConstraint(SqlEngineVersion version)
{
var db = new TestDatabaseUniqueConstraint();
db.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "TestDatabaseUniqueConstraint");
documenter.Document(db);
}
public void CircularDdA0B1C1_B2C2(SqlEngineVersion version)
{
var dd = new CircularDdA0B1C1_B2C2();
dd.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "CircularDdA0B1C1_B2C2");
documenter.Document(dd);
}
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"));
}
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 Fk_Change_Composite_NoNameChange_Dds(SqlEngineVersion version)
{
var ddOriginal = new ForeignKeyComposite();
ddOriginal.GetTable("Order").AddInt32("LineNumber2");
ddOriginal.GetTable("Order").AddUniqueConstraintWithName("UQ_Order_OrderHeaderId_LineNumber_LineNumber2", "OrderHeaderId", "LineNumber", "LineNumber2");
ddOriginal.GetTable("TopOrdersPerCompany").AddInt32("Top2C");
ddOriginal.SetVersions(version.GetTypeMapper());
var fkOriginal = ddOriginal
.GetTable("TopOrdersPerCompany").Properties
.OfType <ForeignKey>()
.First(fk => fk.ForeignKeyColumns.Any(fkcm => fkcm.ForeignKeyColumn.Name == "Top2A"));
fkOriginal.Name = "FK_TopOrdersPerCompany_2";
var ddFkChanged = new ForeignKeyComposite2();
ddFkChanged.SetVersions(version.GetTypeMapper());
return(new DatabaseDefinitions(ddOriginal, ddFkChanged, "ForeignKeyComposite", "ForeignKeyComposite2_Fk_Change_Composite_NoNameChange"));
}
public void CircularFKDetectorABC_X(SqlEngineVersion version)
{
var dd = new CircularDdABC_X();
dd.SetVersions(version.GetTypeMapper());
var documenter = new Documenter(DataDefinitionDocumenterTestsHelper.CreateTestDocumenterContext(version), version, "CircularDdABC_X");
documenter.Document(dd);
// TODO move to dd test
// CircularFKDetector.DectectCircularFKs(dd.GetTables());
// var cs = dd.GetTables().Select(t => t.Properties.OfType<CircularFK>()).ToList();
}
