home / github / issue_comments

Menu
  • 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](https://www.sqlite.org/withoutrowid.html) 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.717ms