Check UserID by PostID sqlite3?

Question

Python

There is a Users table , it has postid and userid fields , how can I check for the presence of a specific userid by postid

My query:

"SELECT userid FROM users WHERE postid=?"

Ask if you don't understand.

Answer 1

conn = sqlite3.connect("users.db")
cursor = conn.cursor()
query = f"""SELECT * from questionnaires WHERE user_id={user_id}"""
cursor.execute(query)
check = cursor.fetchall()
if check:
#если пользователь есть
else:
#если нету

I think you can substitute your data.

Answer 2

connect = sqlite3.connect("users.db")
cursor = connect.cursor()
cursor.execute("SELECT userid FROM users WHERE postid=?",(user_id,))
check = cursor.fetchall()
if check:
#если пользователь с таким id есть
else:
#если нету