发布功能完成。
- 编写要求登录的装饰器
from functools import wraps
def loginFirst(func): #参数是函数
@wraps(func)
def wrapper(*args, ** kwargs): #定义个函数将其返回
#要求登录
return func(*args, ** kwargs)
return wrapper #返回一个函数
- 应用装饰器,要求在发布前进行登录,登录后可发布。
@app.route('/question/',methods=['GET','POST'])
@loginFirst
def question():
- 建立发布内容的对象关系映射。
class Question(db.Model):
- 完成发布函数。
保存到数据库。
重定向到首页。
from flask import Flask, render_template, url_for, redirect, request,session from flask_sqlalchemy import SQLAlchemy from functools import wraps import config from datetime import datetime app = Flask(__name__) app.config.from_object(config) db = SQLAlchemy(app) class User(db.Model): __tablename__='user' id=db.Column(db.Integer,primary_key=True,autoincrement=True) username = db.Column(db.String(20), nullable=False) password = db.Column(db.String(20), nullable=False) nickname = db.Column(db.String(50)) class Question(db.Model): __tablename__='question' id = db.Column(db.Integer, primary_key=True, autoincrement=True) title =db.Column(db.String(100), nullable=False) detail = db.Column(db.Text, nullable=False) creat_time=db.Column(db.DateTime,default=datetime.now) author_id = db.Column(db.Integer,db.ForeignKey('user.id')) author=db.relationship('User',backref=db.backref('question')) #db.create_all() #db.create_all() #增加数据 #user=User(username = 'shanshan1',password = '111111') #db.session.add(user) #db.session.commit() #查询数据 #user=User.query.filter(user.username == 'shanshan1').first() #print(user.id,user.username,user.password) #修改数据 #user=User.query.filter(user.username == 'shanshan3').first() #user.password = '0000' #db.session.commit() #删除数据 #user=User.query.filter(user.username == 'shanshan3').first() #db.session.delete(user) #db.session.commit() @app.route('/') def index(): return render_template('shouye.html') @app.route( '/manhua') def manhua(): return render_template('manhua.html') @app.route('/login',methods=['GET','POST']) def login(): if request.method =='GET': return render_template('denglu.html') else: name = request.form.get('name') passw = request.form.get('password') user = User.query.filter(User.username == name).first() if user: if user.password==passw: session['user']=name return redirect(url_for('manhua')) else: return "密码错误!" else: return "用户名不存在!" @app.context_processor def mycontext(): usern=session.get('user') if usern: return {'name':usern} else: return {} @app.route('/logout') def logout(): session.clear() return redirect(url_for('manhua')) @app.route("/register",methods=['GET','POST']) def register(): if request.method == 'GET': return render_template("zhuce.html") else: name = request.form.get('name') passw = request.form.get('password') user = User.query.filter(User.username == name).first() if user: return "用户名已存在!" else: user = User(username=name, password=passw) db.session.add(user) db.session.commit() return render_template("denglu.html") def loginFirst(func): #行动前需要登录,定义装饰器 @wraps(func) def wrapper(*args,**kwargs): if session.get('user'): return func(*args,**kwargs) else: return redirect(url_for('login')) return wrapper @app.route('/wenda',methods=['GET','POST']) @loginFirst def wenda(): if request.method=='GET': return render_template('wenda.html') else: title=request.form.get('title') detail=request.form.get('fankui') author_id=User.query.filter(User.username==session.get('user')).first().id question=Question(title=title,detail=detail,author_id=author_id) db.session.add(question) # 数据库,添加操作 db.session.commit() return redirect(url_for('manhua')) if __name__ == '__main__': app.run(debug=True)
{% extends'shouye.html' %} {% block title %} wenda {% endblock %} {% block head %} <link rel="stylesheet" type="text/css" href="../static/css/wenda.css"> {% endblock %} {% block main %} <body> <div class="label"> <h1 style="color:pink", align="center"> 漫画问卷调查</h1> <form action="{{ url_for("wenda") }}" method="post"> <div class="q"> <label for="question">电影</label> <textarea id="question" cols="50" rows="1" name="title"></textarea> </div> <div class="form-group"> <label for="questionDetail">反馈</label> <textarea class="form-control" id="questionDetail" cols="50" rows="5" name="fankui"></textarea> </div> <br> <div class="input-area"> <button onclick="fnQuestion">发布</button> </div> </form> </div> {% endblock %} </body>