[DB-SIG] Python db programming conventions

[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 natural to use
transaction in order to create the it. The transaction contains more than
one SQL statement and therefor can't be executed using cursor.execute(). I
found the method cursor.executescript() that documented as non-standard, is
that the method to be used? is there better way of creating the db?

2. In order to create and maintain the db tables, I'll need to use several
long transactions (CREATE, EDIT, INSERT, DELETE etc.). Where should I place
the SQL code for them? Should my class contain the SQL queries as private
string properties? should I define the SQL queries as class member
functions? Or is it better to store the SQL code in separate SQL files and
execute the files somehow (is it possible to execute SQL file using
sqlite3)?

I'd appreciate your help,
Cheers
-- 
View this message in context: http://old.nabble.com/Python-db-programming-conventions-tp29977345p29977345.html
Sent from the Python - db-sig mailing list archive at Nabble.com.