public static void EnsureSeeded(this DatabaseContext context) { if (!context.FoodTypes.Any()) { var types = JsonConvert.DeserializeObject <List <FoodType> >(File.ReadAllText("seed" + Path.DirectorySeparatorChar + "foodType.json")); context.AddRange(types); context.SaveChanges(); } //Ensure we have some status if (!context.Nutrients.Any()) { var nutrients = JsonConvert.DeserializeObject <List <Nutrient> >(File.ReadAllText(@"seed" + Path.DirectorySeparatorChar + "nutrient.json")); context.AddRange(nutrients); context.SaveChanges(); } //Ensure we create initial Threat List if (!context.Foods.Any()) { List <Food> foods = JsonConvert.DeserializeObject <List <Food> >(File.ReadAllText(@"seed" + Path.DirectorySeparatorChar + "food.json")); context.Foods.AddRange(foods); context.SaveChanges(); } }
public async Task <IActionResult> Create(int id, [Bind("Id,Name,TypeId")] Spoj spoj, ICollection <int> Elements) { if (Elements.Count >= Spoj.MinSizeOfElements) { _context.Add(spoj); if (ModelState.IsValid) { var list = new List <SpojElement>(); foreach (var elem in Elements) { //until the ui supports entering count for each element set it to 1 and later edit it list.Add(new SpojElement() { Count = 1, ElementId = elem, SpojId = spoj.Id }); } _context.AddRange(list); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } ViewDataSet(); var spojVM = new SpojVM(); return(View(spojVM)); }
public static void Seed(DatabaseContext context) { if (!context.Cars.Any()) { context.AddRange( new Car { Id = 1, Title = "Ford Mustang", Description = "Mam do sprzedania Mustanga 5.0 GT V8 421KM w benzynie. Kupiony w Polskim SALONIE FORDA w Opolu jako NOWY w kwietniu 2016. Do chwili obecnej jest przejechane 34 000 km. Cena jaka mnie interesuje to 160 000 PLN.", PhotoUrl = "/images/fordMustang.jpg", MiniaturePhotoUrl = "/images/fordMustang.jpg" }, new Car { Id = 2, Title = "Audi S5", Description = "Do sprzedania Audi S5 z silnikiem benzynowym o pojemności 3000 cm3 i mocy 280 KM z 2013 roku. Jestem właścicielem tego samochodu od ponad dwóch lat. Obecny przebieg to 112 000km", PhotoUrl = "/images/audiS5.jpg", MiniaturePhotoUrl = "/images/audiS5.jpg" }, new Car { Id = 3, Title = "BMV X4", Description = "BMV X4 20d xDrive z silnikiem benzynowym o pojemnosci 2000 cm3 i mocy 190 KM. Samochód krajowy, kupiony w 2017 roku. Przebieg samochodu jest niewielki bo tylko 4300 km. Samochód serwisowany. Wystawiamy fakturę VAT 23%. Samochód bezwypadkowy. I właściciel.", PhotoUrl = "/images/bmvx4.jpg", MiniaturePhotoUrl = "/images/bmvx4.jpg" }, new Car { Id = 4, Title = "Chevrolet Corvette", Description = "Corvetta jest w świetnym stanie wizualnym i mechanicznym. Autko wyprodukowane w 1972 roku. obecnie jego przebieg wynosi 180 000 km Oczywiście jest ZAREJESTROWANA i ubezpieczona w PL. Samochód ma pojemność 5700 cm3 i moc 300 KM> Cena to 90 000 PLN", PhotoUrl = "/images/chevroletCorvete.jpg", MiniaturePhotoUrl = "/images/chevroletCorvete.jpg" }, new Car { Id = 5, Title = "Nissan Skyline", Description = "Na sprzedaż trafia moja perełka Nissan Skyline R33.Auto z Japonii sprowadzone do Szwecji, gdzie było przez wiele lat modyfikowane, uczestniczyło w zlotach, zdobywało nagrody, samochód sponsorowany latami przez Sonax Sweden. Samochód wyprodukowany w 1995 roku, jego przebieg 144 000 km potwierdzony książką serwisową. Autko posiada silnik o pojemności 2500 cm3 i moc 410 KM. Cena za to wspaniałe autko to 120 000 PLN", PhotoUrl = "/images/nissan.jpg", MiniaturePhotoUrl = "/images/nissan.jpg", }, new Car { Id = 6, Title = "Jaguar ZX", Description = "Przedstawiam Państwu wyjątkowe auto jakim jest Jaguar XKR, a zwłaszcza ten egzemplarz. Jaguar XKR to ikona światowej i brytyjskiem motoryzacji, a przede wszystkim kontynuator legendarnego już Jaguara E-typa, przez wielu uważany za najpiękniejsze auto w historii motoryzacji. Autko wyprodukowane w 2006 roku, Obecnie ma przejechane 78000 km, posiada najmocniejszy dostępny seryjnie montowany silnik o pojemności 5000 cm3 i mocy 510 KM. Cena za ten wspaniały samochód to 25 000 PLN.", PhotoUrl = "/images/jaguar.jpg", MiniaturePhotoUrl = "/images/jaguar.jpg" } ); } context.SaveChanges(); }
private void Seed(DatabaseContext db) { var country = new Country() { Id = 1, Name = "Poland" }; var provincy = new Provincy() { Id = 1, Country = country, Name = "podkarpackie" }; var cities = new[] { new City() { Id = 1, Provincy = provincy, Name = "Test1" }, new City() { Id = 2, Provincy = provincy, Name = "Test2" }, }; db.AddRange(cities); db.SaveChanges(); }
private void Seed() { using (var context = new DatabaseContext(databaseContextOptions, httpAccessorMock.Object)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); argumentQuery = new ReportArgumentQuery() { ArgQuery = "query", ReportArgumentQueryId = 1 }; reportArgument = new ReportArgument { Name = "date", ReportArgumentId = 1, ArgType = "DateTime", ReportId = 1 }; group = new ReportGroup() { Name = "groupName", ReportGroupId = 1 }; report = new Report() { Description = "someDescription", Name = "someName", ReportId = reportArgument.ReportId, ReportArguments = new List <ReportArgument>() { reportArgument }, ReportGroupId = group.ReportGroupId }; context.AddRange(argumentQuery, reportArgument, group, report); context.SaveChanges(); } }
public static void EnsureSeeded(this DatabaseContext context) { // Ensure we create initial admin user if (!context.Users.Any()) { var users = JsonConvert.DeserializeObject <List <User> >(File.ReadAllText(@"seed" + Path.DirectorySeparatorChar + "users.json")); context.AddRange(users); context.SaveChanges(); } // Ensure we create initial admin role if (!context.Roles.Any()) { //var roles = JsonConvert.DeserializeObject<List<Role>>(File.ReadAllText(@"seed" + Path.DirectorySeparatorChar + "roles.json")); //context.AddRange(roles); //context.SaveChanges(); } // Ensure we create initial admin profile if (!context.UserProfiles.Any()) { //List<UserProfile> profiles = JsonConvert.DeserializeObject<List<UserProfile>>(File.ReadAllText(@"seed" + Path.DirectorySeparatorChar + "profiles.json")); //context.UserProfiles.AddRange(profiles); //context.SaveChanges(); } }
public void GivenSearchParametersStatusFilterUpperCaseMatchingOrganisationsGetReturned() { var organisations = EntityHelpers.CreateOrganisations(10).ToList(); var orgToFind = EntityHelpers.CreateOrganisation(); orgToFind.Status = "published"; organisations.Add(orgToFind); DatabaseContext.AddRange(organisations); DatabaseContext.SaveChanges(); var searchParams = new OrganisationSearchRequest(); searchParams.Search = orgToFind.Name; searchParams.Sort = "Name"; searchParams.Status = "PUBLISHED"; searchParams.Direction = SortDirection.Asc.ToString(); var gatewayResult = _classUnderTest.SearchOrganisations(searchParams).Result; gatewayResult.Should().NotBeNull(); gatewayResult.First().Should().BeEquivalentTo(orgToFind, options => { options.Excluding(ex => ex.ReviewerU); options.Excluding(ex => ex.Services); options.Excluding(ex => ex.UserOrganisations); return(options); }); }
protected override async Task Seed(DatabaseContext db) { if (db.Bookmarks.Any()) { return; } db.AddRange(new object[] { new Bookmark() { url = "https://www.google.nl", user_id = 1 }, new Bookmark() { url = "https://www.dumpert.nl", user_id = 1 }, new Bookmark() { url = "https://www.tweakers.nl", user_id = 1 }, new Bookmark() { url = "https://www.nu.nl", user_id = 2 }, }); await db.SaveChangesAsync(); }
public async Task InitAsync() { var currentSeason = await context.Seasons.OrderByDescending(o => o.EndDate).FirstOrDefaultAsync(); if (currentSeason.EndDate > dateTimeProvider.Now) { return; } var progresses = await context.Users .Select(o => new SeasonProgress() { SeasonId = currentSeason.Id, UserId = o.Id, Position = context.FighterEloRatings .Where(r => r.CurrentElo > (context.FighterEloRatings.Where(e => e.Fighter.UserId == o.Id).FirstOrDefault() == null ? 0 : context.FighterEloRatings.Where(e => e.Fighter.UserId == o.Id).OrderByDescending(e => e.CurrentElo).FirstOrDefault().CurrentElo)).Count(), }).ToListAsync(); await seasonMatchRemover.RemoveAsync(context); context.AddRange(progresses); context.Add(await seasonCreator.CreateAsync()); await context.SaveChangesAsync(); foreach (var progress in progresses) { backgroundJobClient.Enqueue <ISeasonUserJob>(o => o.ExecuteAsync(progress.SeasonId, progress.UserId)); } }
private void ResetFighter(Fighter fighter, Random random, DatabaseContext context) { fighter.Level = 0; if (fighter.Configuration != null) { fighter.Configuration.AttunementId = null; } fighterLevelUpHandler.Up(fighter); var armorHead = equipmentGenerator.GenerateArmorHead(fighter.Level, ItemRarity.Basic, fighter.UserId); var armorShoulders = equipmentGenerator.GenerateArmorShoulders(fighter.Level, ItemRarity.Basic, fighter.UserId); var armorChest = equipmentGenerator.GenerateArmorChest(fighter.Level, ItemRarity.Basic, fighter.UserId); var armorHands = equipmentGenerator.GenerateArmorHands(fighter.Level, ItemRarity.Basic, fighter.UserId); var armorLegs = equipmentGenerator.GenerateArmorLegs(fighter.Level, ItemRarity.Basic, fighter.UserId); var armorShoes = equipmentGenerator.GenerateArmorShoes(fighter.Level, ItemRarity.Basic, fighter.UserId); var weaponType = EquipmentConstants.Weapons.Random(random); var weapon = equipmentGenerator.GenerateEquipment(weaponType, fighter.Level, ItemRarity.Basic, fighter.UserId); fighterOutfitter.Equip(fighter, armorHead, true); fighterOutfitter.Equip(fighter, armorShoulders, true); fighterOutfitter.Equip(fighter, armorChest, true); fighterOutfitter.Equip(fighter, armorHands, true); fighterOutfitter.Equip(fighter, armorLegs, true); fighterOutfitter.Equip(fighter, armorShoes, true); fighterOutfitter.Equip(fighter, weapon, true); context.AddRange(armorHead, armorShoulders, armorChest, armorHands, armorLegs, armorShoes, weapon); }
public async Task GetIncidentByIdAsyncShouldReturnNullIfThereNoMatchingId() { int testId = 110; optionsBuilder.UseInMemoryDatabase("GetIncidentByIdAsyncShouldReturnNullIfThereNoMatchingId"); using (var context = new DatabaseContext(optionsBuilder.Options)) { context.AddRange ( new Incident { Description = "Regular 'dividing by zero' incident, nothing special", Status = "Opened" }, new Incident { Description = "Pug-dog rebellion", Status = "Pending" }, new Incident { Description = "Grass is green", Status = "Declined" } ); IIncidentService testIncidentService = new IncidentService(context); var incident = await testIncidentService.GetIncidentByIdAsync(testId); Assert.AreEqual(null, incident); } }
public void GivenAnIdAndStartDateAllMatchingAnalyticsEventsGetReturned() { var analyticsEvents = EntityHelpers.CreateAnalyticsEvents().ToList(); var org = analyticsEvents[0].Service.Organisation; analyticsEvents[1].Service.Organisation = org; analyticsEvents[1].Service.OrganisationId = org.Id; analyticsEvents[2].Service.Organisation = org; analyticsEvents[2].Service.OrganisationId = org.Id; analyticsEvents[0].TimeStamp = new DateTime(2020, 4, 11, 11, 0, 0); analyticsEvents[1].TimeStamp = new DateTime(2020, 4, 11, 11, 0, 0); analyticsEvents[2].TimeStamp = new DateTime(2020, 1, 11, 11, 0, 0); var startDate = new DateTime(2020, 4, 11, 10, 0, 0); DatabaseContext.AddRange(analyticsEvents); DatabaseContext.SaveChanges(); var analyticsEventQuery = new AnalyticsEventQuery { OrganisationId = org.Id, StartDateTime = startDate }; var gatewayResult = _classUnderTest.GetAnalyticsEvents(analyticsEventQuery); var expectedResult = DatabaseContext.AnalyticsEvents .Where(x => x.Service.OrganisationId == analyticsEventQuery.OrganisationId) .Where(x => x.TimeStamp >= analyticsEventQuery.StartDateTime); gatewayResult.Should().NotBeNull(); gatewayResult.Should().BeEquivalentTo(expectedResult, options => { options.Excluding(ex => ex.Service); return(options); }); gatewayResult.Count.Should().Be(2); }
public async Task GetAllIncidentsAsyncShouldReturnAllIncidents() { optionsBuilder.UseInMemoryDatabase("GetAllIncidentsAsyncShouldReturnAllIncidents"); using (var context = new DatabaseContext(optionsBuilder.Options)) { context.AddRange ( new Incident { Description = "Regular 'dividing by zero' incident, nothing special", Status = "Opened" }, new Incident { Description = "Pug-dog rebellion", Status = "Pending" }, new Incident { Description = "Grass is green", Status = "Declined" } ); context.SaveChanges(); IIncidentService testIncidentService = new IncidentService(context); var incidents = await testIncidentService.GetAllIncidentsAsync(); incidents.ToList(); Assert.AreEqual(3, incidents.Count()); } }
public async Task GetSingleIncidentByExpressionAsyncShouldReturnSingleIncidentByExpressionIncidentById() { int testId = 3; Expression <Func <Incident, bool> > testExpression = IncidentQueries.IncidentById(testId); optionsBuilder.UseInMemoryDatabase("GetSingleIncidentByExpressionAsyncShouldReturnSingleIncidentByExpressionIncidentById"); using (var context = new DatabaseContext(optionsBuilder.Options)) { context.AddRange ( new Incident { Description = "Regular 'dividing by zero' incident, nothing special", Status = "Opened" }, new Incident { Description = "Pug-dog rebellion", Status = "Pending" }, new Incident { Description = "Grass is green", Status = "Declined" } ); IIncidentService testIncidentService = new IncidentService(context); var incident = await testIncidentService.GetSingleIncidentByExpressionAsync(testExpression); Assert.AreNotEqual(null, incident); Assert.AreEqual(testId, incident.IncidentId); } }
public async Task GetOrganisationByIdReturnsOrganisation() { var session = EntityHelpers.CreateSession("Admin"); DatabaseContext.Sessions.Add(session); Client.DefaultRequestHeaders.Add("Cookie", $"access_token={session.Payload}"); var analyticsEvents = EntityHelpers.CreateAnalyticsEvents().ToList(); var org = analyticsEvents[0].Service.Organisation; analyticsEvents[1].Service.Organisation = org; analyticsEvents[1].Service.OrganisationId = org.Id; DatabaseContext.AddRange(analyticsEvents); DatabaseContext.SaveChanges(); var requestUri = new Uri($"api/v1/analytics-event/?organisationid={org.Id}", UriKind.Relative); var response = await Client.GetAsync(requestUri).ConfigureAwait(true); response.StatusCode.Should().Be(200); var content = response.Content; var stringResponse = await content.ReadAsStringAsync().ConfigureAwait(true); var deserializedBody = JsonConvert.DeserializeObject <AnalyticsResponseList>(stringResponse); deserializedBody.Should().NotBeNull(); }
private async Task IndexNewEpisodes(string[] newFiles, Library library) { var newEpisodes = FileIndexer.IndexEpisodeFiles(newFiles, library.Id).ToList(); var details = await _metadataService.FindSeriesDetails(newEpisodes, library); if (!details.Any()) { return; } await _deduplicationService.DeduplicateEntities(details, d => d.Genres); await _deduplicationService.DeduplicateEntities(details, d => d.CreatedBy); var newProductionCompanyIds = await _deduplicationService.DeduplicateEntities(details, d => d.ProductionCompanies); var newNetworkIds = await _deduplicationService.DeduplicateEntities(details, d => d.Networks); await _deduplicationService.DeduplicateSeriesMetadata(details); _context.AddRange(newEpisodes); await _context.SaveChangesAsync(); await _distributedCache.ClearList("overview", "sys"); foreach (var detail in details) { _backgroundJobClient.Enqueue <ImageProcessor>(service => service.ProcessSeries(detail.Id)); } if (newNetworkIds.Any()) { _backgroundJobClient.Enqueue <ImageProcessor>(service => service.ProcessNetworks(newNetworkIds)); } if (newProductionCompanyIds.Any()) { _backgroundJobClient.Enqueue <ImageProcessor>(service => service.ProcessProductionCompanies(newProductionCompanyIds)); } foreach (var episodes in newEpisodes.GroupBy(e => e.SeriesDetailsId)) { _backgroundJobClient.Enqueue <FileAnalysisService>(service => service.AnalyseEpisodeFiles(episodes.Select(e => e.Id).ToArray(), library.Id)); } }
public async Task <IActionResult> PostUserExperience([FromBody] List <UserExperience> userExperience) { var users = _context.UserExperience.Where(x => x.UserId == userExperience.FirstOrDefault().UserId); _context.RemoveRange(users); _context.AddRange(userExperience); await _context.SaveChangesAsync(); return(Ok()); }
public void CreateNew(StockElementDTO newStockElements) { using (var dbContext = new DatabaseContext()) { var stockElements = StockElementFactory.ConvertToEntity(newStockElements); stockElements.Select(x => { x.PurchaseDate = DateTime.Now; return(x); }).ToList(); dbContext.AddRange(stockElements); dbContext.SaveChanges(); } }
public void SeedCustomers(string fileLocation) { var customers = GetCustomersFromTextFile(fileLocation); databaseContext.Customers.RemoveRange(databaseContext.Customers); databaseContext.Addresses.RemoveRange(databaseContext.Addresses); databaseContext.Relations.RemoveRange(databaseContext.Relations); databaseContext.AddRange(customers); databaseContext.SaveChanges(); }
public MockDatabase(params EntityBase[] entities) { var options = new DbContextOptionsBuilder <DatabaseContext>() .UseInMemoryDatabase("TestDb").Options; _context = new DatabaseContext(options); _context.AddRange(entities); _context.SaveChanges(); }
public static void SeedData(DatabaseContext databaseContext) { if (databaseContext.Customers.Any()) { return; } var userData = System.IO.File.ReadAllText("Data/customer-seed.json"); var customers = JsonConvert.DeserializeObject <List <Customer> >(userData); databaseContext.AddRange(customers); databaseContext.SaveChanges(); }
public async Task ClaimAsync(DatabaseContext context, long userId) { var rewards = await context.Rewards .Where(o => o.UserId == userId) .AsTracking() .Where(o => o.Claimed == null) .ToListAsync(); foreach (var reward in rewards) { reward.Claimed = dateTimeProvider.Now; context.AddRange(rewardFactory.Claim(reward).ToList()); } }
BuildResolver <TResult>(params TResult[] results) where TResult : class { var dbContext = new DatabaseContext <TResult>(_resource); dbContext.Database.EnsureCreated(); dbContext.AddRange(results); dbContext.SaveChanges(); var services = new ServiceCollection(); services.AddSingleton(dbContext); return(services, ctx => ctx.Service <DatabaseContext <TResult> >().Data.AsQueryable()); }
private void Seed(DatabaseContext db) { var dictionaries = new[] { new Dictionary() { Id = 1, Name = "Test1" }, new Dictionary() { Id = 2, Name = "Test2" }, }; db.AddRange(dictionaries); db.SaveChanges(); }
private void AddToIdListDb(List <Tuple <uint, string> > itemsToAdd) { using (var context = new DatabaseContext()) { //add items that aren't in the VnIdList to the table var idlist = context.VnIdList.Select(x => x.VnId); List <VnIdList> vnData = (from item in itemsToAdd where !idlist.Contains(item.Item1) select new VnIdList() { VnId = item.Item1, Title = item.Item2 }).ToList(); context.AddRange(vnData); context.SaveChanges(); } }
private void Seed(DatabaseContext db) { var operatorVehicles = new[] { new OperatorVehicle() { Id = 1, OperatorId = 2, VehicleId = 3 }, new OperatorVehicle() { Id = 2, OperatorId = 2, VehicleId = 3 }, }; db.AddRange(operatorVehicles); db.SaveChanges(); }
public void GivenNoTaxonomyVocabularyIdAllTaxonomiesAreReturned() { var taxonomies = EntityHelpers.CreateTaxonomies(3).ToList(); DatabaseContext.AddRange(taxonomies); DatabaseContext.SaveChanges(); var gatewayResult = _classUnderTest.GetAllTaxonomies(); var expectedResult = DatabaseContext.Taxonomies.AsQueryable(); gatewayResult.Should().NotBeNull(); gatewayResult.Should().BeEquivalentTo(expectedResult, options => { options.Excluding(ex => ex.ServiceTaxonomies); return(options); }); }
private void Seed(DatabaseContext db) { var operatorCities = new[] { new OperatorCity() { Id = 1, CityId = 1, DictionaryId = 1, OperatorContainerId = 1 }, new OperatorCity() { Id = 2, CityId = 1, DictionaryId = 1, OperatorContainerId = 1 }, }; db.AddRange(operatorCities); db.SaveChanges(); }
private void Seed(DatabaseContext db) { var vehicles = new[] { new Vehicle() { Id = 1, VehicleNumbers = "RP-1223", YearOfProduction = 2010 }, new Vehicle() { Id = 2, VehicleNumbers = "21", YearOfProduction = 2012 }, }; db.AddRange(vehicles); db.SaveChanges(); }
private void Seed(DatabaseContext db) { var operatorContainers = new[] { new OperatorContainer() { Id = 1, Name = "Test1" }, new OperatorContainer() { Id = 2, Name = "Test2" }, }; db.AddRange(operatorContainers); db.SaveChanges(); }