public async void GetAllItemsSuccess() { var item = new DatabaseModel.RakeItem("assetId12311", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var item2 = new DatabaseModel.RakeItem("assetId12344", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var item3 = new DatabaseModel.RakeItem("assetId12333", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var list = new List <DatabaseModel.RakeItem> { item, item2, item3 }; await _rakeItemRepoService.InsertAsync(list); var res = await _rakeItemRepoService.GetAll(); int matches = 0; foreach (var t in res) { matches += list.Count(t1 => t1.AssetId == t.AssetId); } Assert.Equal(3, matches); }
public async void GetRakeItemsForSpecificMatch() { var item = new DatabaseModel.RakeItem("assetId15311", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match2.Id, _setup.GameMode.Id); var item2 = new DatabaseModel.RakeItem("assetId15344", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match2.Id, _setup.GameMode.Id); var item3 = new DatabaseModel.RakeItem("assetId15333", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match2.Id, _setup.GameMode.Id); var item4 = new DatabaseModel.RakeItem("assetId1233489", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var list = new List <DatabaseModel.RakeItem> { item, item2, item3, item4 }; await _rakeItemRepoService.InsertAsync(list); var res = await _rakeItemRepoService.FindAsync(_setup.Match2); Assert.Equal(3, res.Count); }
public async void InsertSameAssetIdButDiffrentDescriptionIdSuccess() { var item = new DatabaseModel.RakeItem("assetId100", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var item2 = new DatabaseModel.RakeItem("assetId100", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); await _rakeItemRepoService.InsertAsync(new List <DatabaseModel.RakeItem> { item, item2 }); var itemResult1 = await _rakeItemRepoService.FindAsync(new AssetAndDescriptionId { AssetId = "AssetId100", DescriptionId = _setup.ItemDescription1.Id, }); var itemResult2 = await _rakeItemRepoService.FindAsync(new AssetAndDescriptionId { AssetId = "AssetId100", DescriptionId = _setup.ItemDescription2.Id, }); Assert.False(itemResult1.Id == itemResult2.Id); Assert.NotNull(itemResult1); Assert.NotNull(itemResult2); }
public async void FindRakeItemFromGameModeId() { var item = new DatabaseModel.RakeItem("randAssetId225", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode4.Id); var item2 = new DatabaseModel.RakeItem("randAssetId326", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode4.Id); var item7 = new DatabaseModel.RakeItem("randAssetI3127", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode4.Id); var item8 = new DatabaseModel.RakeItem("randAssetI5427", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode2.Id); var item9 = new DatabaseModel.RakeItem("455465427", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode3.Id); await _rakeItemRepoService.InsertAsync(new List <DatabaseModel.RakeItem> { item, item2, item7, item8, item9, }); var item1Res = await _rakeItemRepoService.FindFromGameModeIdAsync(new List <int> { _setup.GameMode4.Id, _setup.GameMode2.Id, }); Assert.Equal(4, item1Res.Count); }
public async void AddItemsSuccess() { var item = new DatabaseModel.RakeItem("assetId1", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var itemId = await _rakeItemRepoService.InsertAsync(item); var item2 = new DatabaseModel.RakeItem("assetId2", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var itemId2 = await _rakeItemRepoService.InsertAsync(item2); Assert.NotEqual(itemId.Id, itemId2.Id); }
public async void SetRakeItemsAsSold() { var item = new DatabaseModel.RakeItem("randAssetId125", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var item2 = new DatabaseModel.RakeItem("randAssetId126", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var item7 = new DatabaseModel.RakeItem("randAssetId127", _setup.ItemDescription1.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); Assert.False(item.IsSold); Assert.False(item2.IsSold); await _rakeItemRepoService.InsertAsync(new List <DatabaseModel.RakeItem> { item, item2, item7 }); await _rakeItemRepoService.SetAsSold(new List <string> { "randAssetId126", "randAssetId125", }); var item1Res = await _rakeItemRepoService.FindAsync(new AssetAndDescriptionId { AssetId = "randAssetId126", DescriptionId = _setup.ItemDescription1.Id, }); var item2Res = await _rakeItemRepoService.FindAsync(new AssetAndDescriptionId { AssetId = "randAssetId125", DescriptionId = _setup.ItemDescription2.Id, }); var item7Res = await _rakeItemRepoService.FindAsync(new AssetAndDescriptionId { AssetId = "randAssetId127", DescriptionId = _setup.ItemDescription1.Id, }); Assert.True(item1Res.IsSold); Assert.True(item2Res.IsSold); Assert.False(item7Res.IsSold); }
public async Task <DatabaseModel.RakeItem> InsertAsync(DatabaseModel.RakeItem rakeItem) { var query = _rakeItemQueries.InsertReturnsId(rakeItem); var id = (int)await _databaseConnection.ExecuteScalarAsync(query); return(new DatabaseModel.RakeItem ( rakeItem.AssetId, rakeItem.DescriptionId, rakeItem.LocationId, rakeItem.Received, rakeItem.MatchId, rakeItem.GameModeId, rakeItem.IsSold, id )); }
public SqlQuery InsertReturnsId(DatabaseModel.RakeItem rakeItem) { var dict = new Dictionary <string, object> { { "@assetId", rakeItem.AssetId }, { "@descId", rakeItem.DescriptionId }, { "@locId", rakeItem.LocationId }, { "@created", rakeItem.Received }, { "@matchId", rakeItem.MatchId }, { "@isSold", rakeItem.IsSold }, { "@gameModeId", rakeItem.GameModeId }, }; var queryStr = "INSERT INTO [RakeItem] (AssetId, DescriptionId, LocationId, MatchId,Received, IsSold, GameModeId) OUTPUT INSERTED.Id VALUES (@assetId ,@descId, @locId,@matchId, @created,@isSold,@gameModeId)"; return(new SqlQuery(queryStr, dict)); }
public async void AddAndFindSuccess() { var item = new DatabaseModel.RakeItem("assetId78789", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); var itemInsertRes = await _rakeItemRepoService.InsertAsync(item); var findRes = await _rakeItemRepoService.FindAsync(new AssetAndDescriptionId { AssetId = "assetId78789", DescriptionId = _setup.ItemDescription2.Id, }); Assert.True(itemInsertRes.Id > 0); Assert.Equal("assetId78789", findRes.AssetId); Assert.Equal(_setup.ItemDescription2.Id, findRes.DescriptionId); Assert.Equal(_setup.Match1.Id, findRes.MatchId); Assert.Equal(DateTime.Today, findRes.Received); }
public async void AddItemWithSameAssetIdMultipleTimesThrows() { var exceptionAsync = Record.ExceptionAsync(async() => { var item = new DatabaseModel.RakeItem("assetId3", _setup.ItemDescription2.Id, _setup.Bot1.Id, DateTime.Today, _setup.Match1.Id, _setup.GameMode.Id); await _rakeItemRepoService.InsertAsync(new List <DatabaseModel.RakeItem> { item, item }); }); if (exceptionAsync == null) { Assert.True(false, "No exception was thrown"); } var exception1 = await exceptionAsync; Assert.IsType(typeof(SqlException), exception1); }
public SqlQuery Insert(DatabaseModel.RakeItem rakeItem) { return(InsertRange(new List <DatabaseModel.RakeItem> { rakeItem })); }