flask login 登陆的时候提示no attribute 'is_active'

Question

上代码 有知道的麻烦帮忙看下

all the imports

import os
import sqlite3
from flask import Flask, request, session, g, redirect, url_for, abort, \
render_template, flash
from flask.ext.login import login_user, logout_user, current_user, login_required,LoginManager,UserMixin
app=Flask(name)
login_manager = LoginManager()
login_manager.init_app(app)
login_manager.login_view="login"

from flask.ext.sqlalchemy import SQLAlchemy
db = SQLAlchemy(app)

class User(db.Model):
id = db.Column(db.Integer, primary_key = True)
username = db.Column(db.String(64), unique = True)
password= db.Column(db.String(120), unique = True)
def is_authenticated(self):
return True
def is_active(self):
return True
def is_anonymous(self):
return False
def get_id(self):
return unicode(self.id)
def repr(self):
return '' % (self.username)

@login_manager.user_loader
def load_user(id):
return User.query.get(int(id))

app.config.update(dict(
DATABASE=os.path.join(app.root_path, 'flaskr.db'),
DEBUG=True,
SECRET_KEY='development key',
USERNAME='admin',
PASSWORD='default'
))
app.config.from_envvar('FLASKR_SETTINGS', silent=True)

def connect_db():
"""Connects to the specific database."""
rv = sqlite3.connect(app.config['DATABASE'])
rv.row_factory = sqlite3.Row
return rv

def init_db():
"""Initializes the database."""
db = get_db()
with app.open_resource('schema.sql', mode='r') as f:
db.cursor().executescript(f.read())
db.commit()

'''@app.cli.command('initdb')
def initdb_command():
"""Creates the database tables."""
init_db()
print('Initialized the database.')

'''
def get_db():
"""Opens a new database connection if there is none yet for the
current application context.
"""
if not hasattr(g, 'sqlite_db'):
g.sqlite_db = connect_db()
return g.sqlite_db

@app.teardown_appcontext
def close_db(error):
"""Closes the database again at the end of the request."""
if hasattr(g, 'sqlite_db'):
g.sqlite_db.close()

@app.route('/')
@login_required
def show_entries():
db = get_db()
cur = db.execute('select title, text from entries order by id desc')
entries = cur.fetchall()
return render_template('show_entries.html', entries=entries)

@app.route('/add', methods=['POST'])
def add_entry():
if not session.get('logged_in'):
abort(401)
db = get_db()
db.execute('insert into entries (title, text) values (?, ?)',
[request.form['title'], request.form['text']])
db.commit()
flash('New entry was successfully posted')
return redirect(url_for('show_entries'))

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

def login():
error = None
if request.method == 'POST':
if request.form['username'] != app.config['USERNAME']:
error = 'Invalid username'
elif request.form['password'] != app.config['PASSWORD']:
error = 'Invalid password'
else:
session['logged_in'] = True
user=request.form['username']
login_user(user)
flash('You were logged in')
return redirect(url_for('show_entries'))
return render_template('login.html', error=error)

@app.route('/logout')
def logout():
session.pop('logged_in', None)
flash('You were logged out')
return redirect(url_for('show_entries'))
if name =="main":
app.run(host="0.0.0.0",port=8083,debug=True)

Answer 1

找到问题了，首先User 这个函数要这样定义
````
class User(db.Model):
tablename='user'
id = db.Column(db.Integer, primary_key = True)
username = db.Column(db.String(64), unique = True)
password = db.Column(db.String(120), index = True, unique = True)
#role = db.Column(db.SmallInteger, default = ROLE_USER)
#posts = db.relationship('Post', backref = 'author', lazy = 'dynamic')

def is_authenticated(self):
    return True

def is_active(self):
    return True

def is_anonymous(self):
    return False

def get_id(self):
    return unicode(self.id)

def __repr__(self):
    return '<User %r>' % (self.username)

```
然后保证qlite db中有user表 ，以及user表有admin这个账号
views.py 里面必须要有一个回调函数，返回用户的ID
@lm.user_loader def load_user(id): return User.query.get(int(id))