def done_list(db): if not is_auth(): return redirect('/login') else: s = request.environ.get('beaker.session') user_id = s['user_id'] db.execute( "SELECT ID_tasks, Task FROM todo.tasks WHERE Status LIKE '0' AND ID_user = %s;", (user_id, )) rows = db.fetchall() return template('table', rows=rows, msg='')
def new_item(db): if not is_auth(): return redirect('/login') else: s = request.environ.get('beaker.session') user_id = s['user_id'] new = request.POST.task.strip() db.execute( "INSERT INTO todo.tasks(Task, Status, ID_user) VALUES (" "%s,%s,%s);", (new, 1, user_id)) msg = 'Задача успешно создана' return template("table", rows='', msg=msg)
def del_task(no, db): if not is_auth(): return redirect('/login') else: try: s = request.environ.get('beaker.session') user_id = s['user_id'] db.execute( "DELETE FROM todo.tasks WHERE ID_tasks = %s AND " "ID_user = %s;", (no, user_id)) msg = 'Задача успешно удалена' except: msg = 'Ошибка при удалении. Попробуйте еще раз' return template("table", rows='', msg=msg)
def edit_item(no, db): if not is_auth(): return redirect('/login') else: s = request.environ.get('beaker.session') user_id = s['user_id'] db.execute( "SELECT Task FROM todo.tasks WHERE ID_tasks = %s AND " "ID_user = %s;", (no, user_id)) cur_data = db.fetchone() return template('edit_task', old=list(cur_data.values())[0], no=no, csrf_token=gen_token)
def edit_item(no, db): if not is_auth(): return redirect('/login') else: s = request.environ.get('beaker.session') user_id = s['user_id'] edit = request.POST.task.strip() status = request.POST.status.strip() status = 1 if status == 'нужно сделать' else 0 db.execute( "UPDATE todo.tasks SET Task = %s, Status = %s WHERE ID_tasks = " "%s AND ID_user = %s;", (edit, status, no, user_id)) msg = f'Задача под номером {no} успешно обновлена' return template("table", rows='', msg=msg)
def new_item(): if not is_auth(): return redirect('/login') else: return template('new_task.tpl', csrf_token=gen_token)