public void UpsertStratumTemplateLogFieldSetup(StratumTemplateLogFieldSetup stlfs)
{
Database.Execute(
@"INSERT INTO StratumTemplateLogFieldSetup (
StratumTemplateName,
CruiseID,
Field,
FieldOrder
) VALUES (
@StratumTemplateName,
@CruiseID,
@Field,
@FieldOrder
) ON CONFLICT (StratumTemplateName, CruiseID, Field) DO
UPDATE StratumTemplateLogFieldSetup SET
FieldOrder = @FieldOrder
WHERE StratumTemplateName = @StratumTemplateName AND CruiseID = @CruiseID AND Field = @Field;",
new
{
stlfs.StratumTemplateName,
CruiseID,
stlfs.Field,
stlfs.FieldOrder,
});
}
public void SyncStratumTemplateLogFieldSetup_Add()
{
var fromPath = base.GetTempFilePath(".crz3", "SyncStratumTemplateLogFieldSetup_Add_fromFile");
var toPath = base.GetTempFilePath(".crz3", "SyncStratumTemplateLogFieldSetup_Add_toFile");
var syncOptions = new CruiseSyncOptions()
{
Processing = SyncFlags.Insert,
};
var init = new DatabaseInitializer();
var cruiseID = init.CruiseID;
var saleID = init.SaleID;
using var fromDb = init.CreateDatabaseFile(fromPath);
fromDb.CopyTo(toPath, true);
using var toDb = new CruiseDatastore_V3(toPath);
var st = new StratumTemplate
{
CruiseID = cruiseID,
StratumTemplateName = "something",
};
fromDb.Insert(st);
var sttfs = new StratumTemplateLogFieldSetup
{
CruiseID = cruiseID,
StratumTemplateName = "something",
Field = "Grade",
};
fromDb.Insert(sttfs);
var syncer = new CruiseSyncer();
syncer.Sync(cruiseID, fromDb, toDb, syncOptions);
toDb.From <StratumTemplateLogFieldSetup>().Count().Should().Be(1);
}
public void DeleteStratumTemplateLogFieldSetup(StratumTemplateLogFieldSetup stlfs)
{
Database.Execute("DELETE FROM StratumTemplateLogFieldSetup WHERE StratumTemplateName = @p1 AND CruiseID = @p2 AND Field = @p3;"
, stlfs.StratumTemplateName, CruiseID, stlfs.Field);
}
