python示例库_python查库写库例子

#!/usr/bin/python3

importpymysqlimportsmtplibimportdatetimeimporttime

now_time=datetime.datetime.now()

yes_time= now_time + datetime.timedelta(days=-1)

select_sql= "select id,user,host,db,command,time,state,info from tb_run_long_sql limit 1"select_mysqlserver="192.168.1.113"select_username="root"select_password= "yeemiao1117"select_dbname="db_admin"insert_mysqlserver="192.168.1.113"insert_username="root"insert_password= "yeemiao1117"insert_dbname="db_admin"

defquery_data() :#打开数据库连接

db =pymysql.connect(select_mysqlserver,select_username, select_password, select_dbname)##print(sqltext)

#使用 cursor() 方法创建一个游标对象 cursor

cursor =db.cursor()try:

cursor.execute(select_sql)

result_data=cursor.fetchall()exceptException as e:print(e)

db.close()returnresult_datadefinsert_data (querydata) :

db=pymysql.connect(select_mysqlserver,select_username, select_password, select_dbname)

insert_sql="""insert into tb_run_long_sql_readonly(id,user,host,db,command,time,state,info) values (%s,%s,%s,%s,%s,%s,%s,%s)"""cursor=db.cursor()for row inquerydata:try:

l_id=row[0]

l_user="'" + row[1]+"'"l_host="'" + row[2]+"'"l_db="'"+ row[3] +"'"l_command="'" + row[4]+ "'"l_time=row[5]

l_state="'"+ row[6] + "'"l_info="'" + str(row[7]) + "'"insersql="insert into tb_run_long_sql_readonly ( id,user,host,db,command,time,state,info) values (%s,%s,%s,%s,%s,%s,%s)" %(l_id, l_user, l_host, l_db, l_command, l_time, l_state,l_info)print(insersql)##cursor.execute("insert into tb_run_long_sql_readonly(id,user,host,db,command,time,state,info) values (%s,%s,%s,%s,%s,%s,%s,%s)" % (l_id,l_user,l_host,l_db,l_command,l_time,l_state,l_info))

exceptException as e:print(e)

db.commit()

db.closeif __name__ == '__main__':

querydata=query_data()

insert_data(querydata)