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