from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column,Integer,String
# 1.创建数据库引擎,链接数据库
engine = create_engine('mysql+pymysql://root:123456@127.0.0.1:3306/sqlalchemy_s14?charset=utf8')
# 2.创建ORM基类
Base = declarative_base()
# 3.创建表
class Account(Base):
__tablename__ = 'account'
id = Column(Integer, primary_key=True)
name = Column(String(32), nullable=False, unique=True)
age = Column(Integer)
gender = Column(String(32))
# 4.将所有继承Base的类序列化成数据表
Base.metadata.create_all(engine)
# Base.metadata.drop_all(engine)
1.增加
from sqlalchemy.orm import sessionmaker
from more_crud.create_table01 import engine,Account
# 1.创建session会话窗口,用于操作数据库中的数据表
Session = sessionmaker(bind=engine)
db_session = Session()
# 2.批量新增数据
account_all = [Account(name="杨幂",age=27,gender="女"),Account(name="迪丽热巴",age=25,gender="女"),Account(name