v0.9.0

The latest version introduces new functionality and improvements, particularly focusing on the order_by feature. Here are the key changes:

New Features

• Added support for the order_by clause in filter and all methods to handle sorting results by multiple fields.

Documentation

• Updated README.md to include documentation for the order_by functionality.
• Added a Changelog section with a link to release notes.
• Added an item to the checklist for protecting against SQL injection.

In summary, this update enhances the sorting capabilities of queries with the order_by clause and ensures robust testing and documentation for these 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)
• Protect against SQL injection
• Order by
• Pagination
• Update table schema
• Custom primary key
• Bulk operations (save, update, delete)
• Migrations

Full Changelog: v0.8.1...v0.9.0