home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 722055104

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/196#issuecomment-722055104 https://api.github.com/repos/simonw/sqlite-utils/issues/196 722055104 MDEyOklzc3VlQ29tbWVudDcyMjA1NTEwNA== 9599 2020-11-05T00:47:34Z 2020-11-05T00:47:34Z OWNER

This is surprisingly difficult. I need to parse the CREATE VIRTUAL TABLE statement, which will look something like this:

sql CREATE VIRTUAL TABLE "global-power-plants_fts" USING FTS5 ("name", content="global-power-plants")

The problem is I need to be able to handle various different quoting formats for the table name (mytable v.s. "mytable" v.s. [mytable]) plus I need to look out for CREATE TABLE IF NOT EXISTS.

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