public void HouseholdTemplateTest2()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
db.ClearTable(HouseholdTemplate.TableName);
db.ClearTable(HHTemplateEntry.TableName);
db.ClearTable(HHTemplateEntryPerson.TableName);
var cat = new CategoryDBBase <HouseholdTemplate>("Household Generator");
var timeBasedProfiles = db.LoadTimeBasedProfiles();
var desires = db.LoadDesires();
var persons = db.LoadPersons();
var realDevices =
db.LoadRealDevices(out var deviceCategories, out _, out var loadTypes, timeBasedProfiles);
var dateBasedProfiles = db.LoadDateBasedProfiles();
var timeLimits = db.LoadTimeLimits(dateBasedProfiles);
var deviceActionGroups = db.LoadDeviceActionGroups();
var deviceActions =
db.LoadDeviceActions(timeBasedProfiles, realDevices, loadTypes, deviceActionGroups);
var locations = db.LoadLocations(realDevices, deviceCategories, loadTypes);
var variables = db.LoadVariables();
var affordances = db.LoadAffordances(timeBasedProfiles, out _,
deviceCategories, realDevices, desires, loadTypes, timeLimits, deviceActions, deviceActionGroups,
locations, variables);
var traittags = db.LoadTraitTags();
var traits = db.LoadHouseholdTraits(locations, affordances, realDevices,
deviceCategories, timeBasedProfiles, loadTypes, timeLimits, desires, deviceActions, deviceActionGroups,
traittags, variables);
var vacations = db.LoadVacations();
var templateTags = db.LoadHouseholdTags();
var datebasedProfiles = db.LoadDateBasedProfiles();
HouseholdTemplate.LoadFromDatabase(cat.It, db.ConnectionString, traits, false, persons, traittags,
vacations,
templateTags, datebasedProfiles);
(cat.MyItems.Count).Should().Be(0);
var gen = cat.CreateNewItem(db.ConnectionString);
var entry = gen.AddEntry(traittags[0], 0, 10);
entry.AddPerson(persons[0]);
cat.SaveToDB();
var generators = new ObservableCollection <HouseholdTemplate>();
HouseholdTemplate.LoadFromDatabase(generators, db.ConnectionString, traits, false, persons, traittags,
vacations, templateTags, datebasedProfiles);
(generators.Count).Should().Be(1);
(generators[0].Entries.Count).Should().Be(1);
(generators[0].Entries[0].Persons.Count).Should().Be(1);
db.Cleanup();
}
}
public void TraitTagTest()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
db.ClearTable(TraitTag.TableName);
var cat = new CategoryDBBase <TraitTag>("Household Trait Tags");
TraitTag.LoadFromDatabase(cat.It, db.ConnectionString, false);
(cat.MyItems.Count).Should().Be(0);
cat.CreateNewItem(db.ConnectionString);
cat.SaveToDB();
var tags = new ObservableCollection <TraitTag>();
TraitTag.LoadFromDatabase(tags, db.ConnectionString, false);
(tags.Count).Should().Be(1);
db.Cleanup();
}
}
public void DesireTest()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
db.ClearTable(Desire.TableName);
var cat = new CategoryDBBase <Desire>("Desires");
Desire.LoadFromDatabase(cat.MyItems, db.ConnectionString, false);
(cat.MyItems.Count).Should().Be(0);
cat.CreateNewItem(db.ConnectionString);
cat.SaveToDB();
var desires = new ObservableCollection <Desire>();
Desire.LoadFromDatabase(desires, db.ConnectionString, false);
(desires.Count).Should().Be(1);
db.Cleanup();
}
}
public void TemplatePersonTest()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
db.ClearTable(TemplatePerson.TableName);
db.ClearTable(TemplatePersonTrait.TableName);
var cat = new CategoryDBBase <TemplatePerson>("TemplatePersons");
var timeBasedProfiles = db.LoadTimeBasedProfiles();
var devices = db.LoadRealDevices(out ObservableCollection <DeviceCategory> deviceCategories, out ObservableCollection <VLoadType> loadTypes,
timeBasedProfiles);
var locations = db.LoadLocations(devices, deviceCategories, loadTypes);
var desires = db.LoadDesires();
var dateBasedProfiles = db.LoadDateBasedProfiles();
var timeLimits = db.LoadTimeLimits(dateBasedProfiles);
var deviceActionGroups = db.LoadDeviceActionGroups();
var deviceActions = db.LoadDeviceActions(timeBasedProfiles, devices,
loadTypes, deviceActionGroups);
var variables = db.LoadVariables();
var affordances = db.LoadAffordances(timeBasedProfiles, out _,
deviceCategories, devices, desires, loadTypes, timeLimits, deviceActions, deviceActionGroups, locations,
variables);
var traitTags = db.LoadTraitTags();
var traits = db.LoadHouseholdTraits(locations, affordances, devices,
deviceCategories, timeBasedProfiles, loadTypes, timeLimits, desires, deviceActions, deviceActionGroups,
traitTags, variables);
var selections = db.LoadDeviceSelections(deviceCategories, devices,
deviceActions, deviceActionGroups);
var persons = db.LoadPersons();
var vacations = db.LoadVacations();
var tags = db.LoadHouseholdTags();
var chhs = db.LoadModularHouseholds(traits, selections, persons, vacations, tags, traitTags);
TemplatePerson.LoadFromDatabase(cat.It, db.ConnectionString, traits, false, chhs, persons);
(cat.MyItems.Count).Should().Be(0);
cat.CreateNewItem(db.ConnectionString);
cat.SaveToDB();
var templatePerson = new ObservableCollection <TemplatePerson>();
TemplatePerson.LoadFromDatabase(templatePerson, db.ConnectionString, traits, false, chhs, persons);
(templatePerson.Count).Should().Be(1);
db.Cleanup();
}
}
public void LocationTest()
{
using (var db = new DatabaseSetup(Utili.GetCurrentMethodAndClass()))
{
db.ClearTable(Location.TableName);
var cat = new CategoryDBBase <Location>("Locations");
var profiles = db.LoadTimeBasedProfiles();
var devices = db.LoadRealDevices(out var deviceCategories, out var loadTypes, profiles);
Location.LoadFromDatabase(cat.MyItems, db.ConnectionString, devices, deviceCategories, loadTypes, false);
(cat.MyItems.Count).Should().Be(0);
var loc = cat.CreateNewItem(db.ConnectionString);
cat.SaveToDB();
loc.AddDevice(devices[0]);
loc.SaveToDB();
var locations = new ObservableCollection <Location>();
Location.LoadFromDatabase(locations, db.ConnectionString, devices, deviceCategories, loadTypes, false);
(locations.Count).Should().Be(1);
(locations[0].LocationDevices.Count).Should().Be(1);
db.Cleanup();
}
}