public async Task <IActionResult> LoadColdData() { await _importMetaDataService.ImportAllCurrencies(); await _importMetaDataService.ImportAllExchanges(); await _importMetaDataService.ImportAllExchangePairs(); return(Ok()); }
public async Task ImportAllExchangePairs() { //using (var cntx = Context()) //{ // Currency currency = new Currency // { // Symbol = "BTC" // }; // cntx.Currencies.Add(currency); // cntx.SaveChanges(); //} //using (var cntx = Context()) //{ // Currency currency = new Currency // { // Symbol = "BTC" // }; // cntx.Currencies.Add(currency); // cntx.SaveChanges(); //} //using (var cntx = Context()) //{ // var all = cntx.Currencies.ToList(); //} //using (var cntx = Context()) //{ // Exchange exchange = new Exchange // { // Name = "DSX" // }; // cntx.Exchanges.Add(exchange); // cntx.SaveChanges(); //} //using (var cntx = Context()) //{ // Exchange exchange = new Exchange // { // Name = "ABCC" // }; // cntx.Exchanges.Add(exchange); // cntx.SaveChanges(); //} //using (var cntx = Context()) //{ // ExchangePair exchangePair = new ExchangePair // { // CurrencyFromId = cntx.Currencies.FirstOrDefault(c => c.Symbol == "BTC").Id, // CurrencyToId = cntx.Currencies.FirstOrDefault(c => c.Symbol == "ETH").Id, // ExchangeId = cntx.Exchanges.FirstOrDefault(c => c.Name == "DSX").Id, // }; // cntx.Pairs.Add(exchangePair); // cntx.SaveChanges(); //} //using (var cntx = Context()) //{ // ExchangePair exchangePair = new ExchangePair // { // CurrencyFromId = cntx.Currencies.FirstOrDefault(c => c.Symbol == "BTC").Id, // CurrencyToId = cntx.Currencies.FirstOrDefault(c => c.Symbol == "ETH").Id, // ExchangeId = cntx.Exchanges.FirstOrDefault(c => c.Name == "ABCC").Id, // }; // cntx.Pairs.Add(exchangePair); // cntx.SaveChanges(); //} //using (var cntx = Context()) //{ // ExchangePair exchangePair = new ExchangePair // { // CurrencyFromId = cntx.Currencies.FirstOrDefault(c => c.Symbol == "ETH").Id, // CurrencyToId = cntx.Currencies.FirstOrDefault(c => c.Symbol == "BTC").Id, // ExchangeId = cntx.Exchanges.FirstOrDefault(c => c.Name == "ABCC").Id, // }; // cntx.Pairs.Add(exchangePair); // cntx.SaveChanges(); //} //using (var cntx = Context()) //{ // var pairs = cntx.Pairs // .Include(x => x.CurrencyFrom) // .Include(x => x.CurrencyTo) // .Include(x => x.Exchange) // .ToList(); //} await ImportAllCurrencies(); await ImportAllExchanges(); await _coldImportTests.ImportAllExchangePairs(); CoreDBContext context = Context(); ExchangePair pair = await context.Pairs .Include(x => x.CurrencyFrom) .Include(x => x.CurrencyTo) .Include(x => x.Exchange) .FirstOrDefaultAsync(x => x.Exchange.Name == "DSX"); Assert.NotNull(pair); Assert.NotNull(pair.Exchange); Assert.NotNull(pair.CurrencyFrom); Assert.NotNull(pair.CurrencyTo); Assert.Equal("DSX", pair.Exchange.Name); }