Simple ORM BaseModel for Flask depends on SqlAlchemy


License
MIT
Install
pip install pyco-sqlalchemy==1.2.3

Documentation

pyco-sqlalchemy

Using CoModel to make SqlAlchemy's ORM even simpler for humans, develop with Flask/Django/OtherWebFrames.

note: 不管在使用任何 web 框架, 我都希望能有统一的 ORM 查询接口, 且易于在不同的数据库间迁移.

Tips:

Samples

  • flask
from pyco_sqlalchemy._flask import BaseModel, db

class User(db.Model, BaseModel):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(32))
    email = db.Column(db.String(64), unique=True)
     

form = dict(name="dev")
u1 = User.insert(form, email="dev@pypi.com")
u3 = User.upsert_one(form, email="dev@oncode.cc")
assert u1.id == u3.id