sqla-paranoid 0.1.1

安装

pip install sqla-paranoid

使用

from paranoid.models import (
    Model,
    Query,
    Session,
)

class User(Model):
    __tablename__ = 'user'
    __softdelete__ = True

    id = Column(Integer, primary_key=True)
    name = Column(String)


engine = create_engine('sqlite://')
session = sessionmaker(engine, class_=Session, query_cls=Query)()

session.query(User)

Flask

Paranoid附带一个基于Flask-SQLAlchemy的Flask扩展，可直接使用

from paranoid.flask import SQLAlchemy


db = SQLAlchemy(app)

Model = db.Model


class User(Model):
    __softdelete__ = True

    id = Column(Integer, primary_key=True)
    name = Column(String)

User.query