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