如何使用python检查数据库中的逗号分隔值是否存在于JSON数据中

import json
import pymysql

conn = pymysql.connect(host='数据库主机地址', user='用户名', password='密码', db='数据库名', charset='utf8mb4')
cursor = conn.cursor()

cursor.execute("SELECT column_name FROM table_name")
result = cursor.fetchall()

values = ','.join([row[0] for row in result])

with open('data.json', 'r') as file:
    json_data = json.load(file)

for value in values.split(','):
    if value in json_data:
        print(f"{value} exists in JSON data.")
    else:
        print(f"{value} does not exist in JSON data.")

import json
import pymysql

conn = pymysql.connect(host='数据库主机地址', user='用户名', password='密码', db='数据库名', charset='utf8mb4')
cursor = conn.cursor()

cursor.execute("SELECT column_name FROM table_name")
result = cursor.fetchall()

values = ','.join([row[0] for row in result])

with open('data.json', 'r') as file:
    json_data = json.load(file)

for value in values.split(','):
    if value in json_data:
        print(f"{value} exists in JSON data.")
    else:
        print(f"{value} does not exist in JSON data.")

cursor.close()
conn.close()