def view(self, username=None, sub_domain=None): """Default view for a user; shows eir recent activity and some simple stats/info. """ c.user = model.User.get_by_name(username) if not c.user: abort(404) # Recent submissions joined_tables = model.Submission.__table__ \ .join(model.UserSubmission.__table__) \ .join(model.User.__table__) where = [model.User.id == c.user.id] (c.recent_submissions, submission_ct) = find_submissions(joined_tables=joined_tables, where_clauses=where, page_size=10) c.recent_journals = model.Session.query(model.JournalEntry) \ .filter_by(status='normal') \ .filter_by(user_id=c.user.id) \ .order_by(model.JournalEntry.time.desc()) \ .limit(10) \ .all() return render('user/view.mako')
def index(self): """Main site index page.""" c.news = model.Session.query(model.News) \ .filter_by(is_deleted=False) \ .order_by(model.News.time.desc()) \ .limit(5) c.recent_submissions = find_submissions(page_size=12)[0] return render('/index.mako')