schema_name/pg4wp/rewriters/ShowTablesSQLRewriter.php

<?php

class ShowTablesSQLRewriter extends AbstractSQLRewriter
{
    public function rewrite(): string
    {
        $schema = DB_SCHEMA;
        return 'SELECT tablename FROM pg_tables WHERE schemaname = \'$schema\';';
    }
}
Polymorphic refactor + improvements to select sql rewriting 2023-10-28 02:56:41 -07:00			`<?php`

			`class ShowTablesSQLRewriter extends AbstractSQLRewriter`
			`{`
			`public function rewrite(): string`
			`{`
swap hardcoded public values for DB_SCHEMA constant 2024-10-18 23:07:05 -07:00			`$schema = DB_SCHEMA;`
extract public to schema variable so we can use a constant later 2024-02-21 01:22:57 -08:00			`return 'SELECT tablename FROM pg_tables WHERE schemaname = \'$schema\';';`
Polymorphic refactor + improvements to select sql rewriting 2023-10-28 02:56:41 -07:00			`}`
			`}`