Querying Data
After connecting with the steps in Connecting, you can execute a SQL statements using the open connection.
Executing Queries
To execute SQL statements that return data, use the execute method. Once a query is executed, the result set is fetched from the cursor. This result set can then be iterated over to process the records individually:
cur = conn.execute("SELECT AccountId, Name FROM AdAccounts") rs = cur.fetchall() for row in rs: print(row)
Parameterized Queries
Various python collections, such as arrays and tuples are provided as additional arguments for the execute method. This allows you to parameterize the queries executed and help to prevent SQL Injection:
cmd = "SELECT AccountId, Name FROM AdAccounts WHERE Name = ?" params = ["Act Name"] cur = conn.execute(cmd, params) rs = cur.fetchall() for row in rs: print(row)