SimpleSQLite

• Restore backward compatibility with v1.4.0 and earlier
  • Backward compatibility breaks when Model subclasses use attr_name as a keyword argument
  • The problem introduced at SimpleSQLite 1.5.0

Full Changelog: https://github.com/thombashi/SimpleSQLite/compare/v1.5.1...v1.5.2

• Fix Model.insert method failed when executing with a record that calls __setitem__ method: thombashi/sqlitebiter/#96
  • The bug introduced at SimpleSQLite 1.5.0

Full Changelog: https://github.com/thombashi/SimpleSQLite/compare/v1.5.0...v1.5.1

New Features

• Add __all__ to simplesqlite.model module
• Add get_column_name method to Column class
• Add support for Python 3.12
• Accept Column object as a key of simplesqlite.query.Where class
• Add simplesqlite.query.Set class. The SimpleSQLite.update method now accepts simplesqlite.query.Set as an argument

ORM Enhancements

• Add delete method to Model class: #77 (Thanks to @GOOD-Stuff)
• Add update`` method to Model` class
• Optimizations

Improvements

• Improve error messages
• Improve type annotations

Dependency Updates

• Bump minimum version of DataProperty to 1.0.1
• Bump minimum version of sqliteschema to 1.4.0

Bug Fixes

• Resolved an issue with the insert method of the Model class, ensuring that default values are correctly handled during record insertion

Full Changelog: https://github.com/thombashi/SimpleSQLite/compare/v1.4.0...v1.5.0

What's Changed

• Add connect kwargs to SimpleSQLite constructor by @michaelbukachi in https://github.com/thombashi/SimpleSQLite/pull/76
• Add docs extras

New Contributors

• @michaelbukachi made their first contribution in https://github.com/thombashi/SimpleSQLite/pull/76

Full Changelog: https://github.com/thombashi/SimpleSQLite/compare/v1.3.2...v1.4.0

• Modify to use pypa/build for package build
• Add zip_safe=False
• Add __all__ to __init__.py
• Update [build-system]
• Drop support for Python 3.6

Full Changelog: https://github.com/thombashi/SimpleSQLite/compare/v1.3.1...v1.3.2

• Add support for Python 3.11
• Add support for pathvalidate v3
• Update requirements

Full Changelog: https://github.com/thombashi/SimpleSQLite/compare/v1.3.0...v1.3.1

• Add support for View
• Add fetch_view_names method SimpleSQLite class
• Add has_view method SimpleSQLite class
• Update requirements

• Add type_hints argument to create_table_from_data_matrix method
• Remove setuptools requires
• Add support for Python 3.10
• Drop support for Python 3.5

• Fix fetch_attr_names method improperly return attributes when passing a database that has MySQL (or other databases) schema descriptions: #72 (Thanks to @bobgott)

• Fix changes in max_workers value are properly applied
• Update requirements

• Accept table names that start with numbers

• Fix create_table_from_dataframe: #67 (Thanks to @b0b5h4rp13)
• Add support for datetime value conversion
• Update requirements
• Modify type annotations
• Modify to extract type_hints from pandas.DataFrame for create_table_from_dataframe
• Fix to include py.typed to the package

• Drop Python 2 support
• Add type annotations and py.typed to the package
• Update requirements
• Minor bug fixes

• Add as_dict method to Model class
• Make it possible to assign attribute name to columns of Model
• Remove deprecated methods

• Add support for platforms that lacks support sem_open such as Android Termux
• Add interfaces to set the maximum number of workers to convert a table
• Add support for Python 3.9
• Replace logging library from Logbook to loguru
• Remove dev extras_require

• Add support for PyPy
• Integrate build/release/docs extras to dev extras
• Add .asc files of packages to PyPI
• Update requirements
• Bug fixes

• Add an interface to set primary key to create_table_from_xxx methods : #63 (Thanks to @xuanblo)

• Add simple object-relational mapping (ORM) feature

• Add a method to execute a delete query
• Add a method to set row_factory
• Add log messages
• Avoid deleting SQLite internal table

• Performance improvement