python 自动化随笔

python 自动化测试数据库操作

-- coding:utf-8 -- ＃

import pymysql
loan_id=[291582664581623808,291582659888197632]
plan_date=1548950400000
account_id = [154530014520600110]
order_id =[298092531452452864]
term_num=1
def loan():
con_date = pymysql.connect(host=‘XXXXX’, user=‘XXXXX’, passwd=‘XXXXX’, port=33306, db=‘XXXXX’, charset=‘utf8’)
cursor = con_date.cursor()
print(loan_id)
for i in loan_id:
ret = i%11
#print(i,ret)
sql='update loan_repayment_%s set plan_date = %s where term_num=%s and loan_id = %s ’ %(ret ,plan_date,term_num,i)
cursor.execute(sql)
con_date.commit()
print(sql)
con_date.close()
def order():
con_date = pymysql.connect(host=‘XXXXX’, user=‘XXXXX’, passwd=‘XXXXX’, port=33306, db=‘XXXXX’, charset=‘utf8’)
cursor = con_date.cursor()
for i in order_id:
sql='update order_repayment set plan_date = %s where term_num=%s and order_id = %s ’ %(plan_date,term_num,i)
cursor.execute(sql)
con_date.commit()
print(sql)
con_date.close()
def fee():
con_date =pymysql.connect(host=‘XXXXX’, user=‘XXXXX’, passwd=‘XXXXX’, port=33306, db=‘XXXXX’, charset=‘utf8’)
cursor = con_date.cursor()
for i in loan_id:
sql='update fee_repayment set plan_date = %s where term_num=%s and loan_id = %s ’ %(plan_date,term_num,i)
cursor.execute(sql)
con_date.commit()
print(sql)
con_date.close()
def credit():
con_date = pymysql.connect(host=‘XXXXX’, user=‘XXXXX’, passwd=‘XXXXX’, port=33306, db=‘XXXXX’, charset=‘utf8’)
cursor = con_date.cursor()
for i in loan_id:
for j in account_id:
ret = j%50
print(i,ret)
sql='update credit_repayment_%s set plan_date = %s where term_num=%s and loan_id = %s ’ %(ret ,plan_date,term_num,i)
cursor.execute(sql)
con_date.commit()
print(sql)
con_date.close()
def interest():
con_date = pymysql.connect(host=‘XXXXX’, user=‘XXXXX’, passwd=‘XXXXX’, port=33306, db=‘XXXXX’, charset=‘utf8’)
cursor = con_date.cursor()
for i in order_id:
sql='update interest_repayment set plan_date = %s where term_num=%s and order_record_id = %s ’ %(plan_date,term_num,i)
cursor.execute(sql)
con_date.commit()
print(sql)
con_date.close()
if name == ‘main’:
loan()
credit()
fee()
order()
interest()