form = cgi.FieldStorage() """ Need connect. | separated string Sequence is important user|password|host|database and sql """ try: # always connect connect = form["connect"].value sql = form["sql"].value # set up parameters p = dbutils.prepareSelectParameters(connect, sql) if len(p) > 0: res = dbutils.doProcess(p, "data/sqlselect.xml") if res.startswith("ok"): # return the produced file print "Location: data/sqlselect.xml\n" else: print "Content-type: text/plain; charset=utf-8 \n" print res else: print "Content-type: text/plain; charset=utf-8 \n" print "error bad parameter list in connect" except: print "Content-type: text/plain; charset=utf-8 \n" res = sys.exc_info() print "error " + str(res[1])
using mysqldump in a subprocess as implemented in utils """ form=cgi.FieldStorage() """ Need connect. | separated string Sequence is important: user|password|host|database|table """ try: # always connect connect=form['connect'].value # set up parameters p=dbutils.prepareDumpParameters(connect) if len(p) >0: res=dbutils.doProcess(p,'data/dump.xml') if res.startswith('ok'): # return the produced file print "Location: data/dump.xml\n" else: print 'Content-type: text/plain; charset=utf-8 \n' print res else: print 'Content-type: text/plain; charset=utf-8 \n' print 'error bad parameter list in connect' except: print 'Content-type: text/plain; charset=utf-8 \n' res=sys.exc_info() print 'error '+str(res[1])