flask-sqlalchemy and sqlalchemy

flask-sqlalchemy基本连接

import os
from sqlalchemy import create_engine, MetaData, Table
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import  sessionmaker,session,scoped_session
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import pymysql
pymysql.install_as_MySQLdb()

#app.config['select_key'] = 'sss'
app = Flask(__name__)
app.config['SECRET_KEY'] = os.urandom(24)


#使用集成方式处理SQLALCHEMY
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:020804@127.0.0.1:3305/s8day128db?charset=utf8'
# 【手动增加配置选项】关于使用SQLALCHEMY 出现warning 的问题解决
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False  #跟踪数据库的修改，及时发送信号
#实例化db对象
db =  SQLAlchemy(app)

sqlalchemy基本连接

from sqlalchemy import create_engine, MetaData, Table
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import  sessionmaker,session,scoped_session

engine = create_engine("mysql+pymysql://root:020804@127.0.0.1:3305/s8day128db?charset=utf8",max_overflow=5)
#定义模型类继承的父亲及数据连接会话
DBsession = sessionmaker(bind=engine)
dbsession = scoped_session(DBsession)
Base = declarative_base()
md = MetaData(bind=engine)