public static void Destroy(SolarTallyDbContext context)
{
// For SQLite, I'm guessing I need to do this on Destroy().
context.Database.CloseConnection();
context.Database.EnsureDeleted();
context.Dispose();
}
public static SolarTallyDbContext Create()
{
var options = new DbContextOptionsBuilder <SolarTallyDbContext>()
// .UseInMemoryDatabase(Guid.NewGuid().ToString())
.UseSqlite("DataSource=:memory:")
.Options;
var context = new SolarTallyDbContext(options);
// Need to do for SQLite.
context.Database.OpenConnection();
context.Database.EnsureCreated();
var appliances = new[] {
new Appliance("LED", "An LED Bulb", 20, 20),
new Appliance("Washer", "A Frontload Washer", 800, 1000),
new Appliance("Car", "A Tesla", 2000, 2500)
};
context.Appliances.AddRange(appliances);
// TODO: Is this okay to do?
// context.SaveChanges();
var site = new Site("PetroCanada Station");
site.MainAddress = new Address("0 Yonge St.", "Toronto", "Ontario",
"Canada", "M1N2O3");
site.SetPeakSolarInterval(new TimeInterval(8, 0, 15, 0));
foreach (var appliance in appliances)
{
site.Consumption.AddApplianceUsage(appliance);
var au = site.Consumption.ApplianceUsages.Last();
au.SetQuantity(2);
}
context.Sites.Add(site);
context.Consumptions.Add(site.Consumption);
context.ApplianceUsages.AddRange(site.Consumption.ApplianceUsages);
context.SaveChanges();
return(context);
}
public GetSiteBriefsListQueryTests(QueryTestFixture fixture)
{
_context = fixture.Context;
_mapper = fixture.Mapper;
}
public GetApplianceUsageQueryTests(QueryTestFixture fixture)
{
_context = fixture.Context;
_mapper = fixture.Mapper;
}
