def close_view(request):
session = DBSession()
task_id = int(request.matchdict['id'])
task = session.query(Task).filter_by(id=task_id).first()
task.closed = 1
session.add(task)
request.session.flash('Task was successfully closed!')
return HTTPFound(location=request.route_url('list'))
def validate_login(form, field):
log = DBSession.query(User).filter(User.login == field.data).first()
if log is None:
raise ValidationError("Enter correct login")
def validate_pass1(form, field):
log = DBSession.query(User).filter(User.login == form.login.data)\
.filter(User.password == field.data).first()
if log is None:
raise ValidationError("Enter a correct password")
def list_view(request):
session = DBSession()
tasks = session.query(Task).filter_by(closed=0).all()
#rs = session.execute("select id, name from tasks where closed = 0")
tasks = [dict(id=row.id, name=row.name) for row in tasks]
return {'tasks':tasks}
def validate_login(form, field):
log = DBSession.query(User).filter(User.login == field.data).first()
if log is not None:
raise ValidationError("This login is not available")
