listdepends.py
changeset 101 2a2d0d5df03b
parent 100 d6088dba8fea
child 102 fda45bdfd68d
--- 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()
-