public void Schema_Create_Should_Contain_SQL(string dbType)
{
// Arrange
SchemaBase schema = SchemaLookup.FromName(dbType);
DbCommandStub dbCommand = new DbCommandStub();
// Act
schema.Create(dbCommand);
// Assert
Assert.That(dbCommand.CommandText, Is.StringContaining("CREATE TABLE"));
}
public void Schema_Drop_Should_Contain_SQL(string dbType)
{
// Arrange
SchemaBase schema = SchemaLookup.FromName(dbType);
DbCommandStub dbCommand = new DbCommandStub();
// Act
schema.Drop(dbCommand);
// Assert
Assert.That(dbCommand.CommandText, Is.StringContaining("DROP"));
}
public void Schema_Upgrade_Should_Contain_SQL(string dbType)
{
// Arrange
SchemaBase schema = DataStoreType.ByName(dbType).Schema;
DbCommandStub dbCommand = new DbCommandStub();
// Act
schema.Upgrade(dbCommand);
// Assert
Assert.That(dbCommand.CommandText, Is.StringContaining("CREATE"));
}
