issue_comments: 1009273525

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-1009273525 https://api.github.com/repos/simonw/sqlite-utils/issues/366 1009273525 IC_kwDOCGYnMM48KEq1 9599 2022-01-10T19:32:39Z 2022-01-10T19:32:39Z OWNER

I'm going to implement the Python library methods based on the prototype: ```diff commit 650f97a08f29a688c530e5f6c9eedc9269ed7bdc Author: Simon Willison swillison@gmail.com Date: Sat Jan 8 13:34:01 2022 -0800

Initial prototype of .analyze(), refs #366

diff --git a/sqlite_utils/db.py b/sqlite_utils/db.py index dfc4723..1348b4a 100644 --- a/sqlite_utils/db.py +++ b/sqlite_utils/db.py @@ -923,6 +923,13 @@ class Database: "Run a SQLite VACUUM against the database." self.execute("VACUUM;")

  • def analyze(self, name=None):
  • "Run ANALYZE against the entire database or a named table or index."
  • sql = "ANALYZE"
  • if name is not None:
  • sql += " [{}]".format(name)
  • self.execute(sql) +

class Queryable: def exists(self) -> bool: @@ -2902,6 +2909,10 @@ class Table(Queryable): ) return self

  • def analyze(self):
  • "Run ANALYZE against this table"
  • self.db.analyze(self.name) + def analyze_column( self, column: str, common_limit: int = 10, value_truncate=None, total_rows=None ) -> "ColumnDetails": ```
 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1096563265