Mercurial > sqlpython
changeset 87:2de82dd6eba2
back to dellzilla
| author | catherine@cordelia |
|---|---|
| date | Tue, 20 May 2008 10:08:14 -0400 |
| parents | ca5d615d8207 |
| children | d3da34473a8e |
| files | sqlpyPlus.py |
| diffstat | 1 files changed, 7 insertions(+), 8 deletions(-) [+] |
line wrap: on
line diff
--- a/sqlpyPlus.py Mon May 19 17:15:31 2008 -0400 +++ b/sqlpyPlus.py Tue May 20 10:08:14 2008 -0400 @@ -573,12 +573,11 @@ return object_type, owner, object_name = self.resolve(arg.strip(self.terminator).upper()) if not object_type: - if opts.all: - self.do_select("""object_name, object_type%s FROM %s_objects - WHERE object_type IN ('TABLE','VIEW','INDEX') - AND object_name LIKE '%%%s%%' - ORDER BY object_name""" % - (which_view[0], which_view[1], arg.upper()) ) + self.do_select("""object_name, object_type%s FROM %s_objects + WHERE object_type IN ('TABLE','VIEW','INDEX') + AND object_name LIKE '%%%s%%' + ORDER BY object_name""" % + (which_view[0], which_view[1], arg.upper()) ) return self.stdout.write("%s %s.%s\n" % (object_type, owner, object_name)) descQ = descQueries.get(object_type) @@ -858,8 +857,8 @@ def do_declare(self, arg): self.anon_plsql('declare ' + arg) - def do_create(self, arg): - self.anon_plsql('create ' + arg) + #def do_create(self, arg): + # self.anon_plsql('create ' + arg) @options([make_option('-l', '--long', action='store_true', help='long descriptions')]) def do_ls(self, arg, opts):