#!/usr/bin/env python3.2

"""

analyzeall

Analyze/vacuum all tables in selected schemas.

See also "VACUUM ANALYZE VERBOSE;" query.

Unlike that, this program skips pg_catalog etc.

"""

from pgtoolkit import pgbrowser, toolbase

class AnalyzeAllTool(toolbase.SimpleTool):

    def __init__(self):

        toolbase.SimpleTool.__init__(self, name='analyzeall', desc='Analyze all tables.')

        self.parser.add_argument('-s', dest='schema', nargs='*', help='Schema filter')

        self.parser.add_argument('--vacuum', action='store_true', help='Call VACUUM ANALYZE')

        self.parser.add_argument('--reindex', action='store_true', help='Call REINDEX TABLE')

        self.target_isolation_level = 'autocommit'

        self.init()

    def main(self):

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

        if self.args.vacuum:

        if self.args.reindex:

        schema_list = self.args.schema

        if not schema_list:

            schema_list = [schema['name'] for schema in browser.list_schemas() if not schema['system']]

        for schema in schema_list:

            tables = browser.list_tables(schema=schema)

            with self.pgm.cursor('target') as curs:

                for table in tables:

tool = AnalyzeAllTool()

tool.main()