from flask import Flask,render_template,request,redirect,url_for,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(20))
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(20))
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()
# user=User(username='mis1234',password='111111')
# db.session.add(user)
# db.session.commit()
@app.route('/')
def index():
context={
'questions': Question.query.all()
}
return render_template("index.html")
@app.route('/login/', methods=['GET', 'POST'])
def login():
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:
if user.password == password:
session['user'] = username
session.permanent = True
return redirect(url_for('base'))
else:
return '密码错误'
else:
return '用户名不存在'
@app.route('/regist/', methods=['GET', 'POST'])
def zhuce():
if request.method == 'GET':
return render_template("register.html")
else:
username = request.form.get('username')
password = request.form.get('password')
nickname = request.form.get('nickname')
user = User.query.filter(User.username == username).first()
if user:
return '用户名已存在'
else:
user = User(username=username, password=password, nickname=nickname)
db.session.add(user) # 数据库,添加操作
db.session.commit()
return redirect(url_for('login'))
# @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('index'))
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'])
@loginFirst
def fabu():
if request.method=='GET':
return render_template('question.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('base'))
def fabu():
return render_template('question.html')
if __name__=='__main__':
app.run(debug=True)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<link rel="stylesheet" type="text/css" href="../static/css/details.css">
</head>
<body>
<div>
<h1>python,url_for</h1>
<h3>mis1212</h3>
</div>
<div>
<h2>python,url_for</h2>
</div>
<div >
<lebal><input type="text" width="200"></lebal><br>
<input class="one" type="button" name="发送" value="发送">
</div>
评论:
<p class="inset">评论一</p>
<p class="inset">评论二</p>
<p class="inset">评论三</p>
<p class="inset">评论四</p>
</body>
</html>