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


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