public static void should_not_have_column_in_any_indexestables(this ITestDbUtils db, IndexesTableNames tableNames, string columnName)
{
var columnsPerTable = tableNames.All
.GroupBy(t => t)
.Select(t => new { Name = t.Key, HasRowId = db.GetColumns(t.Key).Any(c => c.Name == columnName) }).ToArray();
columnsPerTable.Count(v => v.HasRowId).ShouldEqual(0);
}
public static void should_have_been_deleted_from_indexes_tables(this ITestDbUtils db, IStructureSchema structureSchema, object structureId)
{
var indexesTableNames = structureSchema.GetIndexesTableNames();
foreach (var indexesTableName in indexesTableNames.All)
{
db.RowCount(indexesTableName, "{0} = '{1}'".Inject(IndexStorageSchema.Fields.StructureId.Name, structureId)).ShouldEqual(0);
}
}
public static void should_not_have_been_deleted_from_indexes_tables(this ITestDbUtils db, IStructureSchema structureSchema, object structureId)
{
var indexesTableNames = structureSchema.GetIndexesTableNames();
var countSum = 0;
foreach (var indexesTableName in indexesTableNames.All)
{
countSum += db.RowCount(indexesTableName, "{0} = '{1}'".Inject(IndexStorageSchema.Fields.StructureId.Name, structureId));
}
countSum.ShouldBeGreaterThan(0);
}
public static void should_not_have_stored_member_in_indexes_table <T>(this ITestDbUtils db, IStructureSchema structureSchema, object structureId, Expression <Func <T, object> > memberExpression, Type memberType)
{
var memberPath = GetMemberPath(memberExpression);
structureSchema.IndexAccessors.Count(iac => iac.Path == memberPath).ShouldEqual(0);
var tablename = structureSchema.GetIndexesTableNames().GetNameByType(DataTypeConverter.Convert(memberType, memberPath));
db.RowCount(tablename, "{0} = '{1}' and {2} = '{3}'".Inject(
IndexStorageSchema.Fields.StructureId.Name, structureId,
IndexStorageSchema.Fields.MemberPath.Name, memberPath)).ShouldEqual(0);
}
public static void should_not_have_been_deleted_from_uniques_table(this ITestDbUtils db, IStructureSchema structureSchema, object structureId)
{
db.RowCount(structureSchema.GetUniquesTableName(), "{0} = '{1}'".Inject(UniqueStorageSchema.Fields.StructureId.Name, structureId)).ShouldEqual(1);
}
public static void should_not_have_column(this ITestDbUtils db, string tablename, string columnName)
{
db.GetColumns(tablename)
.SingleOrDefault(c => c.Name == columnName)
.ShouldBeNull();
}
public static void should_have_been_deleted_from_spatial_table(this ITestDbUtils db, IStructureSchema structureSchema, object structureId)
{
db.RowCount(structureSchema.GetSpatialTableName(), "{0} = '{1}'".Inject(SpatialStorageSchema.Fields.Id.Name, structureId)).ShouldEqual(0);
}
