from flask import render_template, flash, redirect, session, url_for, request, g from flask.ext.login import login_user, logout_user, current_user, login_required from app import app, db, lm, models from forms import LoginForm from models import User
@app.route('/') @app.route('/index') @login_required def index (): user=g.user posts=[ {'author':{'nickname':'John'}, 'body':'Beautiful day in Portland!'}, {'author':{'nickname':'Susan'}, 'body':'The Avengers movie was so cool!'} ] return render_template("index.html", title="Home", user=user, posts=posts)
@app.route('/login', methods = ['GET', 'POST']) def login(): if g.user is not None and g.user.is_authenticated: return redirect(url_for('index')) form = LoginForm() if form.validate_on_submit(): if models.User.query.filter_by(nickname=form.openid.data).first(): user = User.query.filter_by(nickname=form.openid.data).first_or_404() login_user(user) return redirect(url_for('index')) else: return render_template('login.html', title = 'Sign In', error='[NO]', form = form) return render_template('login.html', title = 'Sign In', form = form)
# if g.user is not None and g.user.is_authenticated( ): 的判断用户是否登入,是否允许登入 # if models.User.query.filter_by(nickname=form.openid.data).first( ):判断输入与数据库里是否一致 #User.query.filter_by(nickname=form.openid.data).first_or_404( )如果输入与数据库不一致,请求返回404 #login_user( )是将用户登入(个人理解)
本文介绍了在使用Laravel和sqlsrv连接到SQL Server 2016时,如何在插入查询中使用输出子句,并返回所需的值。同时讨论了使用CreatedOn字段返回最近创建的行的解决方法以及使用Eloquent模型创建后,值正确插入数据库但没有返回uniqueidentifier字段的问题。最后给出了一个示例代码。 ...
[详细]