René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite3.Row behaves like a dictionary but doesn't handle \"in\" as one might expect","articleBody":"The `sqlite3.Row` class is supposed to give access to row results by name as well as index. So in some respects it behaves like a dictionary (it even has a `keys()` method) but it doesn't appear to handle the ` in ` operator as one might expect.\r\n\r\nThe following minimal script illustrates:\r\n```python\r\nimport sqlite3\r\n\r\nCREATION = 'CREATE TABLE lookup (name TEXT NOT NULL, value TEXT NOT NULL)'\r\nINSERTION = 'INSERT INTO lookup (name, value) VALUES(?, ?)'\r\nSELECTION = 'SELECT name, value from lookup'\r\n\r\ndb = sqlite3.connect(':memory:')\r\ncur = db.cursor()\r\ncur.execute(CREATION)\r\ncur.execute(INSERTION, ('foo', 'bar'))\r\ndb.commit()\r\ncur.row_factory = sqlite3.Row\r\ncur.execute(SELECTION)\r\nrows = cur.fetchall()\r\nrow = rows[0]\r\nprint(f'{row.keys()=}')\r\nfor k in row.keys():\r\n    print(f'{k=}')\r\n    print(f'{k in row=}')\r\n    print(f'{row[k]=}')\r\n```\r\n\r\nprints\r\n```\r\nrow.keys()=['name', 'value']\r\nk='name'\r\nk in row=False\r\nrow[k]='foo'\r\nk='value'\r\nk in row=False\r\nrow[k]='bar'\r\n```\r\n\r\nOne would reasonably expect `k in row` to be `True`.\r\n\r\nTested on Python 3.10.0, Ubuntu 20.04, but not believed to be restricted to those.\r\n\n\n\u003c!-- gh-linked-prs --\u003e\n### Linked PRs\n* gh-100457\n\u003c!-- /gh-linked-prs --\u003e\n","author":{"url":"https://github.com/vsajip","@type":"Person","name":"vsajip"},"datePublished":"2022-12-23T08:12:24.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":21},"url":"https://github.com/100450/cpython/issues/100450"}