pip install sqlalchemy
python
from sqlalchemy import create_engine
database_url = "sqlite:///mydatabase.db"
engine = create_engine(database_url)
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)
python
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)
session = Session()
python
users = session.query(User).filter(User.age > 18).all()
python
new_user = User(name="John", age=25)
session.add(new_user)
session.commit()
python
user = session.query(User).get(1)
user.name = "Tom"
session.commit()
python
user = session.query(User).filter(User.name == "John").first()
session.delete(user)
session.commit()
python
try:
session.commit()
except Exception as e:
session.rollback()
print("An error occurred:", str(e))