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); }