flask-sqlalchemy实例

main

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__,template_folder='template', static_url_path='/', static_folder='resource')
app.config['SECRET_KEY'] = os.urandom(24)


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


if __name__ == '__main__':
    from controler.user import *
    app.register_blueprint(user)
    app.run()

user

from module.users import Sign
from flask import Blueprint,request

from sqlalchemy12 import db
from sqlalchemy import Table, MetaData
from sqlalchemy12 import db  #直接引用全局变量

user  = Blueprint('user',__name__)

@user.route('/qd',methods=['GET', 'POST', 'PUT'])
def user_demo():
    stu = request.form.get('id')
    sign = Sign()
    obj = sign.find_user_by_id(stu)
    obj2 = Sign(student_id = obj)
    db.session.add(obj2)
    db.session.commit()
    return obj

users

from sqlalchemy import Table, MetaData
from sqlalchemy12 import db  #直接引用全局变量



class Sign(db.Model):
    __table__ = Table('sign',MetaData(bind = db.engine),autoload = True)

    def find_user_by_id(self,id):
        global x
        row = db.session.query(Sign.student_id).filter_by(id=id).first()
        for c in row:
            x = c
        print(x)
        return x