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()