base.html:

{% extends 'bootstrap/base.html' %}{% block styles %} {{ super() }} <link rel='stylesheet' href='http://m.b3g6.com/static/css/main.css' rel='external nofollow' >{% endblock %}{% block navbar %} <nav class='navbar navbar-default'> <div class='container-fluid'> <!-- Brand and toggle get grouped for better mobile display --> <div class='navbar-header'><button type='button' data-toggle='collapse' data-target='#bs-example-navbar-collapse-1' aria-expanded='false'> <span class='sr-only'>Toggle navigation</span> <span class='icon-bar'></span> <span class='icon-bar'></span> <span class='icon-bar'></span></button><a href='http://m.b3g6.com/bcjs/index.html' rel='external nofollow' ></a> </div> <!-- Collect the nav links, forms, and other content for toggling --> <div id='bs-example-navbar-collapse-1'><ul class='nav navbar-nav'> <li><a href='http://m.b3g6.com/bcjs/4303.html#' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' ></a></li> <li><a href='http://m.b3g6.com/bcjs/4303.html#' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' ></a></li> <li><a href='http://m.b3g6.com/bcjs/4303.html#' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' >首頁(yè)<span class='sr-only'>(current)</span></a></li> <li><a href='http://m.b3g6.com/bcjs/4303.html#' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' >新聞</a></li> <li><a href='http://m.b3g6.com/bcjs/4303.html#' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' >國(guó)際</a></li> <li><a href='http://m.b3g6.com/bcjs/4303.html#' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' >國(guó)內(nèi)</a></li> <li><a href='http://m.b3g6.com/sysinfo/' rel='external nofollow' >系統(tǒng)信息</a></li> <li><a href='http://m.b3g6.com/bcjs/4303.html#' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' rel='external nofollow' >登陸用戶</a></li></ul><ul class='nav navbar-nav navbar-right'> {% if ’user’ in session %} <li><a href='http://m.b3g6.com/bcjs/login.html' rel='external nofollow' ><span class='glyphicon glyphicon-user'></span> &nbsp;&nbsp; {{ session.user }}</a></li> <li><a href='http://m.b3g6.com/logout/' rel='external nofollow' ><span class='glyphicon glyphicon-log-in'></span> &nbsp;&nbsp; 注銷(xiāo) </a></li> {% else %} <li><a href='http://m.b3g6.com/login/' rel='external nofollow' ><span class='glyphicon glyphicon-log-in'></span> &nbsp;&nbsp;登陸</a></li> <li><a href='http://m.b3g6.com/register/' rel='external nofollow' ><span class='glyphicon glyphicon-log-out'></span> &nbsp;&nbsp;注冊(cè)</a></li> {% endif %}</ul> </div><!-- /.navbar-collapse --> </div><!-- /.container-fluid --> </nav>{% endblock %}{% block content %} {#定義屬于自己的block#} {% block newcontent %} {% endblock %} {% block footer %} <div class='footer'> 京ICP備11008151號(hào)京公網(wǎng)安備11010802014853 </div> {% endblock %}{% endblock %}

list.html:

