public void LoadSchemaDefinition()
{
if (!TestHelper.GetDlcPath(out string dlcPath))
{
return;
}
var ope = new UoeDatabaseOperator(dlcPath);
var db = GetDb("loaddf");
var dfPath = Path.Combine(TestFolder, $"{db.PhysicalName}.df");
ope.Create(db);
Assert.IsTrue(db.Exists());
// create .df
File.WriteAllText(dfPath, "ADD SEQUENCE \"sequence1\"\n INITIAL 0\n INCREMENT 1\n CYCLE-ON-LIMIT no\n\nADD TABLE \"table1\"\n AREA \"Schema Area\"\n DESCRIPTION \"table one\"\n DUMP-NAME \"table1\"\n\nADD FIELD \"field1\" OF \"table1\" AS character \n DESCRIPTION \"field one\"\n FORMAT \"x(8)\"\n INITIAL \"\"\n POSITION 2\n MAX-WIDTH 16\n ORDER 10\n\nADD INDEX \"idx_1\" ON \"table1\" \n AREA \"Schema Area\"\n PRIMARY\n INDEX-FIELD \"field1\" ASCENDING\n");
using (var dataAdmin = new UoeDatabaseAdministrator(dlcPath)) {
dataAdmin.LoadSchemaDefinition(UoeDatabaseConnection.NewSingleUserConnection(db), dfPath);
}
ope.Delete(db);
ope.Create(db);
// create .df
File.WriteAllText(dfPath, "ADD FIELD \"field1\" OF \"table1\" AS character \n DESCRIPTION \"field one\"\n FORMAT \"x(8)\"\n INITIAL \"\"\n POSITION 2\n MAX-WIDTH 16\n ORDER 10\n");
using (var dataAdmin = new UoeDatabaseAdministrator(dlcPath)) {
Assert.ThrowsException <UoeDatabaseException>(() => dataAdmin.LoadSchemaDefinition(UoeDatabaseConnection.NewSingleUserConnection(db), dfPath));
}
}
