[DB-SIG] Python db programming conventions

2010-10-17 Thread python + sqlite3
Hello all, As I'm new to both python and sqlite3, I would like to consult regarding python db programming conventions. After I finished to design my application and started coding it, I found myself dealing with the following questions: 1. Since the db contains more than one table, it seems natu

Re: [DB-SIG] Python db programming conventions

2010-10-20 Thread python + sqlite3
Vernon, 10x for the detailed reply. I understand from your answer that each SQL statement should have it's own cursor so in my case, since the db contains 5 tables, creating it will require 5 cursors. The parametrized queries will become handy when I'll write the INSERT and SELECT part of the co