protected virtual void BulkInsertUniques(IStructureSchema structureSchema, IStructureIndex[] uniques) { if (!uniques.Any()) { return; } var uniquesStorageSchema = new UniqueStorageSchema(structureSchema, structureSchema.GetUniquesTableName()); using (var uniquesReader = new UniquesReader(uniquesStorageSchema, uniques)) { using (var bulkInserter = MainDbClient.GetBulkCopy()) { bulkInserter.DestinationTableName = uniquesReader.StorageSchema.Name; bulkInserter.BatchSize = uniques.Length; var fields = uniquesReader.StorageSchema.GetFieldsOrderedByIndex().Where(f => !f.Equals(StructureStorageSchema.Fields.RowId)).ToArray(); foreach (var field in fields) { bulkInserter.AddColumnMapping(field.Name, field.Name); } bulkInserter.Write(uniquesReader); } } }
public void GetFieldsOrderedByIndex_WhenPlainAndUniquesExistsInSchema_FieldsAreReturnedInCorrectOrder() { var structureSchema = CreateStructureSchemaFakeWithPlainAndUniques(); var uniqueStorageSchema = new UniqueStorageSchema(structureSchema, "foo"); var fieldsByIndex = uniqueStorageSchema.GetFieldsOrderedByIndex().ToList(); Assert.AreEqual(5, fieldsByIndex.Count); Assert.AreEqual(0, fieldsByIndex[0].Ordinal); Assert.AreEqual(UniqueStorageSchema.Fields.RowId.Name, fieldsByIndex[0].Name); Assert.AreEqual(1, fieldsByIndex[1].Ordinal); Assert.AreEqual(UniqueStorageSchema.Fields.StructureId.Name, fieldsByIndex[1].Name); Assert.AreEqual(2, fieldsByIndex[2].Ordinal); Assert.AreEqual(UniqueStorageSchema.Fields.UqStructureId.Name, fieldsByIndex[2].Name); Assert.AreEqual(3, fieldsByIndex[3].Ordinal); Assert.AreEqual(UniqueStorageSchema.Fields.UqMemberPath.Name, fieldsByIndex[3].Name); Assert.AreEqual(4, fieldsByIndex[4].Ordinal); Assert.AreEqual(UniqueStorageSchema.Fields.UqValue.Name, fieldsByIndex[4].Name); }
public UniquesReader(UniqueStorageSchema storageSchema, IEnumerable <IStructureIndex> items) : base(storageSchema, items) { }