diff -r d6088dba8fea -r 2a2d0d5df03b listdepends.py --- a/listdepends.py Tue May 06 18:37:41 2014 +0200 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,25 +0,0 @@ -#!/usr/bin/env python3 - -from pgtoolkit import pgbrowser, toolbase - - -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() -