如何使用在官网上有详细记录 :http://flask-sqlalchemy.pocoo.org/2.3/
作为项目笔记,简单阐述使用方法:
1.创建flask_sqlalchemy基于sqlite的实例db
database.py:
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db'
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = True
db = SQLAlchemy(app)
2.建立model类,用于创建table/model
from <yourproject>.database import db
class Appinfor(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(50))
web_prod = db.Column(db.String(50))
web_test = db.Column(db.String(50))
app_prod = db.Column(db.String(50))
app_test = db.Column(db.String(50))
db_prod = db.Column(db.String(50))
db_test = db.Column(db.String(50))
site = db.Column(db.String(50))
3. view.py里的使用
调用model对象
from .models import Appinfor
from .database import db
@app.route('/', methods=['GET', 'POST'])
@app.route('/<int:page>', methods=['GET', 'POST'])
def index(page=1): db.create_all() #用来创建table,一般在初始化的时候调用
pagination = Appdetail.query.paginate(page, 20, False)
return render_template('index.html', pagination=pagination)