Example #1
0
    def list(self, user=None):
        self.is_page_back = True
        query = meta.Session.query(model.Event)
        if user is None:
            query = query.select_from(
                join(model.Event, model.User,
                     model.Event.node_user_id == model.User.id)).filter(
                         and_(model.Event.published != None,
                              model.User.nickname != 'demo'))
        else:
            user_query = meta.Session.query(model.User)
            try:
                user_node = user_query.filter(
                    model.User.nickname == user).one()
            except NoResultFound:
                abort(404)

            query = query.filter(model.Event.node_user_id == user_node.id)

            if user_node.nickname != current_user().nickname:
                query = query.filter(model.Event.published != None)

        query = query.order_by(model.Event.start.desc())

        c.user = user
        c.nodes = pager_or_404(query)
        if is_ajax():
            result = self.taconite(render('/event/list_partial.html'))
        else:
            result = render('/event/list.html')
        return result
Example #2
0
    def list(self, label=None):
        self.is_page_back = True
        query = meta.Session().query(model.Article)

        if label is not None:
            query = query.filter(model.Article.label == label)
        else:
            query = query.filter(model.Article.label == label)

        if not is_admin():
            query = query.filter(model.Article.published != None)

        query = query.order_by(model.Article.created.desc())

        c.nodes = pager_or_404(query)
        c.label = label
        return render("/article/list.html")
Example #3
0
    def list(self, label=None):
        self.is_page_back = True
        query = meta.Session().query(model.Article)

        if label is not None:
            query = query.filter(model.Article.label==label)
        else:
            query = query.filter(model.Article.label==label)

        if not is_admin():
            query = query.filter(model.Article.published != None)

        query = query.order_by(model.Article.created.desc())

        c.nodes = pager_or_404(query)
        c.label = label
        return render('/article/list.html')