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);
}