private function doTestBuildsInOrder($format)
{
dbsteward::set_sql_format($format);
$doc = $this->doc_with;
$actual = $this->capture(function ($ofs) use($doc) {
format::build_schema($doc, $ofs, array());
});
if ($format == 'pgsql8') {
$expected = <<<SQL
CREATE OR REPLACE VIEW "public"."view2" AS SELECT * FROM elsewhere;
ALTER VIEW "public"."view2" OWNER TO deployment;
CREATE OR REPLACE VIEW "public"."view1" AS SELECT * FROM view2;
ALTER VIEW "public"."view1" OWNER TO deployment;
SQL;
} else {
$expected = <<<SQL
CREATE OR REPLACE DEFINER = deployment SQL SECURITY DEFINER VIEW `view2` AS SELECT * FROM elsewhere;
CREATE OR REPLACE DEFINER = deployment SQL SECURITY DEFINER VIEW `view1` AS SELECT * FROM view2;
SQL;
}
$this->assertEquals($expected, $actual);
}
