home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 1154453319

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/440#issuecomment-1154453319 https://api.github.com/repos/simonw/sqlite-utils/issues/440 1154453319 IC_kwDOCGYnMM5Ez49H 9599 2022-06-13T21:23:16Z 2022-06-13T21:23:16Z OWNER

Aha! I think I see what's happening here. Here's what DictReader does if one of the lines has too many items in it:

```pycon

import csv, io list(csv.DictReader(io.StringIO("id,name\n1,Cleo,nohead\n2,Barry"))) [{'id': '1', 'name': 'Cleo', None: ['nohead']}, {'id': '2', 'name': 'Barry'}] `` See how that row with too many items gets this:[{'id': '1', 'name': 'Cleo', None: ['nohead']}`

That's a None for the key and (weirdly) a list containing the single item for the value!

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
1250629388  
Powered by Datasette · Queries took 0.987ms · About: github-to-sqlite