public static async Task AnalyseTables_GivenTableWithNoIndexes_ProducesNoMessages()
{
var rule = new UniqueIndexWithNullableColumnsRule(RuleLevel.Error);
var table = new RelationalDatabaseTable(
"test",
new List <IDatabaseColumn>(),
null,
Array.Empty <IDatabaseKey>(),
Array.Empty <IDatabaseRelationalKey>(),
Array.Empty <IDatabaseRelationalKey>(),
Array.Empty <IDatabaseIndex>(),
Array.Empty <IDatabaseCheckConstraint>(),
Array.Empty <IDatabaseTrigger>()
);
var tables = new[] { table };
var hasMessages = await rule.AnalyseTables(tables).AnyAsync().ConfigureAwait(false);
Assert.That(hasMessages, Is.False);
}
public static async Task AnalyseTables_GivenTableWithNoNullableColumnsInUniqueIndex_ProducesNoMessages()
{
var rule = new UniqueIndexWithNullableColumnsRule(RuleLevel.Error);
var testColumn = new DatabaseColumn(
"test_column_1",
Mock.Of <IDbType>(),
false,
null,
null
);
var uniqueIndex = new DatabaseIndex(
"test_index_name",
true,
new[] { new DatabaseIndexColumn("test_column_1", testColumn, IndexColumnOrder.Ascending) },
Array.Empty <IDatabaseColumn>(),
true
);
var table = new RelationalDatabaseTable(
"test",
new List <IDatabaseColumn>(),
null,
Array.Empty <IDatabaseKey>(),
Array.Empty <IDatabaseRelationalKey>(),
Array.Empty <IDatabaseRelationalKey>(),
new[] { uniqueIndex },
Array.Empty <IDatabaseCheckConstraint>(),
Array.Empty <IDatabaseTrigger>()
);
var tables = new[] { table };
var hasMessages = await rule.AnalyseTables(tables).AnyAsync().ConfigureAwait(false);
Assert.That(hasMessages, Is.False);
}
public static void AnalyseTables_GivenNullTables_ThrowsArgumentNullException()
{
var rule = new UniqueIndexWithNullableColumnsRule(RuleLevel.Error);
Assert.That(() => rule.AnalyseTables(null), Throws.ArgumentNullException);
}
