Op 12-11-12 09:29, Khalid Al-Ghamdi schreef:
Hi all,
How would you go about adding items from a cursor to a dictionary?
There is a nice buitin way, with example here:
http://docs.python.org/2/library/sqlite3.html#sqlite3.Row
It's not a real dictionary though, but it can act like it. Also, the
docs say the following:
"""
If returning a tuple doesn’t suffice and you want name-based access to
columns, you should consider setting row_factory to the highly-optimized
sqlite3.Row type. Row provides both index-based and case-insensitive
name-based access to columns with almost no memory overhead. It will
probably be better than your own custom dictionary-based approach or
even a db_row based solution.
"""
Timo
i tried this but to no avail:
>>> cur.execute('select * from schedule limit 10')
<sqlite3.Cursor object at 0x0112CE60>
>>> for i in range(len(cur.fetchall())):
d[i]=cur.fetchall()[i]
Traceback (most recent call last):
File "<pyshell#70>", line 2, in <module>
d[i]=cur.fetchall()[i]
IndexError: list index out of range
Thanks
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
