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


上一篇:
下一篇:
切换中文