python
pip install SQLAlchemy
python
from sqlalchemy import create_engine
engine = create_engine('sqlite:///example.db', echo=True)
python
from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
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(name={self.name}, age={self.age})>"
python
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)
session = Session()
Base.metadata.create_all(engine)
user1 = User(name='Alice', age=25)
user2 = User(name='Bob', age=30)
session.add(user1)
session.add(user2)
session.commit()
users = session.query(User).all()
print(users)
user = session.query(User).filter_by(name='Alice').first()
user.age = 26
session.commit()
