public void ExecuteCreateScriptTest()
{
CreateDatabaseTest();
DDLHelper target = new DDLHelper(db);
db.ChangeDatabase("information_schema");
DataSet ds = db.ExecuteQuery("SELECT * FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='" + schema_name + "'");
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 1)
{
Assert.Inconclusive("database does not exist");
return;
}
db.ChangeDatabase(schema_name);
// todo could be a DE
string file = @"..\..\..\GUI\bin\Debug\sql\create.sql";
// needs to be realtive
target.ExecuteCreateScript(file);
db.ChangeDatabase("information_schema");
ds = db.ExecuteQuery("SELECT * FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='" + schema_name + "'");
dt = ds.Tables[0];
Assert.IsTrue(dt.Rows.Count > 0);
}
