public function testGetSqlWithSetSchema() { $getTablesCommand = new GetTablesCommand(); $getTablesCommand->setSchemaName('foo'); $expect = "SELECT table_name, table_schema FROM information_schema.tables WHERE table_schema <> 'information_schema'\n AND table_schema <> 'pg_catalog' AND table_type = 'BASE TABLE' AND table_schema = 'foo';"; $this->assertEquals($expect, $getTablesCommand->getSql()); }