sqlachemy专题

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import declarative_base

mysql_connection_string = "mysql+pymysql://root:123456@localhost:3306/test"
engine = create_engine(mysql_connection_string)

Base = declarative_base()

class Building(Base):
    __tablename__ = "building"
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String(50))

Base.metadata.create_all(engine)

from sqlalchemy.orm import sessionmaker
from sc1 import myengine, Building

# 创建会话
sessionmaker = sessionmaker(bind=myengine)
session = sessionmaker()

# crud操作
# 创建 操作
# building = Building(name="building1")
# session.add(building)
# session.commit()

# 查询  操作
building = session.query(Building).all()
for x in building:
    print(x.id, x.name)