home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 982020757

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/344#issuecomment-982020757 https://api.github.com/repos/simonw/sqlite-utils/issues/344 982020757 IC_kwDOCGYnMM46iHKV 9599 2021-11-29T21:03:34Z 2021-11-29T21:03:34Z OWNER

From the STRICT docs:

The SQLite parser accepts a comma-separated list of table options after the final close parenthesis in a CREATE TABLE statement. As of this writing (2021-08-23) only two options are recognized:

  • STRICT
  • WITHOUT ROWID

So I think I need to read the CREATE TABLE statement from the sqlite_master table, split on the last ), split those tokens on , and see if create is in there (case insensitive).

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