Flask之Flask-sqlalchemy模块的导入方式

from flask import Flask,render_template,request,redirect
#SQLALchemy
from flask_sqlalchemy import SQLAlchemy
import os ,datetime

app = Flask(__name__)
1、数据库路径
basedir = os.path.abspath(os.path.dirname(__file__))
#print(__file__) #D:/flask/blog/models.py
#print(os.path.dirname(__file__))  #D:/flask/blog
#print(basedir)  #D:\flask\blog

2、实例化数据库连接

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///' +os.path.join(basedir,'blog.sqlite')
app.config['SQLALCHEMY_COMMIT_TEARDOWN'] = True
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True

3.每次请求结束后，都会提交数据库变动

app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = True

4.创建SQLAlchemy
db = SQLAlchemy(app)

5.文章类
class Article(db.Model):
	__tablename__ = 'article'
	id = db.Column(db.Integer,primary_key = True)
	title = db.Column(db.String(32))
	picture = db.Column(db.String(32))
	time = db.Column(db.DATETIME) #时间
	descript