diff -r a8b7cd92f39f -r c2e6e24b83d9 listdepends.py --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/listdepends.py Mon Mar 05 18:36:46 2012 +0100 @@ -0,0 +1,25 @@ +#!/usr/bin/env python3.2 + +from pgtoolkit import pgbrowser, toolbase, prettysize + + +class ListDependsTool(toolbase.SimpleTool): + def __init__(self): + toolbase.SimpleTool.__init__(self, name='listdepends', desc='List column dependencies.') + self.parser.add_argument('table', metavar='table', type=str, help='Table name.') + self.parser.add_argument('column', metavar='column', type=str, help='Column name.') + self.parser.add_argument('-s', '--schema', dest='schema', metavar='schema', + type=str, default='public', help='Schema name (default=public).') + self.init() + + def main(self): + browser = pgbrowser.PgBrowser(self.pgm.get_conn('target')) + + objects = browser.list_column_usage(self.args.table, self.args.column, schema=self.args.schema) + for obj in sorted(objects, key=lambda x: (x['type'], x['schema'], x['name'])): + print(obj['type'], ' ', obj['schema'], '.', obj['name'], sep='') + + +tool = ListDependsTool() +tool.main() +