[pysqlite] [APSW 3.6.10-r1] Displaying query before update?
Gilles <[email protected]> Sat, 21 Mar 2009 10:30:39 +0100
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
Hello I didn't find how to search the mailing list archives, so can't check in which thread this question was answered before :-/ I'd like to use the safe way to insert/update records: ======= sql = 'BEGIN;' sql = sql + 'UPDATE companies SET name=?,address=?,zip=? WHERE id=?;' sql = sql + "COMMIT" try: #How to only display the query, not run it directly? cursor.execute(sql, (name,address,zip,id) ) except: print "Failed UPDATING" raise ======= But before actually calling cursor.execute, I'd like to only display what the query will look like. How should I do this? Thank you.