Justin,
I worked the same way that you suggested.
i created a separate function which converts the result in the cursor to
the list of dict type
def FormatResult(self,Cur):
Updated_Result=[]
columns = tuple( [d[0].decode('utf8') for d in Cur.description] )
for row in Cur:
Updated_Result.append(dict(zip(columns, row)))
return Updated_Result
cursor.execute(''SQL Stmnt")
Result=FormatResult(cursor)
On Friday, August 24, 2012 9:52:39 PM UTC+5:30, Justin Israel wrote:
>
> According to the docs, the mysql-connector doesn't supply a
> dictionary-type cursor, but they do give an approach to supplementing the
> functionality:
>
> cursor.execute("""
> SELECT last_name, first_name, hire_date
> FROM employees WHERE emp_no = %s
> """, (123,))
> row = dict(zip(cursor.column_names, cursor.fetchone())
> print("{last_name}, {first_name}: {hire_date}".format(row))
>
> Their example only shows how you handle a single result at a time, but
> here is how you could transform the entire result set into a list of dicts:
>
> c.execute("""SELECT Artist_Name, Artist_ID, Login_ID FROM
> artists_core.employee limit 1,10""")
> res = [dict(zip(c.column_names, row) for row in c.fetchall()]
> print res[0]['Artist_Name']
>
>
> On Fri, Aug 24, 2012 at 1:13 AM, Donal McMullan
> <[email protected]<javascript:>
> > wrote:
>
>> Hmm - looks like I dropped some inverted commas
>>
>>
>> On 24/08/12 20:10, Donal McMullan wrote:
>>
>> import MySQLdb as mdb
>> con=mdb.connect('172.16.48.9', 'showtime', 's1000@ma25db', '
>> artists_core')
>> c = con.cursor(mdb.cursors.DictCursor)
>> c.execute("""SELECT Artist_Name, Artist_ID, Login_ID FROM
>> artists_core.employee limit 1,10""")
>> rows = c.fetchall()
>> for row in rows:
>> print "%s %s" % (row["Artist_Name"], row["Artist_ID"])
>>
>>
>>
>> --
>>
>> Donal McMullan
>> Production Engineer
>>
>> --
>> view archives: http://groups.google.com/group/python_inside_maya
>> change your subscription settings:
>> http://groups.google.com/group/python_inside_maya/subscribe
>>
>
>
--
view archives: http://groups.google.com/group/python_inside_maya
change your subscription settings:
http://groups.google.com/group/python_inside_maya/subscribe
