mybatis-plus-py 0.2.0

Python implementation of MyBatis-Plus: generic CRUD, fluent query builder, Pydantic-driven entity mapping, multi-dialect support, and pluggable middleware chain.

mybatis-plus-py

Python implementation of MyBatis-Plus: Pydantic-driven entity mapping, generic CRUD repositories, fluent query builder, multi-dialect support (SQLite / PostgreSQL / MySQL), Druid-style connection pool, and MyBatis-Plus style SQL interceptor pipeline.

Quick Start

pip install mybatis-plus-py
# with database driver extras
pip install mybatis-plus-py[postgres]  # or [mysql]

from pydantic import BaseModel
from mybatis_plus import entity, Field, Query, BaseRepository, SQLiteDataSource, EntitySession, SqlExecutor

@entity(table="users")
class User(BaseModel):
    id: int = Field(primary_key=True, auto_increment=True)
    name: str
    age: int = Field(default=18)

ds = SQLiteDataSource(":memory:")
session = EntitySession(SqlExecutor(ds))
session.create_table(User)
session.insert(User(name="Alice", age=30))

# Fluent query
adults = session.select_list(User, Query().gt("age", 18))

# Repository
repo = BaseRepository(User, session)
page = repo.select_page(Query().order_by("id"), page=1, size=10)

Database Support

Database	Driver	Datasource
SQLite	stdlib sqlite3	SQLiteDataSource
PostgreSQL	psycopg2	PostgresDataSource
MySQL	pymysql	MySQLDataSource

Key Features

• Entity mapping — @entity() + Field() with primary keys, auto-increment, version, soft delete, auto-fill
• Fluent query builder — Query().eq("name", "Tom").gt("age", 18).order_by("id")
• Generic CRUD — BaseRepository[T] with insert, update, delete, select, pagination
• Chain wrappers — ChainQuery(User, session).eq("age", 18).list()
• SQL interceptors — MyBatis-Plus style InnerInterceptor / MybatisPlusInterceptor pipeline with PaginationInnerInterceptor
• Connection pool — Druid-style pool with ExceptionSorter, ValidConnectionChecker, RemoveAbandoned, PreparedStatementPool
• Middleware — Tenant, logic delete, optimistic lock, auto-fill, block attack, dynamic table name

Architecture

Entity API / Repository / Chain / ActiveRecord
        -> EntitySession
        -> SqlBuilder + EntityMetaRegistry
        -> SqlExecutor
        -> MybatisPlusInterceptor + StatementHandler
        -> ParameterHandler / ResultSetHandler
        -> DataSource / Dialect

License

Apache-2.0