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); }