Sqlite and Python -- return a dictionary using fetchone()?
- by AndrewO
I'm using sqlite3 in python 2.5. I've created a table that looks like this:
create table votes (
bill text,
senator_id text,
vote text)
I'm accessing it with something like this:
v_cur.execute("select * from votes")
row = v_cur.fetchone()
bill = row[0]
senator_id = row[1]
vote = row[2]
What I'd like to be able to do is have fetchone (or some other method) return a dictionary, rather than a list, so that I can refer to the field by name rather than position. For example:
bill = row['bill']
senator_id = row['senator_id']
vote = row['vote']
I know you can do this with MySQL, but does anyone know how to do it with SQLite?
Thanks!!!
