ibrowser.py
author Radek Brich <radek.brich@devl.cz>
Tue, 11 Dec 2012 10:49:42 +0100
changeset 52 26121a8fe78b
child 104 d8ff52a0390f
permissions -rwxr-xr-x
Update analyzeall tool: add REINDEX option. Add ibrowser tool (useful for PgBrowser testing). Fix PgBrowser.list_columns default value.

#!/usr/bin/env python3
"""
interactive schema browser

Connect to specified database and open interactive shell.

PgBrowser instance is "browser".

Example:

>>> browser.schemas['myschema'].tables['mytable'].columns['id'].default
"nextval('mytable_id_seq'::regclass)"

"""

from pgtoolkit import pgbrowser, toolbase

import code


class InteractiveBrowserTool(toolbase.SimpleTool):
    def __init__(self):
        toolbase.SimpleTool.__init__(self, name='ibrowser', desc='Interactive schema browser.')
        self.init()

    def main(self):
        browser = pgbrowser.PgBrowser(self.pgm.get_conn('target'))
        shell = code.InteractiveConsole(locals())
        shell.interact()


tool = InteractiveBrowserTool()
tool.main()