<gh_stars>0
sql_1 = """INSERT INTO `pt_exam`.`user_order` (`id`, `exam_id`, `user_id`, `order_number`, `pre_pay_number`, `entry_fee`, `actual_pay_fee`, `status`, `pay_url`, `pay_time`, `create_time`) VALUES (NULL, {exam_id}, {user_id}, 'zsyl20210811103413909170a3{user_id}{exam_id}', NULL, 1, 1, 1, 'weixin://wxpay/bizpayurl?pr=hDqke8nzz', '2021-08-11 12:00:00.000000', '2021-08-11 12:00:00');"""
sql_2 = """INSERT INTO `pt_exam`.`user_exam` (`id`, `exam_id`, `user_id`, `room_id`, `step`, `id_photo_url`, `ticket_no`, `ticket_url`, `level`, `flag`, `certificate_url`, `certificate_no`, `create_time`, `resit_flag`) VALUES (null, {exam_id}, {user_id}, NULL, 1, NULL, NULL, NULL, NULL, 0, NULL, NULL, '2021-08-11 12:00:00', 0);"""
# 配置
exam_id = 34
# 初级认证的人
# user_ids = [873, 1152, 1153, 1154, 1155, 1156, 1157, 1159, 264, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 535, 1180, 925, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 543, 297, 1194, 171, 1196, 1197, 1198, 1201, 1202, 1203, 1205, 1206, 1181, 1207, 1208, 574, 459, 1160, 849, 478, 873, 1005, 622, 249, 762, 252, 1149, 1150, 1151]
# 中级认证
# user_ids = [480, 292, 581, 305, 819, 189, 537, 475, 348, 349, 1196, 1183, 1005]
user_ids = [1211]
# 陈默 1196
# 周源苠 1183
# 廖敏 1208
# 刁青青 1005
# 冯丹 1207

user_ids = list(set(user_ids))
# user_order表
for user_id in user_ids:
    print(sql_1.format(exam_id=exam_id, user_id=user_id))
# user_exam表
for user_id in user_ids:
    print(sql_2.format(exam_id=exam_id, user_id=user_id))
# print(user_ids)

sql_1 = """INSERT INTO `pt_exam`.`user_order` (`id`, `exam_id`, `user_id`, `order_number`, `pre_pay_number`, `entry_fee`, `actual_pay_fee`, `status`, `pay_url`, `pay_time`, `create_time`) VALUES (NULL, {exam_id}, {user_id}, 'zsyl20210811103413909170a3{user_id}{exam_id}', NULL, 1, 1, 1, 'weixin://wxpay/bizpayurl?pr=hDqke8nzz', '2021-08-11 12:00:00.000000', '2021-08-11 12:00:00');"""
sql_2 = """INSERT INTO `pt_exam`.`user_exam` (`id`, `exam_id`, `user_id`, `room_id`, `step`, `id_photo_url`, `ticket_no`, `ticket_url`, `level`, `flag`, `certificate_url`, `certificate_no`, `create_time`, `resit_flag`) VALUES (null, {exam_id}, {user_id}, NULL, 1, NULL, NULL, NULL, NULL, 0, NULL, NULL, '2021-08-11 12:00:00', 0);"""
# 配置
exam_id = 34
# 初级认证的人
# user_ids = [873, 1152, 1153, 1154, 1155, 1156, 1157, 1159, 264, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 535, 1180, 925, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 543, 297, 1194, 171, 1196, 1197, 1198, 1201, 1202, 1203, 1205, 1206, 1181, 1207, 1208, 574, 459, 1160, 849, 478, 873, 1005, 622, 249, 762, 252, 1149, 1150, 1151]
# 中级认证
# user_ids = [480, 292, 581, 305, 819, 189, 537, 475, 348, 349, 1196, 1183, 1005]
user_ids = [1211]
# 陈默 1196
# 周源苠 1183
# 廖敏 1208
# 刁青青 1005
# 冯丹 1207

user_ids = list(set(user_ids))
# user_order表
for user_id in user_ids:
    print(sql_1.format(exam_id=exam_id, user_id=user_id))
# user_exam表
for user_id in user_ids:
    print(sql_2.format(exam_id=exam_id, user_id=user_id))
# print(user_ids)
INSERT INTO `pt_exam`.`user_order` (`id`, `exam_id`, `user_id`, `order_number`, `pre_pay_number`, `entry_fee`, `actual_pay_fee`, `status`, `pay_url`, `pay_time`, `create_time`) VALUES (NULL, {exam_id}, {user_id}, 'zsyl20210811103413909170a3{user_id}{exam_id}', NULL, 1, 1, 1, 'weixin://wxpay/bizpayurl?pr=hDqke8nzz', '2021-08-11 12:00:00.000000', '2021-08-11 12:00:00'); INSERT INTO `pt_exam`.`user_exam` (`id`, `exam_id`, `user_id`, `room_id`, `step`, `id_photo_url`, `ticket_no`, `ticket_url`, `level`, `flag`, `certificate_url`, `certificate_no`, `create_time`, `resit_flag`) VALUES (null, {exam_id}, {user_id}, NULL, 1, NULL, NULL, NULL, NULL, 0, NULL, NULL, '2021-08-11 12:00:00', 0); # 配置 # 初级认证的人 # user_ids = [873, 1152, 1153, 1154, 1155, 1156, 1157, 1159, 264, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 535, 1180, 925, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 543, 297, 1194, 171, 1196, 1197, 1198, 1201, 1202, 1203, 1205, 1206, 1181, 1207, 1208, 574, 459, 1160, 849, 478, 873, 1005, 622, 249, 762, 252, 1149, 1150, 1151] # 中级认证 # user_ids = [480, 292, 581, 305, 819, 189, 537, 475, 348, 349, 1196, 1183, 1005] # 陈默 1196 # 周源苠 1183 # 廖敏 1208 # 刁青青 1005 # 冯丹 1207 # user_order表 # user_exam表 # print(user_ids)