执行目的:
数据表中需添加20条相同数据(碎片),模拟用户获得20个碎片兑换商品的场景
代码段展示:
# coding=UTF-8
import mysql.connector
running = True
userid = 10001512
#连接数据库
config = {'host':'47.98.209.00',
'user':'newtest',
'password':'123456',
'port':'3306',
'database':'bounty',
'charset' : 'utf8'
}
#检查数据库连接状态
try:
cnn=mysql.connector.connect(**config)
print('数据库连接成功')
except mysql.connector.Error as e:
print("数据库连接失败",str(e))
#数据表格式化
cursor = cnn.cursor(buffered=True)
try:
sql_clear = cursor.execute("delete from fragment where userid = %s and status = 2" %userid) #引入变量进行sql拼接
cnn.commit()
print('数据格式化成功')
except mysql.connector.errors as q:
print('格式