发布功能完成。
- 编写要求登录的装饰器
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 functools import wraps from flask import Flask,render_template,request,redirect,url_for,session from flask_sqlalchemy import SQLAlchemy from datetime import datetime import config 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) class Question(db.Model): __tablename__='fabu' id=db.Column(db.Integer,primary_key=TabError,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('fabu')) #创建表格 #db.create_all() #数据的添加方法 #user=User(username='kobe24',password='666666') #db.session.add(user) #db.session.commit() #数据的查询方法 #user=User.query.filter(User.username =='kobe24').first() #print(user.username,user.password) # 数据的修改方法 #user = User.query.filter(User.username=='kobe24').first #user.password='123456' #db.session.commit() # 数据的删除方法 #user = User.query.filter(User.username=='kobe24').first() #db.session.delete(user) #db.session.commit() @app.route('/') def hello_world(): return render_template('base.html') @app.route('/login/',methods=['GET','POST']) def login(): if request.method == 'GET': return render_template('login.html') else: username = request.form.get('username') # 获取form中的数据 password = request.form.get('password') user = User.query.filter(User.username == username).first() if user: if user.password == password: session['user'] = username session.permanent = True return redirect(url_for('base')) # 返回到首页 else: return u'error username or password' # 输出错误 @app.route('/regist/',methods=['GET','POST']) def regist(): if request.method == 'GET': return render_template('regist.html') else: username = request.form.get('username') password = request.form.get('password') user = User.query.filter(User.username == username).first() # 判断用户名是否存在 if user: return u'username existed' else: user = User(username=username, password=password) db.session.add(user) db.session.commit() return redirect(url_for('login')) @app.context_processor def mycontext(): username=session.get('user') if username: return {'username':username} else: return{} @app.route('/logout') def logout(): session.clear() return redirect(url_for('base')) # 进入问答界面先登录功能 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('/fabu/',methods=['GET','POST']) def fabu(): if request.method == 'GET': return render_template('fabu.html') else: title = request.form.get('title') detail = request.form.get('detail') author_id = User.query.filter(User.username == session.get('user')).first().id fabu = Question(title=title, detail=detail, author_id=author_id) db.session.add(fabu) db.session.commit() return redirect(url_for('base')) if __name__ == '__main__': app.run(debug=True)
{% extends'base.html' %} {% block fabutitle %}{% endblock %} {% block fabuhead %}{% endblock %} {% block fabumain %} <div class="form-group"> <h1>发布问答</h1> <form action="{{ url_for('fabu') }}" method="post"> <label for="questionDetail">问题</label><br> <textarea class="form-control" rows="1" cols="50" id="questionDetail"></textarea><br> <label for="questionDetail">详情</label><br> <textarea class="form-control" rows="5" cols="50" id="questionDetail"></textarea><br> <button type="button">发布问答</button> </form> </div> {% endblock %}