Re: pymysql question

From	Dennis Lee Bieber <wlfraed@ix.netcom.com>
Newsgroups	comp.lang.python
Subject	Re: pymysql question
Date	2016-02-18 22:06 -0500
Organization	IISS Elusive Unicorn
Message-ID	<mailman.33.1455851173.2289.python-list@python.org> (permalink)
References	<0b27ecb5-4a3e-46dc-a83c-5ce806f46051@googlegroups.com> <56C5BE90.4050500@mrabarnett.plus.com>

Show all headers | View raw

On Thu, 18 Feb 2016 12:52:32 +0000, MRAB <python@mrabarnett.plus.com>
declaimed the following:

>On 2016-02-18 12:08, tdsperth@gmail.com wrote:
>> Hi All
>>
>> I have many mysql tables in a conversion I am doing - the table field names are a mixture of lower case and upper case - do I have to covert all to one case to over come Python not finding the field.
>>
>> rows ocur.fetchall()
>> for row in rows:
>>      print(row['newname'])
>>      #which fails because it is upper case in the table
>>
>According to this:
>
>MySQL query to get column names?
>http://stackoverflow.com/questions/4165195/mysql-query-to-get-column-names
>
>it's possible to get the column names.
>
>You could then build a dict to map a lowercase column name to an actual 
>column name.

	Uhm... If pymysql is db-api compliant, you shouldn't need a query just
for the names... Any cursor that returns results has a description of the
fields in that result...

https://www.python.org/dev/peps/pep-0249/#cursor-attributes

	One could build the mapping from the cursor.description attribute.
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

pymysql question tdsperth@gmail.com - 2016-02-18 04:08 -0800
  Re: pymysql question MRAB <python@mrabarnett.plus.com> - 2016-02-18 12:52 +0000
  Re: pymysql question Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2016-02-18 22:06 -0500

csiph-web