how to mysqldb dict cursors
Vaibhav.bhawsar
bhawsar.vaibhav at gmail.com
Fri Apr 25 13:16:11 EDT 2008
Hmm that explains it! Thank you.
v
On Fri, Apr 25, 2008 at 7:38 AM, Steve Holden <steve at holdenweb.com> wrote:
> Vaibhav.bhawsar wrote:
> [top-posting amended: see below]
>
>> On Fri, Apr 25, 2008 at 12:45 AM, Paul McNett <p at ulmcnett.com <mailto:
>> p at ulmcnett.com>> 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
>
--
Vaibhav Bhawsar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20080425/33d7fc18/attachment-0001.html>
More information about the Python-list
mailing list