issue_comments: 620260658

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/datasette/issues/726#issuecomment-620260658 https://api.github.com/repos/simonw/datasette/issues/726 620260658 MDEyOklzc3VlQ29tbWVudDYyMDI2MDY1OA== 9599 2020-04-27T22:05:46Z 2020-04-27T22:05:46Z OWNER

Aah - yes I've seen this a few times before in my own projects. The problem is that the column types don't match up - your oeuvre_id column here is an integer, but if you look at the schema for prelib_oeuvre (at the bottom of this page: http://crbc-dataset.huma-num.fr/prelib/prelib_oeuvre) you'll see that it's defined as text:

sql CREATE TABLE "prelib_oeuvre" ( "id" TEXT, "titre" TEXT, "descriptif" TEXT, "wikidata" TEXT, "ark_bnf" TEXT, "notes" TEXT ,PRIMARY KEY ([id]) );

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