pip install sqlalchemy
python
from sqlalchemy import create_engine
engine = create_engine('sqlite:///mydatabase.db')
engine = create_engine('mysql://username:password@hostname:port/database')
engine = create_engine('postgresql://username:password@hostname:port/database')
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)
email = Column(String)
python
Base.metadata.create_all(engine)
python
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)
session = Session()
users = session.query(User).all()
new_user = User(name='John Doe', email='johndoe@example.com')
session.add(new_user)
session.commit()
user = session.query(User).filter_by(name='John Doe').first()
user.email = 'johndoe@gmail.com'
session.commit()
user = session.query(User).filter_by(name='John Doe').first()
session.delete(user)
session.commit()