Database data generator open source install#

Improved error message if rows_from_file() is passed a non-binary-mode file-like object.Fixed a bug where repeated calls to ansform() did not work correctly.sqlite-utils transform no longer breaks if a table defines default values for columns.Tables can now be created with self-referential foreign keys.Fixing this by default would be a backwards-incompatible change and is under consideration for a 4.0 release in the future. nvert(., skip_false=False) and sqlite-utils convert -no-skip-false options, for avoiding a misfeature where the convert() mechanism skips rows in the database with a falsey value for the specified column.Now shows a more detailed error message when sqlite-utils insert is called with invalid JSON.Fixed a ResourceWarning when using sqlite-utils insert.Fixed a bug where table.upsert_all() failed if the not_null= option was passed.New -raw-lines option for the sqlite-utils query and sqlite-utils memory commands, which outputs just the raw value of the first column of evy row.Automatically locates the SpatiaLite extension on Apple Silicon.Tests now ensure compatibility with Python 3.11. The table.analyze_column() method ( documented here) now accepts most_common=False and least_common=False options for disabling calculation of those values.Calling sqlite-utils analyze-tables with non-existent columns in the -c/-column option now results in an error message.If a column contains only null values, analyze-tables will no longer attempt to calculate the most common and least common values for that column.sqlite-utils analyze-tables -no-most and -no-least options for disabling calculation of most-common and least-common values.sqlite-utils analyze-tables command ( documentation) now has a -common-limit 20 option for changing the number of common/least-common values shown for each column.There is a screenshot in the documentation.

Database data generator open source install#

This requires an optional dependency, installed using sqlite-utils install trogon. New experimental sqlite-utils tui interface for interactively building command-line invocations, powered by Trogon.