public void Sql()
{
if (!TestHelper.GetDlcPath(out string dlcPath))
{
return;
}
// create .df
var dfPath = Path.Combine(TestFolder, "sql.df");
File.WriteAllText(dfPath, "ADD 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 FIELD \"field2\" OF \"table1\" AS integer \n DESCRIPTION \"field two\"\n FORMAT \"9\"\n INITIAL 0\n POSITION 3\n ORDER 20\n");
using (var dataAdmin = new UoeDatabaseAdministrator(dlcPath)) {
var db = GetDb("sql");
dataAdmin.CreateWithDf(db, dfPath);
var dbConnect = dataAdmin.GetDatabaseConnection(db);
// load sql
var table1Path = Path.Combine(TestFolder, "PUB.table1.dsql");
File.WriteAllText(table1Path, "\"value1\" 1\n\"value2\" 2\n");
dataAdmin.LoadSqlData(dbConnect, TestFolder);
File.Delete(table1Path);
// dump sql
dataAdmin.DumpSqlData(dbConnect, TestFolder);
Assert.IsTrue(File.Exists(table1Path));
}
}
