Mercurial > sqlpython

changeset 129:d8661065fb77

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added -c option to find
author catherine@localhost
date Fri, 15 Aug 2008 09:45:48 -0400
parents c5e6e475cdbe
children 40bbe808e98a
files sqlpyPlus.py
diffstat 1 files changed, 11 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/sqlpyPlus.py	Tue Aug 12 13:58:13 2008 -0400
+++ b/sqlpyPlus.py	Fri Aug 15 09:45:48 2008 -0400
@@ -571,24 +571,29 @@
                 except cx_Oracle.DatabaseError:
                     pass
 
-    @options([make_option('-i', '--insensitive', action='store_true', help='case-insensitive search'),
+    @options([make_option('-a','--all',action='store_true', help='Find in all schemas (not just my own)'),
+              make_option('-i', '--insensitive', action='store_true', help='case-insensitive search'),
               make_option('-c', '--col', action='store_true', help='find column'),
-              make_option('-t', '--table', action='store_true', help='find table')])                
+              make_option('-t', '--table', action='store_true', help='find table')])                    
     def do_find(self, arg, opts):
         """Finds argument in source code or (with -c) in column definitions."""
 
-        arg = self.parsed(arg).unterminated.upper()       
+        arg = self.parsed(arg).unterminated.upper()     
+        
         if opts.col:
-            self.do_select("owner, table_name, column_name from all_tab_columns where column_name like '%%%s%%'" % (arg))
+            sql = "owner, table_name, column_name from all_tab_columns where column_name like '%%%s%%'" % (arg)
         elif opts.table:
-            self.do_select("owner, table_name from all_tables where table_name like '%%%s%%'" % (arg))            
+            sql = "owner, table_name from all_tables where table_name like '%%%s%%'" % (arg)
         else:
             if opts.insensitive:
                 searchfor = "LOWER(text)"
                 arg = arg.lower()
             else:
                 searchfor = "text"
-            self.do_select("* from all_source where %s like '%%%s%%'" % (searchfor, arg))
+            sql = "* from all_source where %s like '%%%s%%'" % (searchfor, arg)
+        if not opts.all:
+            sql = '%s and owner = user' % (sql)
+        self.do_select(sql)
 
     @options([make_option('-a','--all',action='store_true',
                           help='Describe all objects (not just my own)')])