public void UpsertTransactionCommandHandler_EmptyDbUpsertList_ListSaved() { //given var transactionTypes = new[] { new TransactionType { Name = "t1", Outcome = true } }; var repository = LiteDbHelper.CreateMemoryDb(); var handler = new UpsertTransactionTypesCommandHandler(repository); var command = new UpsertTransactionTypesCommand(transactionTypes); //when handler.Execute(command); //then var orderedTransactionTypesInDatabase = repository.Database.Query <TransactionType>().OrderBy(x => x.Id).ToArray(); var orderedTransactionTypes = transactionTypes.OrderBy(x => x.Id).ToArray(); Assert.Equal(orderedTransactionTypes, orderedTransactionTypesInDatabase); Assert.Equal(orderedTransactionTypes.Select(x => x.Name), orderedTransactionTypesInDatabase.Select(x => x.Name)); Assert.Equal(orderedTransactionTypes.Select(x => x.Id), orderedTransactionTypesInDatabase.Select(x => x.Id)); Assert.Equal(orderedTransactionTypes.Select(x => x.IsDefault), orderedTransactionTypesInDatabase.Select(x => x.IsDefault)); Assert.Equal(orderedTransactionTypes.Select(x => x.Income), orderedTransactionTypesInDatabase.Select(x => x.Income)); Assert.Equal(orderedTransactionTypes.Select(x => x.Outcome), orderedTransactionTypesInDatabase.Select(x => x.Outcome)); }
public void UpsertTransactionCommandHandler_EmptyDbUpsertOneObject_ObjectSaved() { //given var transactions = new[] { new Transaction { Notes = new List <string> { "test1" }, Positions = new List <Position> { new Position { Title = "p1" } } } }; var repository = LiteDbHelper.CreateMemoryDb(); var handler = new UpsertTransactionsCommandHandler(repository); var command = new UpsertTransactionsCommand(transactions); //when handler.Execute(command); //then var orderedTransactionsInDatabase = repository.Database.Query <Transaction>().OrderBy(x => x.Id); Assert.Equal(transactions.OrderBy(x => x.Id), orderedTransactionsInDatabase); }
public void CategoryQueryHandler_CategoryQueryNotEmptyDatabase_Array() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new CategoryQueryHandler(repository); var query = new CategoryQuery(); var rootCategory = new Category(new Guid(1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1)) { Name = "1", Parent = null }; var categories = new[] { rootCategory, new Category(new Guid(1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 2)) { Name = "2", Parent = rootCategory } }; repository.Database.GetCollection <Category>().InsertBulk(categories); //when var result = handler.Execute(query); //then Assert.Equal(categories, result); }
public void TransactionTypesQueryHandler_TransactionTypesQueryNotEmptyDatabaseWithQuery_MatchingArray() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new TransactionTypesQueryHandler(repository); Expression <Func <TransactionType, bool> > linqQuery = x => x.IsDefault && x.Outcome; var query = new TransactionTypesQuery(linqQuery); var transactions = new[] { new TransactionType { Income = true, IsDefault = true, Name = "income" }, new TransactionType { Outcome = true, IsDefault = true, Name = "outcome" }, }; repository.Database.GetCollection <TransactionType>().InsertBulk(transactions); var matchingTransactions = transactions.AsQueryable().Where(linqQuery).ToArray(); //when var result = handler.Execute(query); //then Assert.Equal(matchingTransactions.Length, result.Length); Assert.Equal(matchingTransactions, result); }
public void InitApp() { Players = LiteDbHelper.GetPlayers(); #region TeamsTab teamsPlayerCheckListBox.DataSource = Players; teamsPlayerCheckListBox.DisplayMember = "Name"; #endregion #region PlayersTab playersListBox.DataSource = Players; playersListBox.DisplayMember = "Name"; var ranks = new List <string>(); foreach (PlayerRank rank in Enum.GetValues(typeof(PlayerRank))) { ranks.Add(rank.ToString()); } playerRankCombo.DataSource = ranks; #endregion }
public void TransactionQueryHandler_TransactionQueryNotEmptyDatabaseWithQuery_MatchingArray() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new TransactionQueryHandler(repository); Expression <Func <Transaction, bool> > linqQuery = x => x.Title.Contains("1"); var query = new TransactionQuery(linqQuery); var transactions = new[] { new Transaction(new Guid(1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1)) { Title = "t1" }, new Transaction(new Guid(1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 2)) { Title = "t2" } }; repository.Database.GetCollection <Transaction>().InsertBulk(transactions); var matchingTransactions = transactions.AsQueryable().Where(linqQuery).ToArray(); //when var result = handler.Execute(query); //then Assert.Equal(matchingTransactions.Length, result.Length); Assert.Equal(matchingTransactions, result); }
private async void ExecuteSaveCommand(object obj) { var loader = await MaterialDialog.Instance.LoadingDialogAsync("Contact du serveur ... ", Configurations.MaterialConfig.MaterialLoadingDialogConfiguration); DemandeurIdentite.Id = LiteDbHelper.CurrentUser.Id; DemandeurIdentite.Email = LiteDbHelper.CurrentUser.Email; DemandeurIdentite.Password = LiteDbHelper.CurrentUser.Password; DemandeurIdentite.Telephone = Code.DialCode + DemandeurIdentite.Telephone; DemandeurIdentite.Nationalite = Pays.CountryName; //DemandeurIdentite.Naissance = LiteDbHelper.CurrentUser.Naissance; var data = DemandeurIdentite; try { await RestService.For <IBackendService>(Configurations.ServerConfig.Host).Update(JsonConvert.SerializeObject(DemandeurIdentite)); LiteDbHelper.UpdateDataUser(DemandeurIdentite); await loader.DismissAsync(); await Navigation.PushAsync(new HomePage()); } catch (Exception e) { await loader.DismissAsync(); if (e is Refit.ApiException) { await MaterialDialog.Instance.SnackbarAsync($"{((Refit.ApiException)e).Content}", 3000, Configurations.MaterialConfig.MaterialSnackbarConfigurationError); } else { await MaterialDialog.Instance.SnackbarAsync($"Erreur: {e.Message}", 3000, Configurations.MaterialConfig.MaterialSnackbarConfigurationError); } } }
public void StockQueryHandler_StockQueryNotEmptyDatabase_Array() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new StockQueryHandler(repository); var query = new StockQuery(); var stocks = new[] { new CashManager.Data.DTO.Stock(new Guid(1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 1)) { Name = "1", IsUserStock = true, Balance = new Balance { Value = 12.34m } }, new CashManager.Data.DTO.Stock(new Guid(1, 2, 3, 4, 5, 6, 7, 8, 9, 0, 2)) { Name = "2", IsUserStock = false } }; repository.Database.GetCollection <CashManager.Data.DTO.Stock>().InsertBulk(stocks); //when var result = handler.Execute(query); //then Assert.Equal(stocks, result); Assert.Equal(stocks[0].Balance, result[0].Balance); Assert.Equal(stocks[0].Balance.Value, result[0].Balance.Value); }
public void Query_NotEmptyDbFilter_FilteredArray() { //given var repo = LiteDbHelper.CreateMemoryDb(); var input = new[] { new Tag { Name = "a" }, new Tag { Name = "b" }, new Tag { Name = "c" }, new Tag(), new Tag(), }; repo.Database.UpsertBulk(input); //when var result = repo.Database.Query <Tag>(x => !string.IsNullOrEmpty(x.Name)); //then Assert.Equal(input.Where(x => !string.IsNullOrEmpty(x.Name)).OrderBy(x => x.Id), result.OrderBy(x => x.Id)); }
public void UpsertStockCommandHandler_EmptyDbUpsertOneObject_ObjectSaved() { //given var stocks = new[] { new Stock { Name = "test1", Balance = new Balance { Value = 12.45m } } }; var repository = LiteDbHelper.CreateMemoryDb(); var handler = new UpsertStocksCommandHandler(repository); var command = new UpsertStocksCommand(stocks); //when handler.Execute(command); //then var orderedStocksInDatabase = repository.Database.Query <Stock>().OrderBy(x => x.Id).ToArray(); Assert.Equal(stocks.OrderBy(x => x.Id), orderedStocksInDatabase); Assert.Equal(stocks[0].Balance, orderedStocksInDatabase[0].Balance); Assert.Equal(stocks[0].Balance.Value, orderedStocksInDatabase[0].Balance.Value); }
public void UpsertStockCommandHandler_EmptyDbUpsertList_ListSaved() { //given var stocks = new[] { new Stock { Name = "test1" }, new Stock { Name = "test2" } }; var repository = LiteDbHelper.CreateMemoryDb(); var handler = new UpsertStocksCommandHandler(repository); var command = new UpsertStocksCommand(stocks); //when handler.Execute(command); //then var orderedStocksInDatabase = repository.Database.Query <Stock>().OrderBy(x => x.Id); Assert.Equal(stocks.OrderBy(x => x.Id), orderedStocksInDatabase); }
public void UpsertCategoriesCommandHandler_EmptyDbUpsertList_ListSaved() { //given var categories = new[] { new Category { Name = "test1" }, new Category { Name = "test2" } }; var repository = LiteDbHelper.CreateMemoryDb(); var handler = new UpsertCategoriesCommandHandler(repository); var command = new UpsertCategoriesCommand(categories); //when handler.Execute(command); //then var orderedCategoryInDatabase = repository.Database.Query <Category>().OrderBy(x => x.Id); Assert.Equal(categories.OrderBy(x => x.Id), orderedCategoryInDatabase); }
public void TagQueryHandler_TagQueryNotEmptyDatabase_Array() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new TagQueryHandler(repository); var query = new TagQuery(); var tags = new[] { new Tag { Name = "tag1" }, new Tag { Name = "tag2" }, new Tag { Name = "tag3" }, new Tag { Name = "tag4" }, new Tag { Name = "tag5" }, }; repository.Database.UpsertBulk(tags); //when var result = handler.Execute(query); //then Assert.Equal(tags.OrderBy(x => x.Id), result.OrderBy(x => x.Id)); }
public void UpsertSearchStateCommandHandler_EmptyDbUpsertListOfNamedObjects_ListSaved() { //given var searchStates = new[] { new SearchState { Name = "test1" }, new SearchState { Name = "test2" } }; var repository = LiteDbHelper.CreateMemoryDb(); var handler = new UpsertSearchStateCommandHandler(repository); var command = new UpsertSearchStateCommand(searchStates); //when handler.Execute(command); //then var orderedSearchStatesInDatabase = repository.Database.Query <SearchState>().OrderBy(x => x.Id); Assert.Equal(searchStates.OrderBy(x => x.Id), orderedSearchStatesInDatabase); }
public override object Add(string key, object entry, DateTime utcExpiry) { var item = LiteDbHelper.QueryAll <CacheItem>().Find(q => q.Key == key); if (item != null) { if (item.Expiration <= DateTime.Now) { LiteDbHelper.Delete <CacheItem>(item.Id); } else { return(BinarySerializer.Deserialize(item.Entry)); } } LiteDbHelper.Add(new CacheItem { Key = key, Entry = BinarySerializer.Serialize(entry), Expiration = utcExpiry, CreatedDate = DateTime.UtcNow }); return(entry); }
public override void Remove(string key) { var item = LiteDbHelper.QueryAll <CacheItem>().Find(q => q.Key == key); if (item != null) { LiteDbHelper.Delete <CacheItem>(item.Id); } }
public void Remove_Null_0() { //given var repo = LiteDbHelper.CreateMemoryDb(); //when int result = repo.Database.Remove <Dto>(null); //then Assert.Equal(0, result); }
private void RemovePlayer(Player player) { LiteDbHelper.DeletePlayer(player); var existingPlayer = Players.FirstOrDefault(i => i.Id == player.Id); if (existingPlayer != null) { Players.Remove(existingPlayer); } SyncPlayerList(); }
public void Query_EmptyDb_Empty() { //given var repo = LiteDbHelper.CreateMemoryDb(); //when var result = repo.Database.Query <Dto>(); //then Assert.Empty(result); }
public void DeleteStockCommandHandler_NullEmptyDb_EmptyDb() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new DeleteStockCommandHandler(repository); var command = new DeleteStockCommand(null); //when handler.Execute(command); //then Assert.Empty(repository.Database.Query <Stock>()); }
public void UpsertBulk_Nulls_0() { //given var repo = LiteDbHelper.CreateMemoryDb(); Dto[] input = { null, null, null }; //when int result = repo.Database.UpsertBulk(input); //then Assert.Equal(0, result); }
private void SavePlayer(Player player) { LiteDbHelper.UpsertPlayer(player); var existingPlayer = Players.FirstOrDefault(i => i.Id == player.Id); if (existingPlayer != null) { Players.Remove(existingPlayer); } Players.Add(player); SyncPlayerList(); }
public void Upsert_NotNullNotInDbAlQuery_TrueAndObjectInDb() { //given var repo = LiteDbHelper.CreateMemoryDb(); var element = new Dto(); //when bool result = repo.Database.Upsert(element); //then Assert.True(result); Assert.Equal(element, repo.Database.GetCollection <Dto>().FindAll().First()); }
public void DeleteTransactionTypeCommandHandler_NotExisting_NoChange() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new DeleteTransactionTypeCommandHandler(repository); var command = new DeleteTransactionTypeCommand(new TransactionType()); //when handler.Execute(command); //then Assert.Empty(repository.Database.Query <TransactionType>()); }
public void UpsertCategoriesCommandHandler_NullEmptyDb_EmptyDb() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new UpsertCategoriesCommandHandler(repository); var command = new UpsertCategoriesCommand((Category)null); //when handler.Execute(command); //then Assert.Empty(repository.Database.Query <Category>()); }
public void Remove_ElementInDb_1() { //given var repo = LiteDbHelper.CreateMemoryDb(); var input = new[] { new Tag(), new Tag() }; repo.Database.UpsertBulk(input); //when int result = repo.Database.Remove(input[0]); //then Assert.Equal(1, result); }
public void TransactionQueryHandler_TransactionQueryEmptyDatabase_EmptyArray() { //given var repository = LiteDbHelper.CreateMemoryDb(); var handler = new TransactionQueryHandler(repository); var query = new TransactionQuery(); //when var result = handler.Execute(query); //then Assert.NotNull(result); Assert.Empty(result); }
public void Query_NotEmptyDb_Same() { //given var repo = LiteDbHelper.CreateMemoryDb(); var input = new[] { new Tag(), new Tag() }; repo.Database.UpsertBulk(input); //when var result = repo.Database.Query <Tag>(); //then Assert.Equal(input.OrderBy(x => x.Id), result.OrderBy(x => x.Id)); }
public void DeleteCategoryCommandHandler_Existing_Removed() { //given var category = new Category(); var repository = LiteDbHelper.CreateMemoryDb(); var handler = new DeleteCategoryCommandHandler(repository); var command = new DeleteCategoryCommand(category); repository.Database.Upsert(category); //when handler.Execute(command); //then Assert.Empty(repository.Database.Query <Category>()); }
public void DeleteStockCommandHandler_Existing_Removed() { //given var stock = new Stock(); var repository = LiteDbHelper.CreateMemoryDb(); var handler = new DeleteStockCommandHandler(repository); var command = new DeleteStockCommand(stock); repository.Database.Upsert(stock); //when handler.Execute(command); //then Assert.Empty(repository.Database.Query <Stock>()); }