Please make sqlite3.Row iterable

[philipdumont]

BPO	1720959
Files	sqlite.py: Failure when trying to iterate over a row

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = <Date 2007-05-20.16:26:13.000>
created_at = <Date 2007-05-17.20:23:56.000>
labels = ['extension-modules']
title = 'Please make sqlite3.Row iterable'
updated_at = <Date 2007-05-20.16:26:13.000>
user = 'https://bugs.python.org/philipdumont'

bugs.python.org fields:

activity = <Date 2007-05-20.16:26:13.000>
actor = 'ghaering'
assignee = 'ghaering'
closed = True
closed_date = None
closer = None
components = ['Extension Modules']
creation = <Date 2007-05-17.20:23:56.000>
creator = 'philipdumont'
dependencies = []
files = ['2372']
hgrepos = []
issue_num = 1720959
keywords = []
message_count = 3.0
messages = ['32034', '32035', '32036']
nosy_count = 3.0
nosy_names = ['nnorwitz', 'ghaering', 'philipdumont']
pr_nums = []
priority = 'normal'
resolution = 'fixed'
stage = None
status = 'closed'
superseder = None
type = None
url = 'https://bugs.python.org/issue1720959'
versions = ['Python 2.5']

[philipdumont]

Sometimes I'd like to get row values with columnname
indexes, sometimes by iterating over the row.

The default (not setting the connection's row_factory)
is to return a tuple, which gives the latter, but not
the former.

Setting row_factory to sqlite3.Row gives the former,
but (surprisingly) not the latter.

It's a surprise because back when pysqlite was not part
of the Python distrib (I don't recall what version), its
Row type was iterable. Any chance that bit of
functionality could be put back?

[nnorwitz]

Gerhard, could you take a look?

[ghaering]

This functionality is already in the Python 2.6 branch. I was told not to backport it to 2.5.x. So, I'll close this issue.