v0.5.1

The latest version includes a quick hotfix to handle exceptions and ensure proper connection management. Here are the main changes:

Fixes

• Fixed the execute_sql function in sql_utils.py to handle exceptions and close the connection properly.

Tests

• Added tests in test_close_sqlite_connection_after_exception.py to ensure proper handling of IntegrityError and OperationalError in DBModel.

In summary, this version improves exception handling and connection management.

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
• Filter data and retrieve multiple records
• Read all data from the database
• Update table schema
• Custom primary key
• Bulk operations (save, update, delete)
• Migrations

Full Changelog: v0.5.0...v0.5.1