Beispiel #1
0
def save_todo(context: 'micro_context',
              description: str,
              done: datetime=None,
              todo_id: int=None) -> dict:
    '''
        creates or updates a todo
        broadcasts: SAVED_TODO
        returns: {
            id: int,
            person_id: int,
            description: str,
            created: datetime,
            done: datetime
        }
    '''
    with context.session as session:
        user = context.get_user(session)
        assert user, 'login required'
        if todo_id:
            todo = session.query(model.ToDo).get(todo_id)
        else:
            todo = model.ToDo(person=user,
                              created=datetime.datetime.now())
            session.add(todo)
        todo.description = description
        todo.done = parse_date(done)
        session.commit()
        return context.broadcast("SAVED_TODO",
                                 todo_view(todo))
def active_subscriptions_for(session, user_id=None, group_id=None,
                             on_date=None, loaded=True):
    if on_date is None:
        on_date = datetime.date.today()
    else:
        on_date = parse_date(on_date)
    result = session.query(model.Subscription).\
        filter(and_(model.Subscription.from_date <= on_date,
                    or_(model.Subscription.to_date > on_date,
                        model.Subscription.to_date.is_(None))))
    if user_id is not None:
        result = result.filter(model.Subscription.user_id == user_id)
    if group_id is not None:
        result = result.filter(model.Subscription.group_id == group_id)

    if loaded is True:
        result = result.options(subqueryload(model.Subscription.user))
        result = result.options(subqueryload(model.Subscription.group))
        result = result.options(subqueryload(model.Subscription.service))
    return result