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")