{% extends ’base.html’ %}{% block newcontent %} <div class='row'> <div class='col-md-6 col-md-offset-3'> /*添加任務(wù)*/ <form action='/todo/add/' method='post'><div class='form-group'> {# 添加框 #} <div class='col-sm-9'> <input type='text' placeholder='請(qǐng)?zhí)砑尤蝿?wù)' required='required'name='todo_name'> </div> {# 選擇框 #} <div class='col-sm-2'> <select name='part'> {% for part in parts %}<option value='{{ part.id }}'>{{ part.name }}</option> {% endfor %} </select> </div> {# 添加的按鈕 #} <div class='col-sm-1'> <input type='submit' value='添加任務(wù)'> </div></div> </form> /*任務(wù)顯示*/ <h1>添加任務(wù)</h1> <table class='table table-bordered'><tr> <td>任務(wù)內(nèi)容</td> <td>創(chuàng)建時(shí)間</td> <td>狀態(tài)</td> <td>所屬部門(mén)</td> <td>操作</td></tr>{% for todo in todos %} <tr> <td>{{ todo.name }}</td> <td>{{ todo.add_time }}</td> {# #} <td> {% if todo.status %} <a href='http://m.b3g6.com/todo/undo/{{ todo.id }}/' rel='external nofollow' role='button'><span class='glyphicon glyphicon-ok'></span> 已完成</a> {% else %}<a href='http://m.b3g6.com/todo/done/{{ todo.id }}/' rel='external nofollow' role='button'><span class='glyphicon glyphicon-remove'></span> 未完成</a> {% endif %} </td> <td>{{ todo.department.name }}</td> <td><a href='http://m.b3g6.com/todo/delete/{{ todo.id }}/' rel='external nofollow' role='button'><span class='glyphicon glyphicon-remove'></span> 刪除</a></td> </tr>{% endfor %} </table> </div> </div>{% endblock %}

models.py:

from datetime import datetimefrom flask import Flaskfrom flask_sqlalchemy import SQLAlchemyfrom flask_bootstrap import Bootstrapapp = Flask(__name__)app.config[’SQLALCHEMY_DATABASE_URI’] = ’mysql+pymysql://root:971203@localhost/Todo’# SQLAlchemy 將會(huì)追蹤對(duì)象的修改并且發(fā)送信號(hào)。app.config[’SQLALCHEMY_TRACK_MODIFICATIONS’] = Truedb = SQLAlchemy(app)bootstrap = Bootstrap(app)app.config[’SECRET_KEY’] = ’westos’# 1). 面向?qū)ο蠓绞絼?chuàng)建表# 2). 分析關(guān)系:# 部門(mén)和用戶: 一對(duì)多# 用戶和任務(wù): 一對(duì)多的關(guān)系# 用戶和用戶登錄日志: 一對(duì)多的關(guān)系# 實(shí)現(xiàn)一對(duì)多(Role(1): User(n))的關(guān)系# - 多的一端寫(xiě)外鍵# - 少的一端寫(xiě)反向引用class User(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) # unique:用戶名唯一, nullable=False指用戶名不能為空; name = db.Column(db.String(50), unique=True, nullable=False) pwd = db.Column(db.String(100)) email = db.Column(db.String(30), unique=True) phone = db.Column(db.String(30), unique=True) info = db.Column(db.Text) # 個(gè)人簡(jiǎn)介 add_time = db.Column(db.DateTime, default=datetime.now()) # 創(chuàng)建時(shí)間 department_id = db.Column(db.Integer, db.ForeignKey(’department.id’)) todos = db.relationship(’Todo’, backref=’user’) userlogs = db.relationship(’Userlog’, backref=’user’) # 部門(mén)id與其他表關(guān)聯(lián)，不能隨便寫(xiě) def __repr__(self): return ’<User: %s>’ %(self.name)# 部門(mén)class Department(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) name = db.Column(db.String(50), unique=True, nullable=False) # 反向引用: user就包含一個(gè)屬性， department users = db.relationship(’User’, backref=’department’) todos = db.relationship(’Todo’, backref=’department’) def __repr__(self): return ’<Department: %s>’ %(self.name)class Todo(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) name = db.Column(db.String(200), nullable=False) add_time = db.Column(db.DateTime, default=datetime.now()) # 創(chuàng)建時(shí)間 status = db.Column(db.Boolean, default=False) # 任務(wù)狀態(tài)， 默認(rèn)為Flase(未完成) department_id = db.Column(db.Integer, db.ForeignKey(’department.id’)) user_id = db.Column(db.Integer,db.ForeignKey(’user.id’) ) def __repr__(self): return ’<Todo: %s>’ % (self.id)# 用戶登錄日志class Userlog(db.Model): id = db.Column(db.Integer, autoincrement=True, primary_key=True) add_time = db.Column(db.DateTime, default=datetime.now()) # 創(chuàng)建時(shí)間 ip = db.Column(db.String(200), nullable=False) # 登錄ip area = db.Column(db.String(200)) # 用戶登錄地點(diǎn) user_id = db.Column(db.Integer, db.ForeignKey(’user.id’)) # 外鍵 def __repr__(self): return ’<Userlog: %s>’ % (self.ip)

views.py:

from flask import render_template, request, redirect, url_for, sessionfrom models import app, Todo, db, Department,Userfrom mDB import isPasswdOk,isUserExist,addUserfrom forms import LoginForm,RegisterForm@app.route(’/’)def index(): return render_template(’base.html’)@app.route(’/register/’)def register(): form = RegisterForm() if form.validate_on_submit(): user = request.form(’user’) passwd = request.form(’passwd’) return render_template(’register.html’)@app.route(’/login/’,methods=[’GET’,’POST’])def login(): form = LoginForm() # 如果是post方法并且表單驗(yàn)證通過(guò)的話， 返回True; if form.validate_on_submit(): # 1). 獲取用戶提交的表單信息 # print(form.data) 是字典類型， 內(nèi)容如下: # {’user’: ’westos’, ’passwd’: ’westos’, ’submit’: True } user = form.data[’user’] passwd = form.data[’passwd’] # 2. 判斷用戶名和密碼是否正確 if isPasswdOk(user, passwd): # 將用戶名和密碼信息存儲(chǔ)到session中; session[’user’] = user session[’passwd’] = passwd # 如果登陸成功, 跳轉(zhuǎn)到主頁(yè); return redirect(url_for(’todo_list’)) else: # 如果登陸失敗, 重新登陸; return render_template(’login.html’,form=form, message='用戶名或者密碼錯(cuò)誤') return render_template(’login.html’, form=form)@app.route(’/logout/’)def logout(): session.pop(’user’,None) session.pop(’passwd’,None) return redirect(url_for(’todo_list’))# 任務(wù)的增刪改查@app.route(’/todo/add/’, methods=[’POST’])def todo_add(): # 獲取提交的任務(wù)信息 name = request.form[’todo_name’] part = request.form[’part’] # 添加完成之后， 返回任務(wù)列表顯示頁(yè)面 u = User.query.filter_by(name=session[’user’]).first() id = u.id todo = Todo(name=name, department_id=part, user_id=id) db.session.add(todo) db.session.commit() return redirect(url_for(’todo_list’))@app.route(’/todo/delete/<int:id>/’)def todo_delete(id): u = Todo.query.filter_by(id=id).first() db.session.delete(u) db.session.commit() return redirect(url_for(’todo_list’))@app.route(’/list/’)def todo_list(): # 1). 從數(shù)據(jù)庫(kù)中查詢 todos = Todo.query.all() parts = Department.query.all() return render_template(’list.html’, todos = todos, parts=parts)# 修改任務(wù)的狀態(tài)(變成已完成狀態(tài)/變成未完成狀態(tài))@app.route(’/todo/undo/<int:id>/’)def undo(id): todo = Todo.query.filter_by(id=id).first() todo.status = False db.session.commit() # 更新?tīng)顟B(tài)后， 返回任務(wù)列表頁(yè) return redirect(url_for(’todo_list’))@app.route(’/todo/done/<int:id>/’)def done(id): todo = Todo.query.filter_by(id=id).first() todo.status = True db.session.commit() # 更新?tīng)顟B(tài)后， 返回任務(wù)列表頁(yè) return redirect(url_for(’todo_list’))

run.py:

# 項(xiàng)目真實(shí)運(yùn)行腳本from models import app,db# 導(dǎo)入編寫(xiě)的視圖函數(shù)和路由from views import *app.run()

以上這篇python 實(shí)現(xiàn)任務(wù)管理清單案例就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持好吧啦網(wǎng)。