listtables.py
author Radek Brich <brich.radek@ifortuna.cz>
Tue, 29 Apr 2014 17:50:15 +0200
changeset 98 024299702087
parent 93 b72591087495
child 101 2a2d0d5df03b
permissions -rwxr-xr-x
Update batchcopy: When target record exists, allow to ignore / update the error (--dst-exists parameter).

#!/usr/bin/env python3

from pgtoolkit import pgbrowser, toolbase


class ListTablesTool(toolbase.SimpleTool):
    def __init__(self):
        toolbase.SimpleTool.__init__(self, name='listtables', desc='List tables in database.')
        self.parser.add_argument('-o', dest='options', type=str, nargs='*', help='Filter by options (eg. -o autovacuum_enabled=false).')
        self.init()

    def main(self):
        browser = pgbrowser.PgBrowser(self.pgm.get_conn('target'))

        # scan all tables from all shemas, remember names and sizes
        tables = []
        for schema in browser.schemas.values():
            for table in schema.tables.values():
                for option in self.args.options:
                    if option in table.options:
                        tables.append(table)

        # print result
        if len(tables):
            print('Found %d tables:' % len(tables))
        else:
            print('No table meets the conditions.')
        for table in tables:
            table_name = '%s.%s' % (table.schema.name, table.name)
            print(' ', table_name)


tool = ListTablesTool()
tool.main()