Mercurial > sqlpython
diff sqlpyPlus.py @ 62:833e9d251da3
add head
author | catherine@cordelia |
---|---|
date | Thu, 03 Apr 2008 11:42:40 -0400 |
parents | 1eefe17b3630 |
children | 16618ff91c63 |
line wrap: on
line diff
--- a/sqlpyPlus.py Thu Apr 03 11:21:26 2008 -0400 +++ b/sqlpyPlus.py Thu Apr 03 11:42:40 2008 -0400 @@ -726,6 +726,20 @@ def do__dir_schemas(self, arg): self.do_select("""owner, count(*) AS objects FROM all_objects GROUP BY owner ORDER BY owner""") + def do_head(self, arg): + nrows = 10 + args = arg.split() + if len(args) > 1: + for a in args: + if a[0] == '-': + try: + nrows = int(a[1:]) + args.remove(a) + except: + pass + arg = ' '.join(args) + self.do_select('* from %s;%d' % (arg, nrows)) + def do_print(self, arg): 'print VARNAME: Show current value of bind variable VARNAME.' if arg: