home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 1007639860

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/366#issuecomment-1007639860 https://api.github.com/repos/simonw/sqlite-utils/issues/366 1007639860 IC_kwDOCGYnMM48D100 9599 2022-01-07T18:32:59Z 2022-01-07T18:33:07Z OWNER

From the SQLite docs:

If no arguments are given, all attached databases are analyzed. If a schema name is given as the argument, then all tables and indices in that one database are analyzed. If the argument is a table name, then only that table and the indices associated with that table are analyzed. If the argument is an index name, then only that one index is analyzed.

So I think this becomes two methods:

  • db.analyze() calls analyze on the whole database
  • db.analyze(name_of_table_or_index) for a specific named table or index
  • table.analyze() is a shortcut for db.analyze(table.name)
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
1096563265  
Powered by Datasette · Queries took 2.351ms · About: github-to-sqlite