Python 代码：从数组中随机选取唯一 ID 并写入数据库

import requests import json import re import pymysql import random

db = pymysql.connect(host='103.214.173.233', port=3306, user='caoliu', passwd='xX300400', db='caoliu') cursor = db.cursor() pattern = re.compile(r'_blank' id='t(.*?)'>') ids = pattern.findall(html)

while True: random_id = random.choice(ids) query = 'SELECT id FROM huifu WHERE id = %s' cursor.execute(query, random_id) result = cursor.fetchone() if not result: print('Unique ID:', random_id) insert_query = 'INSERT INTO huifu (id) VALUES (%s)' cursor.execute(insert_query, random_id) db.commit() break

db.close()