查找数据库中不存在的id

SELECT EXISTS(SELECT 1 FROM users WHERE id = ?);

SELECT id FROM (VALUES (1), (2), (3)) AS temp(id) WHERE NOT EXISTS (SELECT 1 FROM users WHERE users.id = temp.id);

import sqlite3

def check_nonexistent_ids(ids):
    conn = sqlite3.connect('example.db')
    cursor = conn.cursor()
    
    query = """
    SELECT id FROM (VALUES {}) AS temp(id) WHERE NOT EXISTS (SELECT 1 FROM users WHERE users.id = temp.id);
    """.format(','.join('({})'.format(i) for i in ids))
    
    cursor.execute(query)
    nonexistent_ids = cursor.fetchall()
    conn.close()
    
    return [id[0] for id in nonexistent_ids]

# 示例使用
ids_to_check = [1, 2, 3, 100]
nonexistent_ids = check_nonexistent_ids(ids_to_check)
print("Non-existent IDs:", nonexistent_ids)