public void SaveToDatabase([NotNull] ScenarioSliceParameters slice)
{
lock (_logMessagesForDB) {
var stages = _logMessagesForDB.Select(x => x.DstStage).Distinct().ToList();
foreach (var stage in stages)
{
var onestage = _logMessagesForDB.Where(x => x.DstStage == stage).ToList();
SqlConnectionPreparer ms = new SqlConnectionPreparer(_config);
var db = ms.GetDatabaseConnection(stage, slice);
db.CreateTableIfNotExists <LogMessage>();
db.BeginTransaction();
foreach (var logMessage in onestage)
{
db.Save(logMessage);
_logMessagesForDB.Remove(logMessage);
}
db.CompleteTransaction();
}
}
}
public void TestProfileCreation()
{
SqlConnectionPreparer ms = new SqlConnectionPreparer(Config);
var dbHouses = ms.GetDatabaseConnection(Stage.Houses, Constants.PresentSlice);
var pvEntries = dbHouses.Fetch <PvSystemEntry>();
if (pvEntries.Count == 0)
{
throw new FlaException("No PVEntries");
}
var houseGuids = pvEntries.Select(x => x.HouseGuid).Distinct().Take(10).ToList();
// ReSharper disable AssignNullToNotNullAttribute
ServiceRepository sp = new ServiceRepository(null, null, Logger, Config, new Random());
// ReSharper restore AssignNullToNotNullAttribute
// ReSharper disable AssignNullToNotNullAttribute
var dbdto = new DBDto(null, dbHouses.Fetch <Hausanschluss>(), null, null, null);
// ReSharper restore AssignNullToNotNullAttribute
PVProfileProvider pvp = new PVProfileProvider(sp, Constants.PresentSlice, dbdto);
var hcrc = new HouseComponentRo("name", "type", 1, 1, "status", "", "standort", 0);
foreach (string houseGuid in houseGuids)
{
var pse = pvEntries.Single(x => x.HouseGuid == houseGuid);
ProviderParameterDto parameters = new ProviderParameterDto(pse, "dummydir", hcrc);
pvp.PrepareLoadProfileIfNeeded(parameters);
}
foreach (string houseGuid in houseGuids)
{
var pse = pvEntries.Single(x => x.HouseGuid == houseGuid);
ProviderParameterDto parameters = new ProviderParameterDto(pse, "dummydir", hcrc);
var result = pvp.ProvideProfile(parameters);
Info("Got a profile with " + result?.Profile?.EnergySum());
}
}
public void TestCreationSavingAndKeyCheck()
{
SqlConnectionPreparer ms = new SqlConnectionPreparer(Config);
var db = ms.GetDatabaseConnection(Stage.Testing, Constants.PresentSlice);
Profile p = new Profile("myProfile", new List <double>().AsReadOnly(), EnergyOrPower.Power);
SaveableEntry <Profile> sa = SaveableEntry <Profile> .GetSaveableEntry(db, SaveableEntryTableType.PVGeneration, Logger);
sa.MakeCleanTableForListOfFields(true);
sa.MakeTableForListOfFieldsIfNotExists(true);
string myKey = p.Name;
if (sa.CheckForName(myKey, Logger))
{
throw new FlaException("Key already exists in cleared db");
}
sa.AddRow(p);
sa.SaveDictionaryToDatabase(Logger);
if (!sa.CheckForName(myKey, Logger))
{
throw new FlaException("Saving failed. Key not in db");
}
}
public void RunTest()
{
CompositeResolver.RegisterAndSetAsDefault(NativeDateTimeResolver.Instance, StandardResolver.Instance);
PrepareUnitTest();
Config.Directories.ResultStorageDirectory = WorkingDirectory.Dir;
Config.Directories.CalcServerLpgDirectory = WorkingDirectory.Dir;
// ReSharper disable twice AssignNullToNotNullAttribute
HouseCreationAndCalculationJob hcj = new HouseCreationAndCalculationJob(Scenario.Present().ToString(), "2017", "trafokreis");
HouseData hd = new HouseData("houseguid", "HT01", 1000, 1000, "houseName");
HouseholdData hhd = new HouseholdData("householdguid",
2000,
ElectricCarUse.UseElectricCar,
"householdname",
ElectricCarProvider.ChargingStationSet,
ElectricCarProvider.TransportationDevicesOneCar,
ElectricCarProvider.TravelRouteSet,
new List <TransportationDistanceModifier>(),
HouseholdDataSpecifictionType.ByPersons);
hd.Households.Add(hhd);
hhd.UseElectricCar = ElectricCarUse.UseElectricCar;
hhd.TransportationDeviceSet = ElectricCarProvider.TransportationDevicesOneCar;
hhd.TravelRouteSet = ElectricCarProvider.TravelRouteSet;
hhd.ChargingStationSet = ElectricCarProvider.ChargingStationSet;
hhd.HouseholdDataPersonSpecification = new HouseholdDataPersonSpecification(new List <PersonData> {
new PersonData(30, Gender.Male)
});
hcj.House = hd;
List <HouseCreationAndCalculationJob> houseJobs = new List <HouseCreationAndCalculationJob>();
houseJobs.Add(hcj);
FileHelpers.CopyRec(Config.Directories.LPGReleaseDirectory, WorkingDirectory.Dir, Logger, true);
var endTime = new DateTime(Constants.PresentSlice.DstYear, 1, 10);
ProfileGenerationRo pgro = new ProfileGenerationRo();
HouseProcessor.WriteDistrictsForLPG(houseJobs,
WorkingDirectory.DirDi,
Logger,
Constants.PresentSlice,
endTime,
pgro);
string districtsDir = WorkingDirectory.Combine("Districts");
var districtsDi = new DirectoryInfo(districtsDir);
var files = districtsDi.GetFiles("*.json");
void RunOneFile(FileInfo myfi)
{
ProcessStartInfo psi = new ProcessStartInfo();
psi.FileName = WorkingDirectory.Combine("simulationengine.exe");
psi.UseShellExecute = true;
psi.WorkingDirectory = WorkingDirectory.Dir;
psi.Arguments = "ProcessHouseJob -j \"" + myfi.FullName + "\"";
Info("running " + psi.FileName + " " + psi.Arguments);
using (Process p = new Process()) {
p.StartInfo = psi;
p.Start();
p.WaitForExit();
}
}
foreach (var housejob in files)
{
RunOneFile(housejob);
}
DBDto dbDto = new DBDto(new List <House>(), new List <Hausanschluss>(), new List <Car>(), new List <Household>(), new List <RlmProfile>());
CachingLPGProfileLoader ca = new CachingLPGProfileLoader(Logger, dbDto);
List <int> isns = new List <int>();
isns.Add(10);
CarDistanceEntry cde = new CarDistanceEntry("houseguid",
"householdguid",
"carguid",
20,
20,
isns,
10,
"haguid",
"sourceguid",
"cdename",
CarType.Electric);
HouseComponentRo hcro = new HouseComponentRo("housecomponent", "componeenttype", 1000, 200, "processingstatus", "isns", "standort", 0);
ProviderParameterDto ppd = new ProviderParameterDto(cde, WorkingDirectory.Dir, hcro);
SqlConnectionPreparer scp = new SqlConnectionPreparer(Config);
MyDb db = scp.GetDatabaseConnection(Stage.Testing, Constants.PresentSlice);
SaveableEntry <Profile> sa = SaveableEntry <Profile> .GetSaveableEntry(db, SaveableEntryTableType.LPGProfile, Logger);
sa.MakeTableForListOfFieldsIfNotExists(true);
string dstDir = Path.Combine(WorkingDirectory.Dir, hcj.Trafokreis, hcj.House.Name);
FileHelpers.CopyRec(WorkingDirectory.Combine("Results"), dstDir, Logger, true);
//normal electricity test and cache test
Info("================== ");
Info("electricity");
Info("================== ");
var profElec1 = ca.LoadLPGProfile(ppd,
hcj.Trafokreis,
"Electricity",
sa,
hhd.HouseholdGuid,
out var profsource,
hcj.House.Name,
Config,
true);
Info("Source: " + profsource);
Assert.NotNull(profElec1);
Assert.NotNull(profsource);
var profElecCache = ca.LoadLPGProfile(ppd,
hcj.Trafokreis,
"Electricity",
sa,
hhd.HouseholdGuid,
out var profsourceCache,
hcj.House.Name,
Config,
true);
Info("Source 2: " + profsourceCache);
Assert.NotNull(profsourceCache);
Assert.NotNull(profsource);
profElec1.Should().BeEquivalentTo(profElecCache, options => options.Excluding(ctx => ctx.SelectedMemberPath.EndsWith("BinaryProfile")));
//Car Charging Electricity electricity test and cache test
Info("================== ");
Info("Car Charging Electricity electricity");
Info("================== ");
SaveableEntry <Profile> sa2 = SaveableEntry <Profile> .GetSaveableEntry(db, SaveableEntryTableType.EvProfile, Logger);
sa2.MakeCleanTableForListOfFields(true);
var prof2 = ca.LoadLPGProfile(ppd,
hcj.Trafokreis,
"Car Charging Electricity",
sa2,
hhd.HouseholdGuid,
out var profsource2,
hcj.House.Name,
Config,
true);
Info("Source Wp 1: " + profsource2);
Assert.NotNull(prof2);
Assert.NotNull(profsource2);
var prof3 = ca.LoadLPGProfile(ppd,
hcj.Trafokreis,
"Car Charging Electricity",
sa2,
hhd.HouseholdGuid,
out var profsource3,
hcj.House.Name,
Config,
true);
Info("Source Wp 2: " + profsource3);
Assert.NotNull(prof3);
Assert.NotNull(profsource3);
prof2.Should().BeEquivalentTo(prof3, options => options.Excluding(ctx =>
ctx.SelectedMemberPath.EndsWith("BinaryProfile")));
}