pip install SQLAlchemy pip install mysql-connector-python python from sqlalchemy import create_engine python from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column, Integer, String Base = declarative_base() class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(String) age = Column(Integer) def __repr__(self): return f"User(id={self.id}, name='{self.name}', age={self.age})" python from sqlalchemy.orm import sessionmaker Session = sessionmaker(bind=engine) session = Session() users = session.query(User).all() users = session.query(User).filter(User.age > 18) users = session.query(User).order_by(User.age.desc()) users = session.query(User).filter(User.age > 18).order_by(User.age.desc()).all() for user in users: print(user) python session.close()


上一篇:
下一篇:
切换中文