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()

score 2 · Accepted Answer · answered Dec 02 '12 at 12:43

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})

Python SQLite3 select with and operator

1 Answers1