from pymysql import *
import random
import logging
from time import sleep
logging.basicConfig(level=logging.INFO,
filename="./jl.log",
filemode='a',
format='%(asctime)s-%(filename)s[line:%(lineno)d]-%(levelname)s: %(message)s')
logging.info('插入数据开始')
first = {
"1": 1,
"2": 2,
"3": 3,
"4": 4,
"5": 5,
"6": 6,
"7": 7,
"8": 8,
"9": 9
}
#
conn = connect(host="127.0.0.1", port=3306, database="shujuku", user="root", password="12345678", charset="utf8")
cur = conn.cursor()
for i in range(1000):
sleep(1)
num = random.randint(1,9)
if num == 9:
jl = 9
else:
if first[str(num)] == 0:
jl = 9
else:
first[str(num)] -= 1
jl = num
sql = "insert into douqi.luck_record( actid, hid, uid, rank) values ( 90, 391, 1003135, {});".format(jl)
cur.execute(sql)
conn.commit()
logging.info('恭喜你中{}等奖'.format(jl))
cur.close()
conn.close()
python logging,数据库的简单使用
最新推荐文章于 2024-05-15 18:00:00 发布