home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 1846560096

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/pull/604#issuecomment-1846560096 https://api.github.com/repos/simonw/sqlite-utils/issues/604 1846560096 IC_kwDOCGYnMM5uEEVg 9599 2023-12-08T05:16:44Z 2023-12-08T05:17:20Z OWNER

Also tested this manually like so:

bash sqlite-utils create-table strict.db strictint id integer size integer --strict sqlite-utils create-table strict.db notstrictint id integer size integer sqlite-utils install sqlite-utils-shell sqlite-utils shell strict.db Attached to strict.db Type 'exit' to exit. sqlite-utils> insert into strictint (size) values (4); 1 row affected sqlite-utils> insert into strictint (size) values ('four'); An error occurred: cannot store TEXT value in INTEGER column strictint.size sqlite-utils> insert into notstrictint (size) values ('four'); 1 row affected sqlite-utils> commit; Done

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