[DB-SIG] Python database API 2.0/returning Column names with data

[Andy Dustman]

On Sun, 2001-11-04 at 09:56, David A McInnis wrote:
> I found another one myself, for MySQLdb (I am using MySQL).
> 
> It appears that cursorclass= is undocumented as well.
> 
> If you set cursorclass=MySQLdb.cursors.DictCursor, a dictionary is returned
> which contains the row names.
> 
> db1 = MySQLdb.connect(user = "username", passwd="password", host= "host", db
> = "database", cursorclass=MySQLdb.cursors.DictCursor)
> 
> c1 = db1.cursor()
> c1.execute("""SELECT * from table where email = %s""",
> 'david@topsites.net',)
> 
> row1 = c1.fetchone()
> print row1['acctno']
> print row1['email']
> print row1['amt']

MySQLdb's cursorclass is not documented in the DB API because it is a
non-standard extension. It is, however, well-documented in the MySQLdb
documentation.

-- 
Andy Dustman         PGP: 0x930B8AB6
    @       .net     http://dustman.net/andy
You can have my keys when you pry them from my dead, cold neurons.