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 you need to access the result sets of e.g. 5 different queries at the same time, then you do indeed have to open 5 cursors to keep open the result sets. > The parametrized queries will become handy when I'll write the INSERT and > SELECT part of the code. Here's a short introduction to the DB-API and the concepts: http://www.egenix.com/library/presentations/EuroPython2008-Using-the-Python-Database-API/ I also gave a slightly longer talk in German at the recent DZUG Tagung 2010 in Dresden: http://www.zope.de/tagung/Dresden_2010/Python-Datenbankprogrammierung_mal.pdf/view -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Oct 20 2010) >>> Python/Zope Consulting and Support ... http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ ::: Try our new mxODBC.Connect Python Database Interface for free ! :::: eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 http://www.egenix.com/company/contact/ _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
