public DatabaseFixture()
{
var cosmonautClient = new CosmonautClient(EmulatorUri, EmulatorKey);
var database = cosmonautClient.GetDatabaseAsync(DatabaseId).GetAwaiter().GetResult();
if (database != null)
{
cosmonautClient.DeleteDatabaseAsync(DatabaseId);
}
var cosmosSettings = new CosmosStoreSettings(DatabaseId, EmulatorUri, EmulatorKey);
var serviceCollection = new ServiceCollection()
.AddCosmosStore <FlatForRentAnnouncementEntity>(cosmosSettings, _flatForRentAnnouncementRepositoryTestCollectionName)
.AddCosmosStore <RoomForRentAnnouncementEntity>(cosmosSettings, _roomForRentAnnouncementRepositoryTestCollectionName);
var serviceProvider = serviceCollection.BuildServiceProvider();
FlatForRentAnnouncementCosmosStore = serviceProvider.GetService <ICosmosStore <FlatForRentAnnouncementEntity> >();
RoomForRentAnnouncementCosmosStore = serviceProvider.GetService <ICosmosStore <RoomForRentAnnouncementEntity> >();
}
protected override void ConfigureWebHost(IWebHostBuilder builder)
{
builder.ConfigureTestServices(services =>
{
var cosmonautClient = new CosmonautClient(EmulatorUri, EmulatorKey);
var database = cosmonautClient.GetDatabaseAsync(DatabaseId).GetAwaiter().GetResult();
if (database != null)
{
cosmonautClient.DeleteDatabaseAsync(DatabaseId);
}
var descriptors = services
.Where(x =>
x.ServiceType == typeof(ICosmosStore <FlatForRentAnnouncementEntity>) ||
x.ServiceType == typeof(ICosmosStore <RoomForRentAnnouncementEntity>) ||
x.ServiceType == typeof(IHttpClientService))
.ToList();
if (descriptors.Any())
{
foreach (var descriptor in descriptors)
{
services.Remove(descriptor);
}
}
var cosmosSettings = new CosmosStoreSettings(DatabaseId, EmulatorUri, EmulatorKey, settings =>
{
settings.JsonSerializerSettings = new JsonSerializerSettings
{
DateFormatHandling = DateFormatHandling.IsoDateFormat,
Formatting = Formatting.Indented,
Converters = { new StringEnumConverter(), new IsoDateTimeConverter() }
};
});
services.AddCosmosStore <FlatForRentAnnouncementEntity>(cosmosSettings);
services.AddCosmosStore <RoomForRentAnnouncementEntity>(cosmosSettings);
services.AddScoped <IHttpClientService, HttpClientServiceStub>();
var sp = services.BuildServiceProvider();
FlatForRentAnnouncementEntityCosmosStore = sp.GetRequiredService <ICosmosStore <FlatForRentAnnouncementEntity> >();
RoomForRentAnnouncementEntityCosmosStore = sp.GetRequiredService <ICosmosStore <RoomForRentAnnouncementEntity> >();
});
}
static async Task Main(string[] args)
{
//Uncomment to enable Serilog logging
//SerilogEventListener.Instance.Initialize();
var connectionPolicy = new ConnectionPolicy
{
ConnectionProtocol = Protocol.Tcp,
ConnectionMode = ConnectionMode.Direct
};
var cosmosSettings = new CosmosStoreSettings("localtest",
"https://localhost:8081",
"C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw=="
, connectionPolicy
, defaultCollectionThroughput: 5000);
var cosmonautClient = new CosmonautClient("https://localhost:8081",
"C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==");
var serviceCollection = new ServiceCollection();
serviceCollection.AddCosmosStore <Book>("localtest", "https://localhost:8081",
"C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==",
settings =>
{
settings.ConnectionPolicy = connectionPolicy;
settings.DefaultCollectionThroughput = 5000;
});
serviceCollection.AddCosmosStore <Car>(cosmosSettings);
var provider = serviceCollection.BuildServiceProvider();
var booksStore = provider.GetService <ICosmosStore <Book> >();
var carStore = provider.GetService <ICosmosStore <Car> >();
System.Console.WriteLine($"Started");
var scaleableDb = await cosmonautClient.GetDatabaseAsync("scaleabledb");
if (scaleableDb == null)
{
scaleableDb = await cosmonautClient.CreateDatabaseAsync(new Database { Id = "scaleabledb" },
new RequestOptions { OfferThroughput = 10000 });
}
var dbOffer = await cosmonautClient.GetOfferForDatabaseAsync("scaleabledb");
var dbOfferV2 = await cosmonautClient.GetOfferV2ForDatabaseAsync("scaleabledb");
var newOffer = new OfferV2(dbOffer, 20000);
var offerResponse = await cosmonautClient.UpdateOfferAsync(newOffer);
var database = await cosmonautClient.GetDatabaseAsync("localtest");
System.Console.WriteLine($"Retrieved database with id {database.Id}");
var collection = await cosmonautClient.GetCollectionAsync("localtest", "shared");
System.Console.WriteLine($"Retrieved collection with id {collection.Id}");
var offer = await cosmonautClient.GetOfferForCollectionAsync("localtest", "shared");
System.Console.WriteLine($"Retrieved offer with id {offer.Id}");
var offerV2 = await cosmonautClient.GetOfferV2ForCollectionAsync("localtest", "shared");
System.Console.WriteLine($"Retrieved offerV2 with id {offerV2.Id}");
var databases = await cosmonautClient.QueryDatabasesAsync();
System.Console.WriteLine($"Retrieved all {databases.Count()} databased in the account.");
var booksRemoved = await booksStore.RemoveAsync(x => true);
System.Console.WriteLine($"Removed {booksRemoved.SuccessfulEntities.Count} books from the database.");
var carsRemoved = await carStore.RemoveAsync(x => true);
System.Console.WriteLine($"Removed {carsRemoved.SuccessfulEntities.Count} cars from the database.");
var books = new List <Book>();
for (int i = 0; i < 25; i++)
{
books.Add(new Book
{
Id = Guid.NewGuid().ToString(),
Name = "Test " + i,
AnotherRandomProp = "Random " + i
});
}
var cars = new List <Car>();
for (int i = 0; i < 25; i++)
{
cars.Add(new Car
{
Id = Guid.NewGuid().ToString(),
Name = "Car " + i,
});
}
var watch = new Stopwatch();
watch.Start();
var addedCars = await carStore.AddRangeAsync(cars);
var addedBooks = await booksStore.AddRangeAsync(books);
System.Console.WriteLine($"Added {addedCars.SuccessfulEntities.Count + addedBooks.SuccessfulEntities.Count} documents in {watch.ElapsedMilliseconds}ms");
watch.Restart();
//await Task.Delay(3000);
var aCarId = addedCars.SuccessfulEntities.First().Entity.Id;
var firstAddedCar = await carStore.Query().FirstOrDefaultAsync();
var allTheCars = await carStore.QueryMultipleAsync <Car>("select * from c");
var carPageOne = await carStore.Query("select * from c order by c.Name asc").WithPagination(1, 5).ToPagedListAsync();
var carPageTwo = await carStore.Query("select * from c order by c.Name asc").WithPagination(carPageOne.NextPageToken, 5).ToPagedListAsync();
var carPageThree = await carPageTwo.GetNextPageAsync();
var carPageFour = await carPageThree.GetNextPageAsync();
var addedRetrieved = await booksStore.Query().OrderBy(x => x.Name).ToListAsync();
var firstPage = await booksStore.Query().WithPagination(1, 10).OrderBy(x => x.Name).ToPagedListAsync();
var secondPage = await firstPage.GetNextPageAsync();
var thirdPage = await secondPage.GetNextPageAsync();
var fourthPage = await secondPage.GetNextPageAsync();
//var thirdPage = await booksStore.Query().WithPagination(secondPage.NextPageToken, 10).OrderBy(x => x.Name).ToPagedListAsync();
//var fourthPage = await booksStore.Query().WithPagination(4, 10).OrderBy(x => x.Name).ToListAsync();
var sqlPaged = await cosmonautClient.Query <Book>("localtest", "shared",
"select * from c where c.CosmosEntityName = 'books' order by c.Name", null, new FeedOptions { EnableCrossPartitionQuery = true })
.WithPagination(2, 10).ToListAsync();
System.Console.WriteLine($"Retrieved {addedRetrieved.Count} documents in {watch.ElapsedMilliseconds}ms");
watch.Restart();
foreach (var addedre in addedRetrieved)
{
addedre.AnotherRandomProp += " Nick";
}
var updated = await booksStore.UpsertRangeAsync(addedRetrieved, x => new RequestOptions {
AccessCondition = new AccessCondition
{
Type = AccessConditionType.IfMatch,
Condition = x.Etag
}
});
System.Console.WriteLine($"Updated {updated.SuccessfulEntities.Count} documents in {watch.ElapsedMilliseconds}ms");
watch.Restart();
var removed = await booksStore.RemoveRangeAsync(addedRetrieved);
System.Console.WriteLine($"Removed {removed.SuccessfulEntities.Count} documents in {watch.ElapsedMilliseconds}ms");
watch.Reset();
watch.Stop();
System.Console.ReadKey();
}
static async Task Main(string[] args)
{
var connectionPolicy = new ConnectionPolicy
{
ConnectionProtocol = Protocol.Tcp,
ConnectionMode = ConnectionMode.Direct
};
var cosmosSettings = new CosmosStoreSettings("localtest",
"https://*****:*****@id", new { id = aCarId });
var allTheCars = await carStore.QueryMultipleAsync <Car>("select * from c");
var addedRetrieved = await booksStore.Query().ToListAsync();
System.Console.WriteLine($"Retrieved {addedRetrieved.Count} documents in {watch.ElapsedMilliseconds}ms");
watch.Restart();
foreach (var addedre in addedRetrieved)
{
addedre.AnotherRandomProp += " Nick";
}
var updated = await booksStore.UpsertRangeAsync(addedRetrieved);
System.Console.WriteLine($"Updated {updated.SuccessfulEntities.Count} documents in {watch.ElapsedMilliseconds}ms");
watch.Restart();
var removed = await booksStore.RemoveRangeAsync(addedRetrieved);
System.Console.WriteLine($"Removed {removed.SuccessfulEntities.Count} documents in {watch.ElapsedMilliseconds}ms");
watch.Reset();
watch.Stop();
System.Console.ReadKey();
}
