public void Sync_Reports_Add() { var rand = new Bogus.Randomizer(); var fromPath = base.GetTempFilePath(".crz3", "Sync_Reports_Add_fromFile"); var toPath = base.GetTempFilePath(".crz3", "Sync_Reports_Add_toFile"); var syncOptions = new CruiseSyncOptions() { Processing = SyncFlags.Insert, }; var cruiseID = Guid.NewGuid().ToString(); var saleID = Guid.NewGuid().ToString(); using var fromDb = CreateDatabaseFile(fromPath, cruiseID, saleID); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); var reportID = Guid.NewGuid().ToString(); var report = new Reports { CruiseID = cruiseID, ReportID = reportID, Title = rand.String(), }; fromDb.Insert(report); var syncer = new CruiseSyncer(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("Reports", "WHERE ReportID = @p1", reportID).Should().Be(1); }
public void SyncVolumeEquations_Add() { var rand = new Bogus.Randomizer(); var fromPath = base.GetTempFilePath(".crz3", "SyncVolumeEquations_Add_fromFile"); var toPath = base.GetTempFilePath(".crz3", "SyncVolumeEquations_Add_toFile"); var syncOptions = new CruiseSyncOptions() { Processing = SyncFlags.Insert, }; var cruiseID = Guid.NewGuid().ToString(); var saleID = Guid.NewGuid().ToString(); using var fromDb = CreateDatabaseFile(fromPath, cruiseID, saleID); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); var volEq = new VolumeEquation { CruiseID = cruiseID, Species = "sp1", PrimaryProduct = "01", VolumeEquationNumber = "something" }; fromDb.Insert(volEq); var syncer = new CruiseSyncer(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("VolumeEquation", "WHERE VolumeEquationNumber = @p1", volEq.VolumeEquationNumber).Should().Be(1); }
public void Sync_UnitStratum_Add() { var fromPath = base.GetTempFilePath(".crz3", "fromFile"); var toPath = base.GetTempFilePath(".crz3", "toFile"); var syncOptions = new CruiseSyncOptions() { Design = SyncFlags.Insert, }; var cruiseID = Guid.NewGuid().ToString(); var saleID = Guid.NewGuid().ToString(); using var fromDb = CreateDatabaseFile(fromPath, cruiseID, saleID); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); var newCUST = new CuttingUnit_Stratum() { CruiseID = cruiseID, CuttingUnitCode = Units[1], StratumCode = NonPlotStrata[0].StratumCode, }; fromDb.Insert(newCUST); var syncer = new CruiseSyncer(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("CuttingUnit_Stratum", "WHERE CuttingUnitCode = @p1 AND StratumCode = @p2", newCUST.CuttingUnitCode, newCUST.StratumCode) .Should().Be(1); }
public void Sync_Device_Add() { var fromPath = base.GetTempFilePath(".crz3", "fromFile"); var toPath = base.GetTempFilePath(".crz3", "toFile"); var syncOptions = new CruiseSyncOptions() { Design = SyncFlags.Insert, }; var cruiseID = Guid.NewGuid().ToString(); var saleID = Guid.NewGuid().ToString(); using var fromDb = CreateDatabaseFile(fromPath, cruiseID, saleID); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); var newDevice = new Device() { CruiseID = cruiseID, DeviceID = Rand.Guid().ToString(), }; fromDb.Insert(newDevice); var syncer = new CruiseSyncer(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("Device", "WHERE DeviceID = @p1 AND CruiseID = @p2", newDevice.DeviceID, newDevice.CruiseID) .Should().Be(1); }
public void Sync_SampleGroup_Delete() { var init = new DatabaseInitializer(); var fromPath = base.GetTempFilePath(".crz3", "Sync_SampleGroup_Delete_fromFile"); var toPath = base.GetTempFilePath(".crz3", "Sync_SampleGroup_Delete_toFile"); using var fromDb = init.CreateDatabaseFile(fromPath); var cruiseID = init.CruiseID; var saleID = init.SaleID; var newStratum = new Stratum { CruiseID = cruiseID, StratumID = Guid.NewGuid().ToString(), StratumCode = "newStratumCode1", }; fromDb.Insert(newStratum); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); fromDb.Delete(newStratum); var syncer = new DeleteSysncer(); var syncOptions = new CruiseSyncOptions(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("Stratum", "WHERE StratumID = @p1", newStratum.StratumID) .Should().Be(0); }
public void Sync_PlotLocation_Add() { var fromPath = base.GetTempFilePath(".crz3", "Sync_Plot_Add_fromFile"); var toPath = base.GetTempFilePath(".crz3", "Sync_Plot_Add_toFile"); var syncOptions = new CruiseSyncOptions() { Design = SyncFlags.Insert, FieldData = SyncFlags.Insert, }; var cruiseID = Guid.NewGuid().ToString(); var saleID = Guid.NewGuid().ToString(); using var fromDb = CreateDatabaseFile(fromPath, cruiseID, saleID); var newPlot = new Plot() { CruiseID = cruiseID, PlotID = Guid.NewGuid().ToString(), CuttingUnitCode = Units[0], PlotNumber = 1, }; fromDb.Insert(newPlot); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); var newPlotLocation = new PlotLocation() { PlotID = newPlot.PlotID, }; fromDb.Insert(newPlotLocation); var syncer = new CruiseSyncer(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("Plot", "WHERE PlotID = @p1", newPlot.PlotID) .Should().Be(1); toDb.GetRowCount("PlotLocation", "WHERE PlotID = @p1", newPlot.PlotID) .Should().Be(1); }
public void Sync_Log_Add() { var fromPath = base.GetTempFilePath(".crz3", "Sync_Plot_Add_fromFile"); var toPath = base.GetTempFilePath(".crz3", "Sync_Plot_Add_toFile"); var syncOptions = new CruiseSyncOptions() { FieldData = SyncFlags.Insert, }; var cruiseID = Guid.NewGuid().ToString(); var saleID = Guid.NewGuid().ToString(); using var fromDb = CreateDatabaseFile(fromPath, cruiseID, saleID); var tree = new Tree() { TreeID = Guid.NewGuid().ToString(), CruiseID = cruiseID, CuttingUnitCode = Units[0], StratumCode = Strata[0].StratumCode, SampleGroupCode = SampleGroups[0].SampleGroupCode, SpeciesCode = Species[0], TreeNumber = 1, }; fromDb.Insert(tree); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); var newLog = new Log() { LogID = Guid.NewGuid().ToString(), CruiseID = cruiseID, LogNumber = "01", TreeID = tree.TreeID, }; fromDb.Insert(newLog); var syncer = new CruiseSyncer(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("Log", "WHERE LogID = @p1", newLog.LogID) .Should().Be(1); }
public void Sync_Plot_Stratum_Add() { var fromPath = base.GetTempFilePath(".crz3", "Sync_Plot_Add_fromFile"); var toPath = base.GetTempFilePath(".crz3", "Sync_Plot_Add_toFile"); var syncOptions = new CruiseSyncOptions() { Design = SyncFlags.Insert, FieldData = SyncFlags.Insert, }; var cruiseID = Guid.NewGuid().ToString(); var saleID = Guid.NewGuid().ToString(); using var fromDb = CreateDatabaseFile(fromPath, cruiseID, saleID); var newPlot = new Plot() { CruiseID = cruiseID, PlotID = Guid.NewGuid().ToString(), CuttingUnitCode = Units[0], PlotNumber = 1, }; fromDb.Insert(newPlot); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); var newPlotStratum = new Plot_Stratum() { CruiseID = cruiseID, PlotNumber = newPlot.PlotNumber, CuttingUnitCode = newPlot.CuttingUnitCode, StratumCode = PlotStrata[0].StratumCode, }; fromDb.Insert(newPlotStratum); var syncer = new CruiseSyncer(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("Plot", "WHERE PlotID = @p1", newPlot.PlotID) .Should().Be(1); toDb.ExecuteScalar2 <int>("SELECT COUNT(*) FROM Plot_Stratum WHERE CruiseID = @CruiseID AND PlotNumber = @PlotNumber AND CuttingUnitCode = @CuttingUnitCode", newPlotStratum) .Should().Be(1); }
public void Sync_TallyLedger_Add() { var fromPath = base.GetTempFilePath(".crz3", "Sync_Unit_Add_fromFile"); var toPath = base.GetTempFilePath(".crz3", "Sync_Unit_Add_toFile"); var syncOptions = new CruiseSyncOptions() { Design = SyncFlags.Insert, FieldData = SyncFlags.Insert, TreeDataFlags = SyncFlags.Insert, TreeFlags = SyncFlags.Insert, }; var cruiseID = Guid.NewGuid().ToString(); var saleID = Guid.NewGuid().ToString(); using var fromDb = CreateDatabaseFile(fromPath, cruiseID, saleID); fromDb.CopyTo(toPath, true); using var toDb = new CruiseDatastore_V3(toPath); var newTallyLedger = new TallyLedger() { CruiseID = cruiseID, TallyLedgerID = Guid.NewGuid().ToString(), CuttingUnitCode = Units[0], StratumCode = SampleGroups[0].StratumCode, SampleGroupCode = SampleGroups[0].SampleGroupCode, TreeCount = 1, }; fromDb.Insert(newTallyLedger); var syncer = new CruiseSyncer(); syncer.Sync(cruiseID, fromDb, toDb, syncOptions); toDb.GetRowCount("TallyLedger", "WHERE TallyLedgerID = @p1", newTallyLedger.TallyLedgerID) .Should().Be(1); }