public void SaveToDatabaseTest()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
ObservableCollection <TraitTag> traitTags = db.LoadTraitTags();
var timeprofiles = db.LoadTimeBasedProfiles();
var realDevices = db.LoadRealDevices(out var deviceCategories, out var loadtypes, timeprofiles);
var locations = db.LoadLocations(realDevices, deviceCategories, loadtypes);
db.LoadTransportation(locations, out var transportationDeviceSets,
out var travelRouteSets, out var _,
out var _, loadtypes,
out var chargingStationSets);
db.LoadHouseholdsAndHouses(out var modularHouseholds,
out var houses, out _, traitTags, chargingStationSets,
travelRouteSets, transportationDeviceSets);
var settlementHhs = new ObservableCollection <SettlementHH>();
SettlementHH.LoadFromDatabase(settlementHhs, db.ConnectionString, modularHouseholds, houses,
false);
db.ClearTable(SettlementHH.TableName);
settlementHhs.Clear();
// new one
var hh = new SettlementHH(null, modularHouseholds[0], 1, 1, db.ConnectionString, "hhname",
Guid.NewGuid().ToStrGuid());
hh.SaveToDB();
// test if it's there
SettlementHH.LoadFromDatabase(settlementHhs, db.ConnectionString, modularHouseholds, houses,
false);
(settlementHhs.Count).Should().Be(1);
db.Cleanup();
}
}
public void LoadFromDatabaseTest()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
ObservableCollection <TraitTag> traitTags = db.LoadTraitTags();
var timeprofiles = db.LoadTimeBasedProfiles();
var realDevices = db.LoadRealDevices(out var deviceCategories, out var loadtypes, timeprofiles);
var locations = db.LoadLocations(realDevices, deviceCategories, loadtypes);
db.LoadTransportation(locations, out var transportationDeviceSets,
out var travelRouteSets, out var _,
out var _, loadtypes,
out var chargingStationSets);
db.LoadHouseholdsAndHouses(out var modularHouseholds,
out var houses, out _, traitTags, chargingStationSets, travelRouteSets, transportationDeviceSets);
var settlementHhs = new ObservableCollection <SettlementHH>();
SettlementHH.LoadFromDatabase(settlementHhs, db.ConnectionString, modularHouseholds, houses,
false);
db.Cleanup();
}
}