1. 在 __init__.py中創建db對象from flask_sqlalchemy import SQLAlchemy# 包含了SQLAlchemy相關的所有操作db = SQLAlchemy()2. 在 __init__.py中create_app函數中讓將app傳入到db中def create_app():app = Flask(__name__)app.config.from_object('settings.DevelopmentConfig')from .views.account import acapp.register_blueprint(ac)# 看這里看這里db.init_app(app)return app3. 寫配置文件，將連接字符串定義在配置文件中SQLALCHEMY_DATABASE_URI = "mysql+pymysql://root:123456@127.0.0.1:SQLALCHEMY_POOL_SIZE = 5SQLALCHEMY_POOL_TIMEOUT = 30SQLALCHEMY_POOL_RECYCLE = -14. 定義 models.py#!/usr/bin/env python# -*- coding:utf-8 -*-from sqlalchemy.ext.declarative import declarative_basefrom sqlalchemy import Column, Integer, String, UniqueConstraint,from s8day130_pro import dbclass Users(db.Model):__tablename__ = 'users'id = Column(Integer, primary_key=True,autoincrement=True)name = Column(String(32),nullable=False,unique=True)5. 創建數據庫表，編寫離線腳本，：drop_create_table.py ############################# 重點 from s8day130_pro import dbfrom s8day130_pro import create_appfrom s8day130_pro import modelsapp = create_app()with app.app_context():db.drop_all()db.create_all()#data = db.session.query(models.Users).all()#print(data)6. 在視圖函數中使用SQLAlchemy操作數據庫from s8day130_pro import modelsfrom s8day130_pro import dbac = blueprints.Blueprint('ac',__name__)@ac.route('/login',methods=['GET','POST'])def login():data = db.session.query(models.Users).all()print(data)db.session.remove()return 'Login'?
，read()，waitKey()的使用)
