how can i SELECT FROM sqlite3_table WHERE column_name IN variable tuple?

Question

I have this tuple:

topics = ('sport', 'math', 'science', 'literature')

This topics tuple changes for every user (his length also changes)

How can I select from a sqlite3 table only the rows where their topic column's value equals to one of the topics tuple's values?

I tried to use this command but it didn't work:

conn = sqlite3.connect('questions_stack.db')
c = conn.cursor()
c.execute("""SELECT * FROM questions WHERE topic IN ?""", subject_tuple)

Can I select from the table like that if the topics tuple's length changes every time and is not constant?

I'd really appreciate it if you could help me :) Thanks in advance!

both the values and the length of the tuple changes for each user — mimi quarantine
– mimi quarantine, Commented Apr 8, 2020 at 22:07

GMB · Accepted Answer · 2020-04-08 22:10:56Z

2

You need to count how many values there are in the list, and generate the corresponding placeholders.

Something like:

conn = sqlite3.connect('questions_stack.db')
c = conn.cursor()
binds = ",".join("?" * len(subject_tuple))
sql = '''select * from questions where topic in ({})'''.format(binds)
cur.execute(sql, subject_tuple)

answered Apr 8, 2020 at 22:10

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how can i SELECT FROM sqlite3_table WHERE column_name IN variable tuple?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related