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))
