def exeProcedure(sql): #try: filename='./config/dbinfo.ini' dblist=connectDb.getConnectInfo(filename) dbconn=connectDb.connectDb(dblist[0]) cursor=connectDb.getCursor(dbconn) connectDb.executeSQL(cursor,sql) Res=connectDb.getSQLrst(cursor) connectDb.closeCursor(cursor) connectDb.closeConnect(dbconn) print Res return Res
def execute_query(sqllist): try: filename='./config/dbinfo.ini' dblist=connectDb.getConnectInfo(filename) dbconn=connectDb.connectDb(dblist[0]) cursor=connectDb.getCursor(dbconn) for sql in sqllist: connectDb.executeSQL(cursor,sql) result=connectDb.getSQLrst(cursor) connectDb.closeCursor(cursor) connectDb.closeConnect(dbconn) query_result=result[0][0] #print query_result,type(query_result) return query_result except Exception,e: query_err='%s %s' % (datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'),'execute_query falied') with open(r'./log/error.log','a') as error_log: print >> error_log,('%s %s' %(query_err,e)) return query_err
def get_dbInfo(sql): try: filename='./config/dbinfo.ini' dblist=connectDb.getConnectInfo(filename) dbconn=connectDb.connectDb(dblist[0]) cursor=connectDb.getCursor(dbconn) connectDb.executeSQL(cursor,sql) result=connectDb.getSQLrst(cursor) connectDb.closeCursor(cursor) connectDb.closeConnect(dbconn) infodict={} for res in result: if infodict.has_key(res[0]): infodict[res[0]].append(res[1:]) else: infodict[res[0]]=[res[1:]] #print infodict return infodict except Exception,e: geterr='%s %s' % (datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'),'execute get_dbInfo falied') with open(r'./log/error.log','a') as error_log: print >> error_log,('%s %s' %(geterr,e))
def getSqlRes(sql): try: filename='./config/dbinfo.ini' dblist=connectDb.getConnectInfo(filename) dbconn=connectDb.connectDb(dblist[0]) cursor=connectDb.getCursor(dbconn) connectDb.executeSQL(cursor,sql) cols=[] for col in cursor.description: cols.append(col[0]) #print cols result=connectDb.getSQLrst(cursor) reslist=[] for res in result: reslist.append(list(res)) connectDb.closeCursor(cursor) connectDb.closeConnect(dbconn) #print (cols,reslist) return (cols,reslist) except Exception,e: getReserr='%s %s' % (datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'),'execute getSqlRes falied') with open(r'./log/error.log','a') as error_log: print >> error_log,('%s %s' %(getReserr,e))
def execute_commitsql(sqllist): try: reslist=[] filename='./config/dbinfo.ini' dblist=connectDb.getConnectInfo(filename) dbconn=connectDb.connectDb(dblist[0]) cursor=connectDb.getCursor(dbconn) for sql in sqllist: connectDb.executeSQL(cursor,sql) rowsaffected = cursor.rowcount reslist.append(rowsaffected) connectDb.sqlcommit(dbconn) update_result=sum(reslist) #print reslist #print update_result,type(update_result) connectDb.closeCursor(cursor) connectDb.closeConnect(dbconn) return update_result except Exception,e: update_err='%s %s' % (datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'),'execute_commitsql falied') with open(r'./log/error.log','a') as error_log: print >> error_log,('%s %s' %(update_err,e)) return update_err
def dealBusiness(nb): dblist = connectDb.getConnectInfo("dbConnect") if type(dblist) is str: return dblist print str(nb) + "线程开始:" + datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') dbconn = connectDb.connectDb(dblist[0]) if type(dbconn) is str: print dbconn return dbconn cursor = connectDb.getCursor(dbconn) if type(cursor) is str: connectDb.closeConnect(dbconn) print cursor return cursor time.sleep(nb) print str(nb) + "线程程序处理结束:" + datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') connectDb.sqlcommit(dbconn) clsCor = connectDb.closeCursor(cursor) clsCnt = connectDb.closeConnect(dbconn) print "关闭连接:" + datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S') if type(clsCor) is str: print clsCor if type(clsCnt) is str: print clsCnt
def getSqlData(sql): try: filename='./config/billdbinfo.ini' dblist=connectDb.getConnectInfo(filename) dbconn=connectDb.connectDb(dblist[0]) cursor=connectDb.getCursor(dbconn) connectDb.executeSQL(cursor,sql) result=connectDb.getSQLrst(cursor) return result except Exception,e: getDataerr='%s %s' % (datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'),'execute getSqlData falied') with open(r'./log/error.log','a') as error_log: print >> error_log,('%s %s' %(getDataerr,e)) finally: connectDb.closeCursor(cursor) connectDb.closeConnect(dbconn) def writeData(): try: sql=getSql('./config/billsql.txt')[0] Total,ErrRe,Err,Errrate=getSqlData(sql)[0] txt="""在 %s 至 %s 该段时间内,话单总数为:%s,回收错单数为:%s,错单总数为:%s,错单率为:%s 。""" % (yestoday,today,Total,ErrRe,Err,Errrate) with open(r'./config/data.txt','w') as data: print >> data,('%s' %(txt)) except Exception,e: getwritererr='%s %s' % (datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'),'execute writerData falied') with open(r'./log/error.log','a') as error_log: print >> error_log,('%s %s' %(getwritererr,e))