Flask -- 使用数据库(Sqlite3)、用户注册、登录注销、修改密码

---

 

# 使用sqlite数据库

import sqlite3
from contextlib import closing


app.config.update(
    DATABASE = 'my.db',      #相对于文件所在目录
    DEBUG=True,
)

def connect_db():
    return sqlite3.connect(app.config['DATABASE'])

def init_db():
    with closing(connect_db()) as db:
        with app.open_resource('schema.sql', 'r') as f:
            db.cursor().executescript(f.read())
        db.commit()

def get_db():
    db = connect_db()
    cur = db.cursor()
    return db, cur

---

# 用户注册

　from wtforms import Form, TextField, PasswordField, BooleanField, validators
　from passlib.hash import sha256_crypt

import gc

class RegistrationForm(Form):     使用flask-WTF表单系统，可以方便地使用逻辑（pip install flask-WTF）

    username = TextField('Username', [validators.Length(min=4, max=20)])
    email = TextField('Email', [validators.Length(min=6, max=50)])
    password = PasswordField('Password', [validators.Required(), validators.EqualTo('confirm', message='Passwords must match.')])
    confirm = PasswordField('Password Again')
    accept_tos = BooleanField("<small>I accept it</small>", [validators.Required()])


@app.route('/register/', methods=['POST', 'GET'])