Class User

benchmarks/test_sqlalchemy.py:26–48

# Define test models
class User(Base):
    __tablename__ = 'users'
    
    id = Column(Integer, primary_key=True)
    username = Column(String(50), unique=True, nullable=False)
    email = Column(String(100), unique=True, nullable=False)
    full_name = Column(String(100))
    age = Column(Integer)
    balance = Column(DECIMAL(10, 2), default=Decimal('0.00'))
    is_active = Column(Boolean, default=True)
    created_at = Column(DateTime, default=func.now())
    birth_date = Column(Date)
    bio = Column(Text)
    metadata_json = Column(JSON)
    
    # Relationships
    posts = relationship("Post", back_populates="author", cascade="all, delete-orphan")
    
    # Indexes
    __table_args__ = (
        Index('idx_username_email', 'username', 'email'),
        UniqueConstraint('username', 'email', name='unique_user_constraint'),
    )

class Post(Base):
    __tablename__ = 'posts'