public async void TestMetadataQueries() { var configManager = new ServiceDbConfigManager("TestService"); var dbAccess = await CreateDbAccess(configManager); var dbAccessProvider = new TestDocumentDbAccessProvider(dbAccess); var fruitStore = new FruitStore(dbAccessProvider); var bartlett = new Pear { Id = Guid.NewGuid(), Colour = "Red" }; var comice = new Pear { Id = Guid.NewGuid(), Colour = "Green" }; for (int i = 0; i < 50; i++) { // Mutate the record. bartlett.Colour = i % 2 == 0 ? "Red" : "DarkRed"; await fruitStore.UpsertPear(bartlett); await fruitStore.UpsertPear(comice); } await fruitStore.DeletePearById(bartlett.Id); var r1 = await fruitStore.GetPearByQuery("[x].Colour = @colour", new[] { new DbParameter("colour", "Red") }); Assert.True(r1.All(x => x.Colour == "Red")); var r2 = await fruitStore.GetPearVersions(bartlett.Id.ToString()); Assert.NotNull(r2); Assert.Equal(51, r2.Metadata.Count); Assert.Equal(1, r2.Metadata[0].Version); Assert.False(r2.Metadata[0].IsDeleted); var lastVersion = r2.Metadata.Last(); Assert.Equal(51, lastVersion.Version); Assert.True(lastVersion.IsDeleted); Assert.True(lastVersion.CreatedTime < lastVersion.ModifiedTime); Assert.Equal(r2.Metadata[0].CreatedTime, lastVersion.CreatedTime); }
public async void TestDocumentPurge() { var configManager = new ServiceDbConfigManager("TestService"); var dbAccess = CreateDbAccess(configManager); var dbAccessProvider = new TestDocumentDbAccessProvider(dbAccess); var fruitStore = new FruitStore(dbAccessProvider); await dbAccess.Open(new[] { fruitStore }); var gala = new Apple { Id = Guid.NewGuid(), Type = "Gala" }; var opal = new Apple { Id = Guid.NewGuid(), Type = "Opal" }; var redBartlett = new Pear { Id = Guid.NewGuid(), Colour = "Red" }; var darkRedBartlett = new Pear { Id = Guid.NewGuid(), Colour = "DarkRed" }; await fruitStore.UpsertApple(gala); await fruitStore.UpsertApple(gala); await fruitStore.UpsertApple(gala); await fruitStore.UpsertApple(opal); await fruitStore.UpsertPear(redBartlett); await fruitStore.UpsertPear(darkRedBartlett); await fruitStore.UpsertPear(darkRedBartlett); await fruitStore.DeletePearById(darkRedBartlett.Id); var galaResult = await fruitStore.GetAppleVersions(gala.Id); var opalResult = await fruitStore.GetAppleVersions(opal.Id); var redBartlettResult = await fruitStore.GetPearVersions(redBartlett.Id); var darkRedBartlettResult = await fruitStore.GetPearVersions(redBartlett.Id); Assert.NotNull(galaResult); Assert.NotNull(opalResult); Assert.NotNull(redBartlettResult); Assert.NotNull(darkRedBartlettResult); await fruitStore.PurgeAllPears(); galaResult = await fruitStore.GetAppleVersions(gala.Id); opalResult = await fruitStore.GetAppleVersions(opal.Id); redBartlettResult = await fruitStore.GetPearVersions(redBartlett.Id); darkRedBartlettResult = await fruitStore.GetPearVersions(redBartlett.Id); Assert.NotNull(galaResult); Assert.NotNull(opalResult); Assert.Null(redBartlettResult); Assert.Null(darkRedBartlettResult); await fruitStore.PurgeApple(gala.Id); galaResult = await fruitStore.GetAppleVersions(gala.Id); opalResult = await fruitStore.GetAppleVersions(opal.Id); Assert.Null(galaResult); Assert.NotNull(opalResult); await fruitStore.UpsertApple(gala); var versionedGalaResult = await fruitStore.GetVersionedAppleById(gala.Id); Assert.NotNull(versionedGalaResult); Assert.Equal(1, versionedGalaResult.Metadata.Version); }
public async void TestMetadataQueries() { var configManager = new ServiceDbConfigManager("TestService"); var dbAccess = CreateDbAccess(configManager); var dbAccessProvider = new TestDocumentDbAccessProvider(dbAccess); var fruitStore = new FruitStore(dbAccessProvider); await dbAccess.Open(new[] { fruitStore }); var bartlett = new Pear { Id = Guid.NewGuid(), Colour = "Red" }; var comice = new Pear { Id = Guid.NewGuid(), Colour = "Green" }; for (int i = 0; i < 5; i++) { // Mutate the record. bartlett.Colour = i % 2 == 0 ? "Red" : "DarkRed"; await fruitStore.UpsertPear(bartlett); await fruitStore.UpsertPear(comice); Thread.Sleep(1000); } await fruitStore.DeletePearById(bartlett.Id); var r1 = await fruitStore.GetPearByQuery("[x].Colour = @colour", new[] { new DbParameter("colour", "Red") }); Assert.True(r1.All(x => x.Colour == "Red")); var r2 = await fruitStore.GetPearVersions(bartlett.Id); Assert.NotNull(r2); Assert.Equal(6, r2.Metadata.Count); Assert.Equal(1, r2.Metadata[0].Version); Assert.False(r2.Metadata[0].IsDeleted); var lastVersion = r2.Metadata.Last(); Assert.Equal(6, lastVersion.Version); Assert.True(lastVersion.IsDeleted); Assert.True(lastVersion.CreatedTime < lastVersion.ModifiedTime); Assert.Equal(r2.Metadata[0].CreatedTime, lastVersion.CreatedTime); for (var i = 1; i < r2.Metadata.Count; i++) { var prev = r2.Metadata[i - 1]; var current = r2.Metadata[i]; Assert.True(current.ModifiedTime > prev.ModifiedTime); Assert.True(current.ModifiedTime - prev.ModifiedTime >= TimeSpan.FromSeconds(1)); Assert.True(current.ModifiedTime > prev.CreatedTime); Assert.Equal(current.CreatedTime, prev.CreatedTime); Assert.False(prev.IsDeleted); } }