提示:本文中的代码缩进有问题,请自行更正后运行。
一、数据库初始化
1、创建连接
#文件名connect.py
from sqlalchemy import create_engine
HOSTNAME = '127.0.0.1'
PORT = '3306'
DATABASE = 'mydb'
USERNAME = 'admin'
PASSWORD = 'Root110qwe'
db_url = 'mysql+pymysql://{}:{}@{}/{}?charset=utf8'.format(USERNAME,PASSWORD,HOSTNAME,DATABASE)
engine = create_engine(db_url)
2、创建映像
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base(engine)
3、创建会话
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(engine)