0.8.0

New Features

• Implement list, dict, tuple and set as valid field types (#63) by seapagan
• Add delete() method to QueryBuilder with comprehensive test coverage (#61) by seapagan

Dependency Updates

• Update astral-sh/setup-uv action to v5 (#59) by renovate[bot]
• Update astral-sh/setup-uv action to v4 (#57) by renovate[bot]

Full Changelog | Diff | Patch

0.7.0

New Features

• Support the date and datetime types (#52) by seapagan
• Add created_at and updated_at timestamps to the BaseDBModel (#49) by seapagan
• Add some useful properties to the SqliterDB class instance (#48) by seapagan

Bug Fixes

• Fix missing commits from the previous PR (#49) (#50) by seapagan

Full Changelog | Diff | Patch

0.6.0

New Features

• Add ability to mark a field as UNIQUE (#46) by seapagan
• Implement user-defined indexes (#45) by seapagan

Bug Fixes

• Ensure context-manager ignores the auto_commit setting. (#43) by seapagan

Full Changelog | Diff | Patch

0.5.0

Breaking Change!

This release removes the create_pk and primary_key attributes from the Model
Meta Class. Now, an auto-incrementing primary key is created by default and
the name of the primary key is always pk.

Closed Issues

• Auto-generated primary key not returned by the Model (#37) by seapagan

Breaking Changes

• Always create a pk primary auto-incrementing key (#39) by seapagan

Bug Fixes

• Fix null filter when combined with others and add tests (#40) by seapagan

Documentation

• Refactor web docs layout and improve content (#36) by seapagan

Full Changelog | Diff | Patch

0.4.0

New Features

• Add exists_ok and force flags to create_table (#34) by seapagan
• Add reset= to SqliterDB(), to drop all existing tables (#33) by seapagan
• Order by primary key if no field specified to order() (#32) by seapagan
• Add drop_table method (#31) by seapagan
• Add debug logging option (#29) by seapagan
• Create relevant database fields depending on the Model types (#27) by seapagan

Testing

• Add test coverage where missing (#28) by seapagan

Refactoring

• Perform some internal refactoring, mostly arranging the tests. (#30) by seapagan

Documentation

• Add a documentation website and trim down the README (#25) by seapagan

Full Changelog | Diff | Patch

0.3.0

Breaking Changes

• Rename 'create_id' to 'create_pk' (#23) by seapagan

New Features

• Deprecate 'direction=' for 'reverse=' in order() method. (#24) by seapagan
• Add improved table name generation (#21) by seapagan
• Implement an in-memory database option (#15) by seapagan
• Allow selecting a subset of the database fields instead of all them (#12) by seapagan
• Improve dev tooling and contributor documentation (#11) by seapagan

Dependency Updates

• Update dependency ruff to v0.6.7 (#19) by renovate[bot]
• Update dependency pydantic to v2.9.2 (#18) by renovate[bot]
• Update dependency idna to v3.10 (#17) by renovate[bot]
• Update dependency zipp to v3.20.2 (#16) by renovate[bot]
• Update astral-sh/setup-uv action to v3 (#10) by renovate[bot]

Full Changelog | Diff | Patch

0.2.0

New Features

• Default to auto_create=True, and add 'commit()' & 'close()' methods (#9) by seapagan
• Add more advanced filtering options (#7) by seapagan

Bug Fixes

• Ensure context manager commits on exit (#8) by seapagan

Full Changelog | Diff | Patch

0.1.1

Just a documentation fix - README was old version

Full Changelog: 0.1.0...0.1.1

0.1.0

New Features

• Remove transaction exception (TransactionError) (#4) by seapagan
• Improve error handling across the library (#3) by seapagan
• Add 'limit', 'offset' and 'order' methods (#2) by seapagan

Testing

• Add a full test suite to the existing code. (#1) by seapagan

Dependency Updates

• Configure Renovate (#5) by renovate[bot]