def manage(self,type,id): if type == 'article': c.articles = Session.query(Article).order_by(desc(Article.pub_date)).all() return render('/admin/manage_news.html') elif type == 'comments': c.article = Session.query(Article).filter_by(id=id).order_by(desc(Article.pub_date)).one() return render('/admin/manage_comments.html')
def __before__(self): c.comment_type = 'article' self.news_q = Session.query(Article).options(joinedload(Article.comments)) if 'page' in request.params: c.page = request.params['page'] else: c.page = 1
def index(self): c.races = Session.query(Race).order_by(desc(Race.id)).all() tmp = {} for r in c.races: tmp[r.id] = r c.jsonrace = json.dumps(tmp, cls=raceEncode) return render('/resources/char_create_index.html');
def __validate_article(self, type, id): query_obj = Session.query(Article) try: article = query_obj.filter_by(id = id).one() if request.params['type'] != type or \ request.params['com_id'] != str(article.id) or \ request.params['com_slug'] != article.slug: return "What we have here is a failure to communicate!" c.article = article c.comment_id = c.article.id c.comment_slug = c.article.slug except NoResultFound, error: return error
def get(user): return Session.query(User).filter_by(username=user).one()