Sqlite-utils

Latest version: v3.36

Safety actively analyzes 638418 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 13 of 19

2.7.1

* New `sqlite-utils views my.db` command for listing views in a database, see [Listing views](https://sqlite-utils.readthedocs.io/en/latest/cli.html#cli-views). (105)
* `sqlite-utils tables` (and `views`) has a new `--schema` option which outputs the table/view schema, see [Listing tables](https://sqlite-utils.readthedocs.io/en/latest/cli.html#cli-tables). (104)
* Nested structures containing invalid JSON values (e.g. Python bytestrings) are now serialized using `repr()` instead of throwing an error. (102)

2.7

* New `columns=` argument for the `.insert()`, `.insert_all()`, `.upsert()` and `.upsert_all()` methods, for over-riding the auto-detected types for columns and specifying additional columns that should be added when the table is created. See [Custom column order and column types](https://sqlite-utils.readthedocs.io/en/stable/python-api.html#python-api-custom-columns). (100)

2.6

* New `table.rows_where(..., order_by="age desc")` argument, see [Listing rows](https://sqlite-utils.readthedocs.io/en/stable/python-api.html#listing-rows). (76)

2.5

* Panda’s Timestamp is now stored as a SQLite TEXT column. Thanks, b0b5h4rp13! (96)
* `table.last_pk` is now only available for inserts or upserts of a single record. (98)
* New `Database(filepath, recreate=True)` parameter for deleting and recreating the database. (97)

2.4.4

* Fixed bug where columns with only null values were not correctly created. (95)

2.4.3

* Column type suggestion code is no longer confused by null values. (94)

Page 13 of 19

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.