- 编写要求登录的装饰器
from functools import wraps
def loginFirst(func): #参数是函数
@wraps(func)
def wrapper(*args, ** kwargs): #定义个函数将其返回
#要求登录
return func(*args, ** kwargs)
return wrapper #返回一个函数
def log(func): #参数是函数
@wraps(func)
def wrappers(*args,** kwargs): #定义个函数将其返回
if session.get('user'):
return func(*args,**kwargs)
else:
return redirect(url_for('denglu'))
return wrappers #返回一个函数
- 应用装饰器,要求在发布前进行登录,登录后可发布。
@app.route('/question/',methods=['GET','POST'])
@loginFirst
def question():
@app.route('/wenda/',methods=['GET','POST'])
@log
def wenda():
if request.method=='GET':
return render_template('wenda.html')
else:
title=request.form.get('title')
detail=request.form.get('detail')
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('shouye'))#跳转
- 建立发布内容的对象关系映射。
class Question(db.Model):
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)
create_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'))
- 完成发布函数。
保存到数据库。
重定向到首页。
py主文件代码
from flask import Flask, render_template,request,redirect,url_for,session
from flask_sqlalchemy import SQLAlchemy
import config
from functools import wraps
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(100), nullable=False)
password= db.Column(db.String(500), nullable=False)
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)
create_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()
# # 增加
# user = User(username = 'zhuyinyin',password='113428164508')
# db.session.add(user)
# db.session.commit()
# 修改
# ser=User.query.filter(User.username =='zhuyinyin').first()
# user.password='123'
# print(user.username,user.password)
# db.session.commit()
#查询:
# User.query.filter(User.username == 'zhuyinyin').first()
# print(user.username,user.password)
# db.session.commit()
# 修改:
# user.password = '111111'
# db.session.commit()
# 删除:
# db.session.delete(user)
# db.session.commit()
@app.route('/')
def hello_world():
return render_template('ba.html')
@app.route('/zhuce/',methods=['GET','POST'])
def zhuce():
if request.method == 'GET':
return render_template('zhuce.html')
else:
username = request.form.get('username') # 获取form中的数据
password = request.form.get('password') # 获取form中的数据
# email = request.form.get('email') # 获取form中的数据
user = User.query.filter(User.username ==username).first()
if user:
return'用户已存在'
else:
user = User(username = username,password=password)
db.session.add(user)
db.session.commit()
return redirect(url_for('denglu'))
# @app.route('/denglu/',methods=['GET','POST'])
# def denglu():
# if request.method=='GET':
# return render_template('denglu.html')
# else:
# username=request.form.get('username')
# password=request.form.get('password')
# user=User.query.filter(User.username==username,User.password==password).first()
# #判断用户名是否存在
# if user:
# if user.password==password:
# return redirect(url_for('shouye'))
# else:
# return '密码错误'
# else:
# return '用户不存在'
#第二种写法
@app.route('/denglu/',methods=['GET','POST'])
def denglu():
if request.method=='GET':
return render_template('denglu.html')
else:
username = request.form.get('username')
password = request.form.get('password')
user=User.query.filter(User.username==username).first()
#判断用户名是否存在
if user:
session['user']=username
session.permanent=True
if user.password==password:
return redirect(url_for('shouye'))
else:
return '密码错误'
else:
return '此用户不存在'
@app.context_processor
def mycontext():
usern=session.get('user')
if usern:
return {'username':usern}
else:
return{}
@app.route('/logout/')
def logout():
session.clear();
return redirect(url_for('shouye'))
def log(func): #参数是函数
@wraps(func)
def wrappers(*args,** kwargs): #定义个函数将其返回
if session.get('user'):
return func(*args,**kwargs)
else:
return redirect(url_for('denglu'))
return wrappers #返回一个函数
@app.route('/shouye/')
def shouye():
return render_template('shouye.html')
@app.route('/wenda/',methods=['GET','POST'])
@log
def wenda():
if request.method=='GET':
return render_template('wenda.html')
else:
title=request.form.get('title')
detail=request.form.get('detail')
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('shouye'))#跳转
if __name__ == '__main__':
app.run(debug=True)
问答页面html代码如下:
{% extends 'ba.html' %} {% block title %} 问答平台 {% endblock %} {% block main %} <link rel="stylesheet" type="text/css" href="../static/css/wenda.css"> <form action="{{ url_for('wenda') }}" method="post"> <div class="box"> <div id="title"><h2 align="center">反馈</h2></div> <div> <label for="questionDetail">问题:</label><br> <textarea class="form-control" id="questionDetail" rows="2" style="width: 500px"name="title"></textarea><br> <label for="result">意见:</label><br> <textarea class="form-control" id="result" rows="4" style="width: 500px" name="detail"></textarea><br> </div> <div id="error_box"><br></div> <div class="input_button"> <button type="submit" onclick="foLogin()">提交</button> </div> </div> </form> {% endblock %}
运行结果: