flask插件的基本使用

from flask import Flask, render_template, redirect, url_for, request, flash, session
from flask_wtf import FlaskForm
from wtforms import StringField
from wtforms.validators import DataRequired
from flask_login import UserMixin, login_user
from flask_login import LoginManager, login_required, login_url, logout_user
from flask_sqlalchemy import SQLAlchemy
import redis
from flask_session import Session
from datetime import timedelta
from flask_migrate import Migrate, MigrateCommand
from flask_script import Manager

app = Flask(__name__)

'''
requirement

flask_script
flask_migrate
flask_sqlalchemy
flask_login
flask_wtf
flask_mysqldb
flask_session
redis



'''


class Config(object):
    """配置参数"""
    # 设置连接数据库的URL
    user = '*********'
    host = '***********'
    password = '*********'
    database = 'user'
    app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://%s:%s@%s:3306/%s' % (user, password, host, database)

    # 设置sqlalchemy自动更跟踪数据库
    SQLALCHEMY_TRACK_MODIFICATIONS = True

    # 查询时会显示原始SQL语句
    app.config['SQLALCHEMY_ECHO'] = True

    # 禁止自动提交数据处理
    app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN'] = False


# 读取配置
app.config.from_object(Config)

db = SQLAlchemy(app)

app.config['SESSION_TYPE'] = 'redis'  # session类型为redis
app.config['SESSION_PERMANENT'] = True  # 如果设置为False，则关闭浏览器session就失效。
app.config['SESSION_USE_SIGNER'] = True  # 是否对发送到浏览器上session的cookie值进行加密
app.config['SESSION_KEY_PREFIX'] = 'session:'  # 保存到session中的值的前缀
app.config['SESSION_REDIS'] = redis.Redis(host='************', port='6379',
                                          password="*******")  # 用于连接redis的配置
app.config['PERMANENT_SESSION_LIFETIME'] = timedelta(minutes=30)  # 配置7天有效
Session(app)
manager = Manager(app)
migrate = Migrate(app, db)
manager.add_command("db", MigrateCommand)


def create():
    # db.create_all()
    user = User(username="fanjf", password="123456")
    db.session.add(user)
    db.session.commit()


class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(64), index=True, unique=True)
    # email = db.Column(db.String(120), index=True, unique=True)
    password = db.Column(db.String(128))

    def __str__(self):
        return self.username + " :" + self.password


app.secret_key = "asdojofioasijdoias"
login_manager = LoginManager()

login_manager.login_view = '/login'  # 跳转到/首页目录
login_manager.login_message_category = 'info'
login_manager.login_message = 'Please login first!'
login_manager.session_protection = 'strong'  # 使用会话保护的模式。这可以是'basic'（默认）或'strong'，或None禁用
login_manager.init_app(app)


@login_manager.user_loader
def load_user(user_id):
    print("**************************")
    print(user_id)

    return User.query.get(int(user_id))


class MyForm(FlaskForm):
    username = StringField('username', validators=[DataRequired()])
    password = StringField('password', validators=[DataRequired()])


@app.route('/login', methods=['GET', 'POST'])
def login():
    form = MyForm()
    if request.method == 'POST':
        print("============")
        if form.validate_on_submit():

            username = form.username.data
            user = User.query.filter_by(username=username).first()
            print(user)
            print(user.is_authenticated)
            print(user.is_active)
            print(user.get_id())
            if user is not None and form.password.data == user.password:
                login_user(user)
                return redirect(url_for('index'))

        # 通过Flask-Login的login_user方法登录用户

    return render_template('login.html', form=form)


@app.route('/logout')
@login_required
def logout():
    logout_user()
    return 'Logged out successfully!'


@app.route("/", methods=('GET', 'POST'))
@login_required
def index():
    return render_template("index.html")


@app.route("/articles", methods=('GET', 'POST'))
@login_required
def articles():
    return render_template("articles.html")


@app.route("/article", methods=('GET', 'POST'))
@login_required
def article():
    return render_template("article.html")


@app.route("/link", methods=('GET', 'POST'))
@login_required
def link():
    return render_template("link.html")

@app.route("/message", methods=('GET', 'POST'))
@login_required
def message():
    return render_template("message.html")

@app.route("/diary", methods=('GET', 'POST'))
@login_required
def diary():
    return render_template("diary.html")


if __name__ == "__main__":
    #app.run("127.0.0.1", 80, True)
    # create()
     manager.run()