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)