simonw / sqlite-utils

Python CLI utility and library for manipulating SQLite databases
https://sqlite-utils.datasette.io
Apache License 2.0
1.62k stars 109 forks source link

Backfill the release notes prior to 0.4 #576

Closed simonw closed 1 year ago

simonw commented 1 year ago

Currently the changelog starts at 0.4:

https://sqlite-utils.datasette.io/en/3.34/changelog.html#id115

I want the other releases - according to https://pypi.org/project/sqlite-utils/#history there are three missing:

image
simonw commented 1 year ago

Using llm in my sqlite-utils local checkout:

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
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
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
simonw commented 1 year ago

Done - bottom of https://sqlite-utils.datasette.io/en/latest/changelog.html#id116