public void FindSequence()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
Name = "MySequence",
SchemaOwner = Schema,
SchemaObjectType = SchemaObjectType.Sequence
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseSequence>(find);
}
public void FindTable()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
Name = "Orders",
SchemaOwner = Schema,
SchemaObjectType = SchemaObjectType.Table
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseTable>(find);
}
public void FindView()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
Name = "MyView",
SchemaOwner = Schema,
SchemaObjectType = SchemaObjectType.View
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseView>(find);
}
public void FindFunction()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
Name = "MyFunction",
SchemaOwner = Schema,
SchemaObjectType = SchemaObjectType.Function
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseFunction>(find);
}
public void FindProcedure()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
Name = "MySproc",
SchemaOwner = Schema,
SchemaObjectType = SchemaObjectType.StoredProcedure
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseStoredProcedure>(find);
}
public void FindUniqueConstraint()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
TableName = "Orders",
SchemaOwner = Schema,
Name = "UK_NAME",
SchemaObjectType = SchemaObjectType.Constraint
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseConstraint>(find);
}
public void FindColumn()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
TableName = "Orders",
SchemaOwner = Schema,
Name = "Name",
SchemaObjectType = SchemaObjectType.Column
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseColumn>(find);
}
public void FindIndex()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
TableName = "Orders",
SchemaOwner = Schema,
Name = "IDX_Desc",
SchemaObjectType = SchemaObjectType.Index
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseIndex>(find);
}
public void FindForeignKey()
{
//arrange
DatabaseSchema schema = CreateSchema();
var result = new CompareResult
{
TableName = "Order_Line",
SchemaOwner = Schema,
Name = "FK_OrderLine_Orders",
SchemaObjectType = SchemaObjectType.Constraint
};
//act
var find = result.Find(schema);
//assert
AssertType <DatabaseConstraint>(find);
}
