v0.8.0

The latest version focuses on enhancing filter capabilities and ensuring comprehensive test coverage. Here are the key changes:

New Features

• Added support for various query operators in the DBModel filter method: BETWEEN, NOT LIKE, NOT IN, IN, LIKE, lt, lte, gt, gte, and not equal.

Refactoring

• Refactored methods for preparing and handling where conditions to support the new operators and improve code maintainability.

Tests

• Added comprehensive tests for all newly supported filter operators.
• Refactored tests to use prepared data from prepare_db for consistency and efficiency.

Documentation

• Updated the README.md to document new filter options and mark completed tasks in the checklist.

In summary, this update significantly enhances the filtering capabilities of the DBModel and ensures robust testing and documentation for these new features.

Features and Roadmap

• Define table schema using Pydantic models
• Basic CRUD operations
  • Save data to the database
  • Read data from the database
  • Update data in the database
  • Delete data from the database
• Relationships between tables
  • One-to-many
    • Create a tables with a foreign key
    • Save data with a foreign key
    • Read data with a foreign key
    • Update data with a foreign key
    • Delete data with a foreign key
      • Cascade
      • Set null
      • Restrict
      • Set default
      • No action
  • One-to-one
  • Many-to-many
• Unique constraints
• Remove table
• Read all data from the database
• Filter data and retrieve multiple records
  • Equal
  • Not equal
  • Greater than
  • Greater than or equal
  • Less than
  • Less than or equal
  • Like (Pattern matching with % and _)
  • Not like (Pattern matching with % and _)
  • In (List of values)
  • Not in (List of values)
  • Between (Two values)
  • Not between (Two values)
• Pagination
• Order by
• Update table schema
• Custom primary key
• Bulk operations (save, update, delete)
• Migrations

Full Changelog: v0.7.0...v0.8.0