Implements best practices for Peewee ORM using DatabaseProxy, scoped connections, and atomic transactions.
About
This skill provides specialized guidance for working with the Peewee Python ORM, focusing on advanced patterns like DatabaseProxy for dynamic initialization and scoped connection management. It helps developers correctly implement atomic transactions, handle database contexts to prevent connection leaks, and set up robust testing environments using SQLite and Pytest, ensuring maintainable and thread-safe database interactions in Python applications.
Key Features
Scoped connection management using connection_context blocks
DatabaseProxy configuration for late-binding database initialization
Automated SQLite testing patterns with isolated Pytest fixtures
Implementation of atomic transactions for data integrity and rollbacks
Standardized BaseModel patterns for clean model architecture
2 GitHub stars
Use Cases
Decoupling database configuration from model definitions in Python applications
Creating isolated unit and integration tests for database models
Managing complex database transactions with thread-safe BEGIN/COMMIT logic
