public void UpsertStratumTemplateTreeFieldSetup(StratumTemplateTreeFieldSetup stfs)
{
Database.Execute2(
@"INSERT INTO StratumTemplateTreeFieldSetup (
StratumTemplateName,
CruiseID,
Field,
FieldOrder,
IsHidden,
IsLocked,
DefaultValueInt,
DefaultValueReal,
DefaultValueBool,
DefaultValueText
) VALUES (
@StratumTemplateName,
@CruiseID,
@Field,
@FieldOrder,
@IsHidden,
@IsLocked,
@DefaultValueInt,
@DefaultValueReal,
@DefaultValueBool,
@DefaultValueText
) ON CONFLICT (StratumTemplateName, CruiseID, Field) DO
UPDATE SET
FieldOrder = @FieldOrder,
IsHidden = @IsHidden,
IsLocked = @IsLocked,
DefaultValueInt = @DefaultValueInt,
DefaultValueReal = @DefaultValueReal,
DefaultValueBool = @DefaultValueBool,
DefaultValueText = @DefaultValueText
WHERE StratumTemplateName = @StratumTemplateName AND CruiseID = @CruiseID AND Field = @Field;",
new
{
stfs.StratumTemplateName,
CruiseID,
stfs.Field,
stfs.FieldOrder,
stfs.IsHidden,
stfs.IsLocked,
stfs.DefaultValueInt,
stfs.DefaultValueReal,
stfs.DefaultValueText,
stfs.DefaultValueBool,
});
}
public void SyncStratumTemplateTreeFieldSetup_Add()
{
var fromPath = base.GetTempFilePath(".crz3", "SyncStratumTemplateTreeFieldSetup_Add_fromFile");
var toPath = base.GetTempFilePath(".crz3", "SyncStratumTemplateTreeFieldSetup_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 StratumTemplateTreeFieldSetup
{
CruiseID = cruiseID,
StratumTemplateName = "something",
Field = "DBH",
};
fromDb.Insert(sttfs);
var syncer = new CruiseSyncer();
syncer.Sync(cruiseID, fromDb, toDb, syncOptions);
toDb.From <StratumTemplateTreeFieldSetup>().Count().Should().Be(1);
}
public void DeleteStratumTemplateTreeFieldSetup(StratumTemplateTreeFieldSetup stfs)
{
Database.Execute("DELETE FROM StratumTemplateTreeFieldSetup StratumTemplateName = @p1 AND CruiseID = @p2 AND Field = @p3;", stfs.StratumTemplateName, CruiseID, stfs.Field);
}
