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

Re: [DB-SIG] Python db programming conventions

2010-10-20 Thread M.-A. Lemburg
python + sqlite3 wrote: > > 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. You can reuse cursors to run multiple commands. However, if

Re: [DB-SIG] adodbapi 2.4 : not possible to pickle

2010-10-20 Thread Dieter Maurer
Vernon Cole wrote at 2010-10-19 10:11 -0600: > ... > If this is something which is done frequently, then a perhaps a suitable >method should be added to the class definition of _SQLrow() so that pickle >would work on it directly. Is __getstate__() what one uses for this? "__getstate__", "__setst