#!/usr/bin/python3
import pymysql

db = pymysql.connect(host="222.73.129.15", port=31306, user="root", passwd="kepaiteng!QAZ", db="eq", charset="utf8")
cursor  = db.cursor()
sqlname =input("请输入sqlname:")
sqlstr =open("../sql/%s.sql"%(sqlname),"r",encoding="utf-8").read()
sql ="update apisql set sqlstr =%s where sqlname =%s" 
err=cursor.execute(sql,(sqlstr,sqlname))
print(err)
db.commit()
db.rollback()