issue_comments: 1646752814

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/576#issuecomment-1646752814 https://api.github.com/repos/simonw/sqlite-utils/issues/576 1646752814 IC_kwDOCGYnMM5iJ3Qu 9599 2023-07-23T05:43:13Z 2023-07-23T05:43:13Z OWNER

Using llm in my sqlite-utils local checkout: bash git diff 0.2 0.3 | llm -s 'release notes as markdown bullet points'

  • Added a new Table class in the db module which represents a table in a SQLite database
  • The Table class has properties that provide information about the table, such as column names, foreign keys, and schema
  • The Table class also has a count property that returns the number of rows in the table
  • The Table class has a create method that can be used to create a new table with specified columns, primary key, and foreign keys
  • Updated the Database class in the __init__ module to include the Table class and expose it via the __all__ variable
  • Added new tests for creating tables and introspecting tables

bash git diff 0.3 0.3.1 | llm -s 'release notes as markdown bullet points'

  • Updated PyPI version badge to display the latest version
  • Updated Travis CI badge to link to the master branch
  • Added a badge for documentation status
  • Added a license badge
  • Added a description of the package
  • Added installation instructions
  • Added a link to the documentation
  • Added a "Related projects" section and linked to Datasette and csvs-to-sqlite
  • Updated the version in setup.py to 0.3.1

bash git diff 0.3.1 0.4 | llm -s 'release notes as markdown bullet points'

  • Added an enable_fts method to the Table class that enables full-text search on specified columns
  • Added a populate_fts method to the Table class that refreshes the search index for full-text search
  • Added a search method to the Table class that allows searching the table using full-text search
  • Updated the setup.py script to version 0.4
  • Updated the db.py file to include the enable_fts, populate_fts, and search methods
  • Added test cases for the enable_fts, populate_fts, and search methods in the test_enable_fts.py file
  • Added test cases for the count, columns, and schema properties in the test_introspect.py file 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 1816997390