Vaibhav.bhawsar wrote:
[top-posting amended: see below]
On Fri, Apr 25, 2008 at 12:45 AM, Paul McNett <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Vaibhav.bhawsar wrote:
I have been trying to get the DictCursor working with mysqldb
module but can't seem to. I have pasted the basic connection
code and the traceback from pydev. The connection does open with
the default cursor class. can't figure this one out. many thanks.
Try one of:
"""
import MySQLdb, MySQLdb.cursors
conn = MySQLdb.connect(..., cursorclass=MySQLdb.cursors.DictCursor)
"""
-or-
"""
import MySQLdb, MySQLdb.cursors
conn = MySQLdb.connect(...)
cur = MySQLdb.cursors.DictCursor(conn)
"""
I'm going off of memory here, though, but I'm at least close.
> Great both methods worked! I don't quite understand this since i
imported
> the whole module with "import MySQLdb"
>
> Thanks!
>
The point here is that MySQLdb is a package, not a module. Some packages
have their top-level __init__.py import the package's sub-modules or
sub-packages to make them immediately available within the package
namespace (which is why, for example, you can access os.path.* when you
have imported os) and others don't.
MySQLdb clearly doesn't need to import the cursors module for its own
purposes. Perhaps it would be less efficient to always perfrom the
import, who knows. Well, Andy Dustman does, I suppose, and possibly
anyone else who reads the code, but I haven't done that myself.
regards
Steve
--
Steve Holden +1 571 484 6266 +1 800 494 3119
Holden Web LLC http://www.holdenweb.com/
--
http://mail.python.org/mailman/listinfo/python-list
