jmeter生成测试数据python脚本

#CREATE TABLE usertesting (id int ,username CHAR(30),password CHAR(30))创建usertesting表格
#f读取保存此路径的txt文件，如果该路径下该文件不存在则创建新的
f = ‘E:/jmeter_no_gui/user.txt’
#导入mysql模块
import pymysql
#导入时间模块
import time
#连接mysql数据库
db = pymysql.connect(
host = “192.168.3.169”,
port = 3306,
user = “root”,
password = “root”,
db = “mammoworks_testing”)
#cursor当前的程序到数据之间连接管道
cursor = db.cursor()
organizationid = 10
usertype = 1

123456加密后的password

password = ‘XQKS4oRXJFvVfj4wL4Mmkg==’
createtime = time.strftime(’%Y-%m-%d %H:%M:%S’,time.localtime(time.time()))
updatetime = time.strftime(’%Y-%m-%d %H:%M:%S’,time.localtime(time.time()))
#要执行的sql语句，%s表示传入的值以字符串形式传入，与数据库字段类型无关
sql = “insert into user (userid,username,password,mobile,createtime,updatetime,organizationid,usertype)VALUES (%s,%s,%s,%s,%s,%s,%s,%s)”
#写入方式打开f文件
with open(f, ‘w’) as write_user:
username = ‘name1’
userid = 1357217338980663
i = 1
mobile = 1357217338
#i生成5000条数据
print(‘正在写入数据。。。\n’)
while i <= 500:
username = “name” + str(i)
userid = userid + i
mobile = mobile + i
#f文件中写入组合后的username和password，writelines只接受一个值，所以多个值需要组成一个列表进行写入
write_user.writelines([str(mobile),’,’,‘123456’,’\n’])
#执行sql,传值
cursor.execute(sql,(userid,username,password,mobile,createtime,updatetime,organizationid,usertype))
#提交事务
db.commit()
i = i + 1
print(‘写入完毕’)
#关闭游标
cursor.close()
#关闭数据库连接
db.close()