sqlalchemy-repr

from sqlalchemy import create_engine, Column, Integer, String from sqlalchemy.orm import sessionmaker from sqlalchemy.ext.declarative import declarative_base from sqlalchemy_repr import ReprMixin # 1. Setup SQLAlchemy Base Base = declarative_base() # 2. Define a model with ReprMixin class User(ReprMixin, Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(String) email = Column(String) # Optional: Customize which attributes are shown in repr _repr_values = ['id', 'name'] # 3. Create an engine and tables engine = create_engine('sqlite:///:memory:') Base.metadata.create_all(engine) # 4. Create a session Session = sessionmaker(bind=engine) session = Session() # 5. Create and add an instance user1 = User(id=1, name='Alice', email='alice@example.com') user2 = User(id=2, name='Bob', email='bob@example.com') session.add_all([user1, user2]) session.commit() # 6. Demonstrate the custom repr retrieved_user = session.query(User).filter_by(name='Alice').first() print(f"User instance repr: {retrieved_user}") # Expected output (approx): User(id=1, name='Alice') # Clean up session.close()