SQLBatis

SQLBatis provides an easier way to interact with the database through the raw sql.

Requirements

• SQLAlchemy-Core
• Alembic

Installation

Install SQLBatis with command pip:

pip install sqlbatis

Tutorial

• Setup your DB first
  • Define a Model
  • Scan all the models
  • Initialize the tools
  • Generate the scripts
  • Sync the DB
• Let’s talk with DB in your app
  • Connect to the DB
  • Execute the raw sql with @db.query
  • Insert or update bulk records
  • Paginate query with SQLBatis
• Execute the Query in a transaction
• Builtin Database Access Operations
  • CRUD operations
  • Bulk insert

Reference

• API
  • sqlbatis.cli
  • sqlbatis.connection
  • sqlbatis.container
  • sqlbatis.errors
  • sqlbatis.model
  • sqlbatis.page_query_builder
  • sqlbatis.row
  • sqlbatis.scanner
  • sqlbatis.sqlbatis
  • sqlbatis.sqlbatis_dao
  • sqlbatis.utils
• Dependency injection
  • @entity
  • __autowired__
  • SQLBatisMetaClass
  • SQLBatisContainer

ChangeLog