home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 803777724

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/1268#issuecomment-803777724 https://api.github.com/repos/simonw/datasette/issues/1268 803777724 MDEyOklzc3VlQ29tbWVudDgwMzc3NzcyNA== 9599 2021-03-22T05:42:50Z 2021-03-22T05:43:23Z OWNER

If I want to avoid counting virtual tables, I need to detect which tables are virtual tables.

The safest way to do this is probably to pull the sql for every table and then, in Python, check for values that start with create virtual table after converting to lower case, using any number of spaces.

This would catch things like CREATE virtual TABLE which might be missed by a SQL like query.

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