Mercurial > sqlpython

comparison mysqlpy.py @ 1:8fa146b9a2d7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
reworking multiline
author devlinjs@FA7CZA6N1254998.wrightpatterson.afmc.ds.af.mil
date Fri, 30 Nov 2007 16:44:26 -0500
parents 9c87fa772ec1
children 23c3a58d7804
comparison
equal deleted inserted replaced
0:9c87fa772ec1 1:8fa146b9a2d7
136 print '\n%d rows selected.\n' % self.rc 136 print '\n%d rows selected.\n' % self.rc
137 else: 137 else:
138 print '\nSelected Max Num rows (%d)' % self.rc 138 print '\nSelected Max Num rows (%d)' % self.rc
139 except Exception, e: 139 except Exception, e:
140 print e 140 print e
141
141 142
142 def do_sql(self,args): 143 def do_sql(self,args):
143 '''prints sql statement give the sql_id (Oracle 10gR2)''' 144 '''prints sql statement give the sql_id (Oracle 10gR2)'''
144 self.query = "select inst_id, sql_fulltext from gv$sqlstats where sql_id='"+args+"'" 145 self.query = "select inst_id, sql_fulltext from gv$sqlstats where sql_id='"+args+"'"
145 try: 146 try: