public void ReturnNullIfTableDoesNotExist()
{
SqlServerSchemaLoader loader = new SqlServerSchemaLoader();
TableSchema actual = loader.LoadTableSchema(ServerHelper.Connection, "NonExistingTable");
actual.Should().BeNull();
}
public void LoadCorrectTableSchema()
{
SqlServerSchemaLoader loader = new SqlServerSchemaLoader();
DatabaseSchema schema = loader.LoadSchema(ServerHelper.Connection);
CheckTableSchema(schema.Tables[TestSchemaTableName]);
}
public void NullablesTable_ShouldExists()
{
SqlServerSchemaLoader loader = new SqlServerSchemaLoader();
TableSchema schema = loader.LoadTableSchema(ServerHelper.Connection, NullablesTableName);
schema.Should().NotBeNull();
}
public void LoadCorrectIndexes()
{
SqlServerSchemaLoader loader = new SqlServerSchemaLoader();
DatabaseSchema schema = loader.LoadSchema(ServerHelper.Connection);
TableSchema table = schema.Tables["IndexesTest"];
table.PrimaryKey.Should().NotBeNull();
CheckIndex(table.PrimaryKey, IndexType.PrimaryKey,
new Tuple <string, Kros.Data.Schema.SortOrder>[] { Tuple.Create("Id", Kros.Data.Schema.SortOrder.Ascending) });
CheckIndex(table.Indexes["I_Index"], IndexType.Index, new Tuple <string, Kros.Data.Schema.SortOrder>[]
{
Tuple.Create("ColIndex1", Kros.Data.Schema.SortOrder.Ascending),
Tuple.Create("ColIndex2Desc", Kros.Data.Schema.SortOrder.Descending),
Tuple.Create("ColIndex3", Kros.Data.Schema.SortOrder.Ascending)
});
CheckIndex(table.Indexes["I_UniqueIndex"], IndexType.UniqueKey,
new Tuple <string, Kros.Data.Schema.SortOrder>[]
{
Tuple.Create("ColUniqueIndex", Kros.Data.Schema.SortOrder.Ascending)
});
}
public void LoadCorrectForeignKeys()
{
SqlServerSchemaLoader loader = new SqlServerSchemaLoader();
DatabaseSchema schema = loader.LoadSchema(ServerHelper.Connection);
TableSchema parentTable = schema.Tables["ParentTable"];
TableSchema childTableNoAction = schema.Tables["ChildTableNoAction"];
TableSchema childTableSetNull = schema.Tables["ChildTableSetNull"];
TableSchema childTableSetDefault = schema.Tables["ChildTableSetDefault"];
TableSchema childTableCascade = schema.Tables["ChildTableCascade"];
childTableNoAction.ForeignKeys.Count.Should().Be(1, "Tabuľka ChildTableNoAction by mala mať jeden cudzí kľúč.");
CheckForeignKey(childTableNoAction.ForeignKeys[0], "FK_ChildTableNoAction_ParentTable", ForeignKeyRule.NoAction);
childTableSetNull.ForeignKeys.Count.Should().Be(1, "Tabuľka ChildTableSetNull by mala mať jeden cudzí kľúč.");
CheckForeignKey(childTableSetNull.ForeignKeys[0], "FK_ChildTableSetNull_ParentTable", ForeignKeyRule.SetNull);
childTableSetDefault.ForeignKeys.Count.Should().Be(1, "Tabuľka ChildTableSetDefault by mala mať jeden cudzí kľúč.");
CheckForeignKey(childTableSetDefault.ForeignKeys[0], "FK_ChildTableSetDefault_ParentTable", ForeignKeyRule.SetDefault);
childTableCascade.ForeignKeys.Count.Should().Be(1, "Tabuľka ChildTableCascade by mala mať jeden cudzí kľúč.");
CheckForeignKey(childTableCascade.ForeignKeys[0], "FK_ChildTableCascade_ParentTable", ForeignKeyRule.Cascade);
}
public void LoadCorrectTableSchema2()
{
SqlServerSchemaLoader loader = new SqlServerSchemaLoader();
CheckTableSchema(loader.LoadTableSchema(ServerHelper.Connection, TestSchemaTableName));
}
