shell
pip install SQLAlchemy
ini
python
from sqlalchemy import *
from sqlalchemy.orm import declarative_base
Base = declarative_base()
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(String)
email = Column(String)
python
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)
session = Session()
new_user = User(name='Alice', email='alice@example.com')
session.add(new_user)
session.commit()
python
users = session.query(User).all()
for user in users:
print(user.name, user.email)