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
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
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