private async Task <bool> VerifyCollectionModel(IDocumentDatabase db, CollectionModel model) { (await db.CollectionExist(_workContext, _collectionName)).Should().BeTrue(); IDocumentCollection <TestDocument> collection = db.GetCollection <TestDocument>(_collectionName); foreach (var indexDetail in model.Indexes) { IndexDetailV1 detail = await collection.Index.GetIndexDetail(_workContext, indexDetail.Name); detail.Should().NotBeNull(); if (!indexDetail.IsEquals(detail)) { return(false); } } IEnumerable <IndexDetailV1> dbIndex = await collection.Index.ListIndexes(_workContext); dbIndex.Should().NotBeNull(); dbIndex.Count().Should().Be(model.Indexes.Count + 1); return(dbIndex .Where(x => x.Name != "_id_") .OrderBy(x => x.Name) .Zip(model.Indexes.OrderBy(x => x.Name), (d, m) => new { Db = d, Model = m }) .All(x => x.Model.IsEquals(x.Db))); }
public async Task CreateSingleIndexTest() { await _documentServer.DropDatabase(_workContext, _dbName); IDocumentDatabase db = _documentServer.GetDatabase(_workContext, _dbName); await db.CreateCollection(_workContext, _collectionName); IDocumentCollection <TestDocument> collection = db.GetCollection <TestDocument>(_collectionName); IEnumerable <IndexDetailV1> list = await collection.Index.ListIndexes(_workContext); list.Should().NotBeNull(); list.Count().Should().Be(1); list.First().Name.Should().Be("_id_"); var model = new CollectionIndex { Name = "TestIndex_1", Unique = true, Sparse = false, Keys = new List <IndexKey> { new IndexKey { FieldName = "FirstName" }, new IndexKey { FieldName = "Last Name" }, } }; await collection.Index.CreateIndex(_workContext, model); list = await collection.Index.ListIndexes(_workContext); list.Should().NotBeNull(); list.Count().Should().Be(2); list.First().Name.Should().Be("_id_"); IndexDetailV1 detail = list.Skip(1).First(); detail.Name.Should().Be(model.Name); detail.Unique.Should().Be(model.Unique); detail.Sparse.Should().Be(model.Sparse); detail.Keys.Count.Should().Be(model.Keys.Count); detail.Keys[0].FieldName.Should().Be(model.Keys[0].FieldName); detail.Keys[0].Descending.Should().Be(model.Keys[0].Descending); detail.Keys[1].FieldName.Should().Be(model.Keys[1].FieldName); detail.Keys[1].Descending.Should().Be(model.Keys[1].Descending); await db.DropCollection(_workContext, _collectionName); await _documentServer.DropDatabase(_workContext, _dbName); }
public async Task ApplyCappedCollectionModelWithIndex() { const int maxDocuments = 100; const int maxSizeInBytes = maxDocuments * 1000; var model = new CappedCollectionModel { CollectionName = _collectionName, MaxSizeInBytes = maxSizeInBytes, MaxNumberOfDocuments = maxDocuments, Indexes = new List <CollectionIndex> { new CollectionIndex { Name = "TestIndex_1", Unique = true, Keys = new List <IndexKey> { new IndexKey { FieldName = "Field1", Descending = false }, } } } }; var package = new CollectionModelPackage(_documentDatabase, model, new CollectionModelSettings { ReCreate = true }); bool result = await package.Apply(_workContext); result.Should().BeTrue(); (await _documentDatabase.CollectionExist(_workContext, _collectionName)).Should().BeTrue(); CollectionDetailV1 detail = await _documentDatabase.GetCollectionDetail(_workContext, _collectionName); detail.Should().NotBeNull(); detail.Name.Should().Be(_collectionName); detail.Type.Should().Be("collection"); detail.Readonly.Should().BeFalse(); detail.Capped.Should().BeTrue(); detail.MaxDocuments.Should().HaveValue(); detail.MaxDocuments.Should().Be(maxDocuments); detail.MaxSizeInBytes.Should().HaveValue(); detail.MaxSizeInBytes.Should().BeGreaterOrEqualTo(maxSizeInBytes); IDocumentCollection <TestDocument> collection = _documentDatabase.GetCollection <TestDocument>(_collectionName); IndexDetailV1 indexDetail = await collection.Index.GetIndexDetail(_workContext, model.Indexes[0].Name); indexDetail.Should().NotBeNull(); indexDetail.Keys.Count.Should().Be(1); model.Indexes[0].IsEquals(indexDetail).Should().BeTrue(); }
public async Task ApplyCollectionModelFull() { IDocumentDatabase db = _documentServer.GetDatabase(_workContext, _dbName); var model = new CollectionModel { CollectionName = _collectionName, Indexes = new List <CollectionIndex> { new CollectionIndex { Name = "TestIndex_1", Unique = true, Keys = new List <IndexKey> { new IndexKey { FieldName = "Field1", Descending = false }, } } } }; var package = new CollectionModelPackage(db, model, new CollectionModelSettings { ReCreate = true }); bool result = await package.Apply(_workContext); result.Should().BeTrue(); (await db.CollectionExist(_workContext, _collectionName)).Should().BeTrue(); IDocumentCollection <TestDocument> collection = db.GetCollection <TestDocument>(_collectionName); IndexDetailV1 detail = await collection.Index.GetIndexDetail(_workContext, model.Indexes[0].Name); detail.Should().NotBeNull(); detail.Keys.Count.Should().Be(1); model.Indexes[0].IsEquals(detail).Should().BeTrue(); await db.DropCollection(_workContext, _collectionName); await _documentServer.DropDatabase(_workContext, _dbName); }
/// <summary> /// List indexes /// </summary> /// <param name="context">work context</param> /// <returns>list of index details</returns> public async Task <IEnumerable <IndexDetailV1> > ListIndexes(IWorkContext context) { Verify.IsNotNull(nameof(context), context); var list = new List <IndexDetailV1>(); using (var cursor = await Parent.MongoCollection.Indexes.ListAsync()) { List <BsonDocument> resultList = await cursor.ToListAsync(); foreach (var item in resultList) { var indexDetail = new IndexDetailV1 { Name = item.Get <string>("name"), Version = item.Get <int>("v"), Unique = item.Get <bool>("unique", required: false), Sparse = item.Get <bool>("sparse", required: false), Namespace = item.Get <string>("ns"), }; list.Add(indexDetail); BsonDocument keyDocument = (BsonDocument)item["key"]; var keyList = new List <IndexKey>(); foreach (var kValue in keyDocument.Elements) { var indexKey = new IndexKey { FieldName = kValue.Name, Descending = kValue.Value.AsInt32 == 1 ? false : true, }; keyList.Add(indexKey); } indexDetail.Keys = keyList; } return(list); } }
public async Task <bool> Test(IWorkContext context) { Verify.IsNotNull(nameof(context), context); context = context.WithTag(_tag); IDocumentCollection <BsonDocument> collection = Parent.Database.GetCollection <BsonDocument>(Parent.Model.CollectionName); IndexDetailV1 detail = await collection.Index.GetIndexDetail(context, Index.Name); if (detail == null) { MongoDbEventSource.Log.Info(context, $"Index {Index.Name} for collection {Parent.Model.CollectionName} does not exist"); return(false); } bool status = Index.IsEquals(detail); MongoDbEventSource.Log.Info(context, $"Index {Index.Name} for collection {Parent.Model.CollectionName}, Equals={status}"); return(status); }
public static bool IsEquals(this CollectionIndex self, IndexDetailV1 detail) { bool equal = self.Name.Equals(detail.Name) && self.Unique == detail.Unique && self.Sparse == detail.Sparse && self.Keys?.Count == detail?.Keys.Count; if (!equal) { return(false); } if (self.Keys?.Count() > 0) { return(self.Keys .OrderBy(x => x.FieldName) .Zip(detail.Keys.OrderBy(x => x.FieldName), (f, s) => new { F = s, S = s }) .All(x => x.F.Equals(x.S))); } return(true); }