Luis M. Gonzalez
luismg at gmx.net
Wed Feb 1 12:23:24 EST 2006
Thank you all for your responses! I think Joshua Ginsberg already gave me a solution (off line) to this situation as folows: db = MySQLdb.connect(user='mysql', db='foo') c = db.cursor() c.execute('''describe address''') t = c.fetchall() t (('id', 'int(11)', '', 'PRI', None, 'auto_increment'), ('fn', 'varchar(255)', 'YES', '', None, ''), ('ln', 'varchar(255)', 'YES', '', None, ''), ('a1', 'varchar(255)', 'YES', '', None, ''), ('a2', 'varchar(255)', 'YES', '', None, ''), ('c', 'varchar(255)', 'YES', '', None, ''), ('s', 'char(2)', 'YES', '', None, ''), ('zip', 'varchar(9)', 'YES', '', None, '')) >>> filter(lambda x: x[3] == 'PRI', t)[0][0] 'id' Nicholas and James: I'm using MySQLdb and as far as I know, "cursor.description" gives me only a seven-item tuple containing name, type code, display size, internal size, precision, scale, and nullability. Actually, I use it to get the three first values in my script. James: I'm sending you the script... Thanks you all and, again, sorry for the question! I imagined that the script would be of interest to somebody here... Regards, Luis -------------- next part -------------- An HTML attachment was scrubbed... URL: http://mm_cfg_has_not_been_edited_to_set_host_domains/pipermail/mod_python/attachments/20060201/d0d17a6f/attachment.html
|