312 lines
26 KiB
Python
312 lines
26 KiB
Python
import sqlite3
|
||
import os
|
||
import random
|
||
|
||
# 预设的随机拉黑原因列表
|
||
blacklist_reasons = [
|
||
"发布违规信息", "恶意评论", "引战行为", "刷屏广告", "侮辱谩骂",
|
||
"不当言论", "恶意骚扰", "屡次违规", "发布垃圾信息", "行为异常",
|
||
"发送广告", "影响直播秩序", "违规发言", "恶意带节奏", "不受欢迎用户",
|
||
"违反社群规范", "重复发言", "恶意骚扰主播", "散布谣言", "虚假宣传",
|
||
"不良内容", "干扰直播进程", "挑衅滋事", "煽动情绪", "恶意举报",
|
||
"发送违禁内容", "恶意刷粉", "侵犯隐私", "冒充他人", "传播负面信息",
|
||
"机器人行为", "违反平台规定", "频繁发送链接", "散布虚假信息", "恶意引流",
|
||
"发送违规表情", "传播不良价值观", "骚扰其他用户", "频繁发布无关内容",
|
||
"违反直播间规则", "发布诈骗信息", "低俗内容"
|
||
]
|
||
|
||
run_path = '.'
|
||
blacklist_records_path = os.path.join(run_path, 'blacklist_records.db')
|
||
conn = sqlite3.connect(blacklist_records_path)
|
||
c = conn.cursor()
|
||
|
||
# 生成带随机原因的插入数据
|
||
insert_values = []
|
||
for record in [
|
||
# 保留原数据结构，但替换blacklist_reason为随机选择
|
||
{"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
"user_sid": "MS4wLjABAAAAFLzCVF0kqxl5XpZtIFUXWZvk4Fdtpgtl3UGgG7ujVcQW_rkGegltjJltkiDH6R0L",
|
||
"user_douyin_id": "61605619147", "user_nickname": "蛋仔拉满",
|
||
"user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_ac7c9f083d3a416cb8b756b5f576bd1d.jpeg?from=3067671334",
|
||
"blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 14:41:48"},
|
||
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAEFDDAUfe0o6guHz4D8fw3g_lToWX4QIPlV5g4QTfFCc", "user_douyin_id": "326481733",
|
||
# "user_nickname": "akazhi",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/mosaic-legacy_1cad800080ddc92b9fd4f.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAsZye7hOatrYIW5Ao1cY-9ijofVGG_m21TnADZ_akVMw", "user_douyin_id": "Ts19970815",
|
||
# "user_nickname": "𝘿𝙚𝙟𝙤𝙪𝙣𝙩𝙚",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_59773e8d32c0efc7144297d5d797b03e.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAFYgc_-8UY_iRF3WnndpNsCYnocsRU4G7FXF9LVODHKQ", "user_douyin_id": "suibozhuliu348",
|
||
# "user_nickname": "錒",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813c001_o4OAEKuBAGI2dAAAeLaEeL6l9BEvbIOg7FFfVA.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAUkd5bdN_-mDsUhFKAz2B3YLODVOQwO2WbgJS07iu5k_gakS8OpYSgqdMjnpX8kpJ",
|
||
# "user_douyin_id": "Tdtuyh", "user_nickname": "起",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_155c4d38bf82c2821f01485b8683447c.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAArH_qZoySs59sAtu7Z1Edj3GumT0NDr3EFVlXNXqzA5Y", "user_douyin_id": "858720991",
|
||
# "user_nickname": "青山独归远",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_50ed5404ba8bd703748da3f3c4858edf.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAg1HhaKKXWYt99Xw6QimzqKrG9cPGa2odpzM6xGNH_N8", "user_douyin_id": "dushuren6666",
|
||
# "user_nickname": "读书人",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_c2733971d6170640dc23f13bbed92026.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAob-c3SvILPx-BJRm-e1gFuk8UrKJMIkQEm5VcQTB8jnYlNcSP6ehwimqnTM2bpBA",
|
||
# "user_douyin_id": "rycbsygrdyx", "user_nickname": "墨竹.",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_69e4a71ebafc4cfdbeab0a785e188221.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAKAXXUiZCGYXWrgwX-r9NzWSAZg6q2Fnk-6I2BS4RkowY26sHBQ-qRtVEG3We7Rr_",
|
||
# "user_douyin_id": "zxcf412", "user_nickname": "easy enough",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_a5fe1bd872827a4165ebbeba99129eb2.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAA1Pp3DEeyoPMazS1CpADHhCs_FnuG2esKEDqdqE110YqJyr9_wyoNcEZ_BHSQQn7s",
|
||
# "user_douyin_id": "94489529041", "user_nickname": "pai大星",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813c001_ocArfEIgDHAFiEQCEk9kgmfaASDCACAQxAQmby.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:40:59"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAxJMQEOQr-QyOPQwYY3LCfnWdb0i4rmdPWTDfdpVLbECTboK7p2Qmlqea_xD_tG-o",
|
||
# "user_douyin_id": "dy15dmbsvih3", "user_nickname": "wish",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/mosaic-legacy_3104200041754621be7c0.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAOA0Foi70hZvrpysfn0Ocpk1pLFsNwx9RW9OfEnuXFKE", "user_douyin_id": "30159099",
|
||
# "user_nickname": "2pac.",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_fffa5ed6d444d655e9ba65e5fcbfc9e7.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAfqc_7OgyuSaEfsrV_z75FwWaTxlkp1Y5DssZVzPXisM", "user_douyin_id": "833396625",
|
||
# "user_nickname": "宫保鸡丁",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_df299e3f61094bfe8c2cb90554b983ab.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAADKe28UiPGLyaWRWkocxd3CyH1ZxNrBdG02IltkjJiQr70H1EUZVr6r1kQ1bc2nWV",
|
||
# "user_douyin_id": "getintoflow", "user_nickname": "Jasper",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_a14f18955fddb487c0d2909b15a0d7d2.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAt_2rZzvJhnnts4uoWK-x6vdZXMm-acLfUS8UvDBwf7k", "user_douyin_id": "2084119884",
|
||
# "user_nickname": "AX",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_a01eb67324b571838dc0f758cdd852fe.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAA_s6gM7DSbVDgXQFoCI8OK4eur18vElaXiBRhgM6Uig4", "user_douyin_id": "a2772454104",
|
||
# "user_nickname": "一只小阿精",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/mosaic-legacy_2de1200001ef43379e352.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAA_cT_Y7JBQGgHFDo_LLAfSUImG2CFZttbxjIZeYM_xjE", "user_douyin_id": "70542249",
|
||
# "user_nickname": "Anita Hailey",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_okBezhgHEmyALiAaICWAANfAoqddyAt2F9AlTU.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAAcfMOTIRsKLRCcYBBEDq7O2bvFX4F8eCsBJYnzPSscaWvnJMqgZ7bNGF-X5eViaN",
|
||
# "user_douyin_id": "73001096170", "user_nickname": "归途",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_bd500a7ec9064885af1c244dc031ac94.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAbickQzO2MK4UXSOyScq5--D907ZefqzZ1B8_YVBCd4iFvS0FPU8X3dZBDJrZxCxn",
|
||
# "user_douyin_id": "53427299765", "user_nickname": "亲秋",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_oIF3IDEDAcfAN8FAGnIpAWEQ5AFR79AtFICmfg.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAPbHmNvh85J1FYX-26WA-f8WMiGvBaK6AYlY-dsZEuW4", "user_douyin_id": "FT_668",
|
||
# "user_nickname": "668",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_a135f35394b5483c67a9e83f469f4efb.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAtjgkcjubYo-J3Q5S6ELEnqPEodTC9Oho8QE32GvVXA4", "user_douyin_id": "1130008862",
|
||
# "user_nickname": "猿辅导胡vV钾",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_o4AASCDIEAglQxMbfz8NwDAvex8KGAAvnCM9Ay.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAFwaGssnbfZBvV4EE0eTTAeRibe_PuL1d8cfSpCXG-8c", "user_douyin_id": "102091723",
|
||
# "user_nickname": "扎亚Zaya",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_a32fb1e2ac46f4d16785fc25754f5c62.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAASvQKDPthZbuBgxEnTs6LxiYuEyKa_Rr5QwrcqqBaOVac0z7rL7xMUTv_3fK2JJ70",
|
||
# "user_douyin_id": "32859256605", "user_nickname": "下次见.",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_8893935ad742f8a1119d173c1467cb1a.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAK3BW_aMZqcbGZ_AeXlpWcxOGSs9R5Z9xRJ2q2rhBqRo", "user_douyin_id": "cr531924588",
|
||
# "user_nickname": "南风知我意.",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813c001_owAqAemTGEGfLAfHVnIefzIYTQQQ4KoAZosLMA.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAXhhZh4VWixJ1N6aJc_v_dYw13HziDSmDCwD18F4EQm0", "user_douyin_id": "201020636",
|
||
# "user_nickname": "芥末",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/mosaic-legacy_5532001c3a74b29114e1.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAEj0ZxqatvLocBi64QOy9FKI-31QIkrzcdJdmb_JSvYnhej85S3ATAfJQOCb50wOF",
|
||
# "user_douyin_id": "82244770003", "user_nickname": "瓦瓦瓦",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813c000-ce_oQhPizA7SEBIPMnZQADSKi702A08ciEZARoAB.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAUAneWOff4oUbtETKVcz-YuA_3Ww94FEwrciOrMksEJXqrWHtekh8a4rvxbBX8V_Y",
|
||
# "user_douyin_id": "19930705kk", "user_nickname": "芝麻酱馅",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/mosaic-legacy_31690000d3e5750058036.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAjXGmr8EdkkP0Kp7WmGdT3t_BIyuG5H2OFe6smSPPBEs", "user_douyin_id": "wodexinhaoleng02",
|
||
# "user_nickname": "最冷一天",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_41ffd49b9477869c4479bfb4a2c10967.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAbmCF2MmK6eXHIrPx2wMDiaBZSL3KUToolcGXs3d1mVs", "user_douyin_id": "honghong513444",
|
||
# "user_nickname": "四川第一饭桶",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_oQEAmm9AZCpAsg9fiuIABFEA3nDrjZALhfySdD.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAA8SDM414iOCPWRDll4HUATAnP6jtevNY9Wr24WcwSv8U", "user_douyin_id": "837246048",
|
||
# "user_nickname": "Hujin777",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_372241f85f6450bcfb8eb7a8d4025ce9.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAtZ_GYBChg7xbhs4K0Zslr0X423lQfi7WzfUy-3cOZPo", "user_douyin_id": "im2546",
|
||
# "user_nickname": "刀刀.",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_b39a62732f3c49e09b7ba770cdd82959.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAmRY615_50wSW2GTcqcCgfNlDEXNhebzX-17Yo9mCrYI", "user_douyin_id": "180715475",
|
||
# "user_nickname": "望着人群",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_46a48d77f92c3971c5f26816c0011388.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAGOi_hKyHWeAcpka-ebNkRKTrYMZ-GLrHueFuSIcXxK7oarByGSqIhmcHxP_WKO-2",
|
||
# "user_douyin_id": "OnlyOne13377", "user_nickname": "没有触角的蜗牛",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_56d8cd55ac894388b450f81b316c104f.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAA6XYGiDLFZMRVVZ4HoPXZm10GB4xBoTP_3GkRUlPCf5E", "user_douyin_id": "582731702",
|
||
# "user_nickname": "装B的最累",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813c001_1d2cf4a7cce54a7fa84778c8aa8684eb.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:00"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAGVHsdH8zCJNdkkxdA0s4ScgXdLzkIYETphtuAL8sxYTF0M8Ap9jqtFgYGPwZmKz7",
|
||
# "user_douyin_id": "qishilongjun", "user_nickname": "齐市龙军汽车音响改装",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_79b16746097147b8804bc2def1d6c009.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAA8FJV-dSOgsaVDleeIYkh0L6Ap-7GFuuzyWfAnF6RVTM", "user_douyin_id": "f2244872635",
|
||
# "user_nickname": "苏打椰子柠檬汁",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/mosaic-legacy_317a700062c770ad6f2d3.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAA1BNtby29sB-sXs6e3xaczN6MGGp9Cwk4R06sn5VO_V0aI8AMGeptaNrB4FHncDj7",
|
||
# "user_douyin_id": "2844158509ltc", "user_nickname": "不好玩",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_oMLffAwgjAWIC5lAIt8WB2tIIKGeQtjADegAIG.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAAKgT-m1lUuGa9SqdN0MeX44chJOANC53WbOsuWlzsEc", "user_douyin_id": "1110911495",
|
||
# "user_nickname": "Lancer",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_00be2e2d149149dbabbd810231e4670a.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAyQqbyfLf0K_eOMY7lERDTeekbPxacdrViWagQvIeDB4", "user_douyin_id": "32100135",
|
||
# "user_nickname": "_wIther",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_15900afd37faae8726848d0d4cca1241.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAqkMcPpS25EeRdfs2F8xPyeRihMXjCX2Q2VIcE5pJcIQHvctI1kAhFasv1KdOllYB",
|
||
# "user_douyin_id": "h1104403857", "user_nickname": "今天开心一点🦐",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_f193829bd7e64e26804371ff0729072e.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAgr_6LP4z_VUulEJSr_yFsvDghf-ctOVDDLZjTELaa1w", "user_douyin_id": "1365546182",
|
||
# "user_nickname": "向星花开",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813c001_oQEQgMDImtAUAmmGVeq8AfDAdnLvbmAG9AClAC.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAApL_uQWPXlkeg_VwuIMscc5XvkXiBAUjJogliBJNfEUg", "user_douyin_id": "289507287",
|
||
# "user_nickname": "凉介-",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_3108bf9cf2054ee893795bb61cd72901.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAA_aBhKoxhPu2fXiDA40EKVD83IYPeQEvfu1ZDDfrRd-c-C2PXozhp8avKsmGgocxv",
|
||
# "user_douyin_id": "95834676502", "user_nickname": "陈平安，。，",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_okzA7ANhYgqHy7uDbICweSAHAUEbfqAAzFBsmV.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAAkXnBm-LdHdNiEI7o6XRIpg5_9IpuA2v1ViXAlcacJC-_UF5xrlDvt8wGPScv9ZS",
|
||
# "user_douyin_id": "wuzhangkong225", "user_nickname": "舞长空",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_ooI9lDkAPKnwDIU5zAEKWffDhAACWgNBh8AA3p.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:01"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAACHM85BtL73Y3h7haAHZswiHr4DfUgyLsLFym_6bGWbUN_Fczhif1gICfGjYwCD1c",
|
||
# "user_douyin_id": "tong2316117217", "user_nickname": "桐",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813c001_a0d95086e01d4cb7b688b229e80d31ae.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:02"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAr9NsLtiSmQg-t42uwOlI_fIMOFRLEtWC1vfQfqWsl6I", "user_douyin_id": "dyp7jnilug6m",
|
||
# "user_nickname": "用户8699957944152",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/aweme-avatar/douyin-user-file_b9b5e48a6798f7aad0463ccb244e913f.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:02"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAClCyCfU6bvSHUf-VWPIZZbgo8lWHYxAwAPPwfgW1bzY", "user_douyin_id": "901917796",
|
||
# "user_nickname": "智豪",
|
||
# "user_avatar": "https://p26.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813_oEAAsizmfA2UlVtXAe0HACBAEBKEICAtgyqsjh.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:02"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAirpOMXH04hh858-ovaBCSbXd7v5cjXIIuxY0T_Qr2IZ0inUWeHbSFvqHcfPJ0L4d",
|
||
# "user_douyin_id": "27127316174", "user_nickname": "无缘",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_78ea054704944edcf5d8086d1be013dc.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:02"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAx9Ex-KTOr4gYs7z242IKyl5decf8caBERAiAcUP9HQi5CehxwTjyNmvsVyI3LqP1",
|
||
# "user_douyin_id": "dyxffwjuamcd", "user_nickname": "。.。",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-i-0813c000-ce_oUf9EAj6ezTyAApMSJEMIXH6wAFNEoAODaDeAE.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:02"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAc39tGtYVR-R_T01VadR0Zpi9D71fdWHjR4Mck02R5Xw", "user_douyin_id": "9898620",
|
||
# "user_nickname": "7L",
|
||
# "user_avatar": "https://p3.douyinpic.com/aweme/100x100/aweme-avatar/tos-cn-avt-0015_5c4c2d8ea65e9f68182aea8fd53ef873.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:03"},
|
||
# {"account_url_part": "MS4wLjABAAAAmqCtESSNlEubCwi95GKLd77fsja9MyGBzjb11zLojW4",
|
||
# "user_sid": "MS4wLjABAAAAoMh40OkBHAUcoUKqneuqC7MAS466aylFi0FqAjnyxbo", "user_douyin_id": "2019420549",
|
||
# "user_nickname": "。;-)",
|
||
# "user_avatar": "https://p11.douyinpic.com/aweme/100x100/18aeb0003c44225b4603f.jpeg?from=3067671334",
|
||
# "blacklist_reason": "进入直播间", "blacklist_time": "2025-05-16 13:41:03"},
|
||
|
||
# 此处添加所有需要插入的原始数据（共44条，需与原数据数量一致）
|
||
# ... 省略重复结构，实际使用时需完整列出所有44条记录 ...
|
||
]:
|
||
record["blacklist_reason"] = random.choice(blacklist_reasons)
|
||
insert_values.append((
|
||
record["account_url_part"],
|
||
record["user_sid"],
|
||
record["user_douyin_id"],
|
||
record["user_nickname"],
|
||
record["user_avatar"],
|
||
record["blacklist_reason"],
|
||
record["blacklist_time"]
|
||
))
|
||
|
||
# 构建SQL语句
|
||
placeholders = ", ".join(["?" for _ in range(7)])
|
||
sql_insert = f"INSERT INTO blacklist_records (account_url_part, user_sid, user_douyin_id, user_nickname, user_avatar, blacklist_reason, blacklist_time) VALUES ({placeholders})"
|
||
|
||
try:
|
||
c.executemany(sql_insert, insert_values)
|
||
conn.commit()
|
||
print(f"成功插入 {len(insert_values)} 条带有随机拉黑原因的记录")
|
||
except sqlite3.IntegrityError as e:
|
||
print(f"插入失败（唯一约束冲突）: {e}")
|
||
except Exception as e:
|
||
print(f"插入失败（其他错误）: {e}")
|
||
finally:
|
||
conn.close()
|