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

1.准备连接

engine = create_engine(‘mysql+pymysql://root:123456@127.0.0.1:3306/my_sql?charset = utf8’,echo=True)

2.声明ORM模型的基类

Base = declarative_base()

3.实现ORM模型类

class student(Base):
""“学生信息表”""
tablename = 'student’
id = Column(type_=Integer,name=‘id’,primary_key=True)
stu_no = Column(Integer,nullable=False,comment=‘学号’)
stu_name = Column(String(16),nullable=False,comment=‘姓名’)
created_at = Column(DateTime)

4.同步数据库表

def create_table():
""“需要手动创建数据库，不需要手动创建表”""
# 创建表
Base.metadata.create_all(bind=engine)
# 删除表
# Base.metadata.drop_all(bind=engine)
pymysql.install_as_MySQLdb()