Get values from SQL table along with column name as list in Python

Question

I have a SQL table like below

----------------------------------
     Key         |    Value
----------------------------------
Ralph Williams      Football
Michael Tippett     Basketball
Edward Elgar        Baseball
Rebecca Clarke      Netball
Ethel Smyth         Badminton

I have used cursor.execute("select top 5 Key, Value from TestTable") and then tried to convert as list using mylist = list(cursor)

But I am getting like

[(u'Ralph Williams', u'Football'), (u'Michael Tippett', u'Basketball'), (u'Edward Elgar', u'Baseball'), (u'Rebecca Clarke', u'Netball'), (u'Ethel Smyth', u'Rugby')]

But I need this table as list in python like below

[{'Key':'Ralph Williams', 'Value':'Football'}, {'Key':'Michael Tippett', 'Value':'Basketball'}, {'Key':'Edward Elgar', 'Value':'Baseball'}, {'Key':'Rebecca Clarke', 'Value':'Netball'}, {'Key':'Ethel Smyth', 'Value':'Rugby'}]

How can I make that?

Daniel Roseman · Accepted Answer · 2015-11-17 12:30:15Z

4

You need to use a dict cursor - see the pymssql docs.

cursor = conn.cursor(as_dict=True)
cursor.execute(...)

answered Nov 17, 2015 at 12:30

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jan Rüegg · Accepted Answer · 2015-11-17 12:51:08Z

0

Try this

Key_value_pair = dict(list_of_tuple_from_the_database)

edited Nov 17, 2015 at 12:51

Jan Rüegg

10.2k9 gold badges66 silver badges112 bronze badges

answered Nov 17, 2015 at 12:31

Bug Hunter 219

3442 silver badges16 bronze badges

Collectives™ on Stack Overflow

Get values from SQL table along with column name as list in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related