issue_comments: 1224264744

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/467#issuecomment-1224264744 https://api.github.com/repos/simonw/sqlite-utils/issues/467 1224264744 IC_kwDOCGYnMM5I-Mwo 9599 2022-08-23T15:51:29Z 2022-08-23T15:53:29Z OWNER

Jeff suggested db[table].(..., alter=True) for this.

python db["urls"].create( { "url": str, "crawled": bool, "body": str, "headers": dict, "status": int, "status_text": str, }, pk="url", defaults={"crawled": False}, if_not_exists=True, alter=True, )

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1348169997