Python SQLite3 select with and operator

Question

I'm pretty new to python and SQLite but have done substantial work with MySQL and php.

I'm trying trying to do a conditional select on some data and would like to use the AND operator.

The MySQL query would look like this.

SELECT * FROM sensors WHERE sensor_id = "sometext" AND group_id = "somegroup"

Here's what my python looks like

Import SQLite3 as sqlite
con = sqlite.connect('../DB/system.db')
with con:
cur = con.cursor()
cur.execute("SELECT * FROM sensors WHERE sensor_id=:id",{"id": subdirname})
con.commit()

• Pedro Romano: Your question is a generic Python question, and not Raspberry Pi specific. You'll have a better chance of receiving an answer if you ask it on stackoverflow.
• Deac Karns: I thought about putting it on stack overflow but I wanted to get the answer on the raspberry pi section, in case other new python SQLite programmers had the same issue. The accepted answer adds clarity to an issue that is difficult to search for on google, with the AND/OR keywords in the search context.

Answer 1

You should be able to continue the SQL query in the same manner and add another named placeholder with a corresponding element in the parameter dictionary.

cur.execute("SELECT * FROM sensors WHERE sensor_id=:id AND group_id=:gid", {"id": subdirname, "gid": somevar})