public void GetPlot_Strata() { var unitCode = "u1"; var strata = new string[] { "st1", "st2" }; var plotNumber = 1; var plotID = Guid.NewGuid().ToString(); var cruiseID = CruiseID; using (var database = CreateDatabase()) { var datastore = new CuttingUnitDatastore(database, cruiseID, TestDeviceInfoService.TEST_DEVICEID, new SamplerInfoDataservice(database, CruiseID, TestDeviceInfoService.TEST_DEVICEID)); datastore.GetPlotsByUnitCode(unitCode).Should().BeEmpty("we havn't added any plots yet"); database.Execute($"INSERT INTO Plot (CruiseID, PlotID, CuttingUnitCode, PlotNumber) VALUES " + $"('{cruiseID}', '{plotID}', '{unitCode}', {plotNumber})"); foreach (var st in strata) { database.Execute($"INSERT INTO Plot_Stratum (CruiseID, CuttingUnitCode, PlotNumber, StratumCode) VALUES " + $"('{cruiseID}', '{unitCode}', {plotNumber}, '{st}');"); } var stPlots = datastore.GetPlot_Strata(unitCode, plotNumber); stPlots.Should().HaveCount(strata.Count()); foreach (var ps in stPlots) { ValidatePlot_Stratum(ps, true); } } }
public void GetPlotsByUnitCode() { var unitCode = "u1"; var plotNumber = 1; var plotID = Guid.NewGuid().ToString(); var cruiseID = CruiseID; using (var database = CreateDatabase()) { var datastore = new CuttingUnitDatastore(database, cruiseID, TestDeviceInfoService.TEST_DEVICEID, new SamplerInfoDataservice(database, CruiseID, TestDeviceInfoService.TEST_DEVICEID)); datastore.GetPlotsByUnitCode(unitCode).Should().BeEmpty("we havn't added any plots yet"); database.Execute($"INSERT INTO Plot (CruiseID, PlotID, CuttingUnitCode, PlotNumber) VALUES ('{cruiseID}', '{plotID}', '{unitCode}', {plotNumber});"); datastore.GetPlotsByUnitCode(unitCode).Should().ContainSingle(); } }
public void GetPlot_Strata() { var init = new DatastoreInitializer(); var unit = init.Units[0]; using (var db = init.CreateDatabase()) { var ds = new CuttingUnitDatastore(db, init.CruiseID, TestDeviceInfoService.TEST_DEVICEID, new SamplerInfoDataservice(db, init.CruiseID, init.DeviceID)); ds.AddNewPlot(unit); var plots = ds.GetPlotsByUnitCode(unit); plots.Should().HaveCount(1); var plot = plots.Single(); var plotStrata = ds.GetPlot_Strata(unit, plot.PlotNumber, insertIfNotExists: false); plotStrata.Should().HaveCount(2); } }
public void GetPlot_Stratum() { var units = new string[] { "u1" }; var strata = new[] { new dbModels.Stratum { StratumCode = "st1", Method = "FIX" }, new dbModels.Stratum { StratumCode = "st2", Method = "FIX" }, new dbModels.Stratum { StratumCode = "st3", Method = "FIX" }, }; var unit_strata = new[] { new dbModels.CuttingUnit_Stratum { CuttingUnitCode = "u1", StratumCode = "st1" }, new dbModels.CuttingUnit_Stratum { CuttingUnitCode = "u1", StratumCode = "st2" }, new dbModels.CuttingUnit_Stratum { CuttingUnitCode = "u1", StratumCode = "st3" }, }; var plotNumber = 1; var plotID = Guid.NewGuid().ToString(); using (var database = new CruiseDatastore_V3()) { var saleID = SaleID; var cruiseID = CruiseID; InitializeDatabase(database, cruiseID, saleID, units, strata, unit_strata, null, null, null, null); var datastore = new CuttingUnitDatastore(database, cruiseID, TestDeviceInfoService.TEST_DEVICEID, new SamplerInfoDataservice(database, CruiseID, TestDeviceInfoService.TEST_DEVICEID)); datastore.GetPlotsByUnitCode(units[0]).Should().BeEmpty("we havn't added any plots yet"); database.Execute($"INSERT INTO Plot (CruiseID, PlotID, CuttingUnitCode, PlotNumber) VALUES " + $"('{cruiseID}', '{plotID}', '{units[0]}', {plotNumber})"); foreach (var st in strata) { if (st.StratumCode == "st3") { continue; } database.Execute($"INSERT INTO Plot_Stratum (CruiseID, CuttingUnitCode, PlotNumber, StratumCode) VALUES " + $"('{cruiseID}', '{units[0]}', {plotNumber}, '{st.StratumCode}');"); } foreach (var st in strata) { var plotStratum = datastore.GetPlot_Stratum(units[0], st.StratumCode, plotNumber); ValidatePlot_Stratum(plotStratum, st.StratumCode != "st3"); } var nonExistantPS = datastore.GetPlot_Stratum(units[0], "st3", plotNumber); ValidatePlot_Stratum(nonExistantPS, false); } }