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