import redis import pymysql import pickle import time
与MySQL数据库建立连接,并获取数据:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
defload_test_from_db(): con = pymysql.connect( host='localhost', port=3306, user='root', password='xxxx' database='s_test', charset='utf8' ) with con.cursor() as cursor: cursor.execute('select name, age from tb_test') test = cursor.fetchall() con.close() return test