Skip to content

Latest commit

 

History

History
40 lines (26 loc) · 1.06 KB

README.md

File metadata and controls

40 lines (26 loc) · 1.06 KB

sqlalchemy-events

CI

Helper for handling sqlalchemy events

Installation

Use the package manager pip to install sqlalchemy-events.

pip install sqlalchemy-events

Usage

from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy_events import listen_events, on

Base = declarative_base()


@listen_events
class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True, autoincrement=True)
    username = Column(String, nullable=False, unique=True)

    @on("before_insert")
    def lowercase_username(mapper, conn, self):
        self.username = self.username.lower()

List available mapper events is described at sqlalchemy docs

License

MIT