def _get_world_rank(): dbsession = DBSession() world_top = dbsession.query(Friend).order_by(desc(Friend.score)).\ limit(100).all() world_top_users = dbsession.query(User).order_by(desc(User.score)).\ limit(100).all() world_top.extend(world_top_users) return sorted(world_top, key=lambda k:k.score, reverse=True)
def _get_world_rank(): dbsession = DBSession() world_top = dbsession.query(Friend).order_by(desc(Friend.score)).\ limit(100).all() world_top_users = dbsession.query(User).order_by(desc(User.score)).\ limit(100).all() world_top.extend(world_top_users) return sorted(world_top, key=lambda k: k.score, reverse=True)
def _get_all_national_schools(): dbsession = DBSession() schools = dbsession.query(NationalSchools.rank, NationalSchools.name, NationalSchools.short_name).all() names = [s.name for s in schools] short_names = [s.short_name for s in schools] return dict(names=names, short_names=short_names)
def _get_all_world_schools(): dbsession = DBSession() schools = dbsession.query(WorldSchools.rank, WorldSchools.name, WorldSchools.short_name).all() names = [s.name for s in schools] short_names = [s.short_name for s in schools] return dict(names=names, short_names=short_names)
def dashboard(request): dbsession = DBSession() settings = request.registry.settings cookie = facebook.get_user_from_cookie(request.cookies, settings['facebook.app.id'], settings['facebook.app.secret']) if cookie: graph = _get_graph(cookie['access_token']) profile = graph.get_object('me') fb_id = profile['id'] user = dbsession.query(User).filter(User.fb_id == fb_id).first() if not user: user = User( fb_id, cookie['access_token'], profile['updated_time'], profile['name'], 'gender' in profile and profile['gender'] or None, 'location' in profile and profile['location']['name'] or None, _get_lifescore(profile)) dbsession.add(user) dbsession.commit() return dict(profile=profile, score=user.score, friends_id=_get_friends_id(graph).encode( 'ascii', 'ignore'), world_rank=_get_world_rank()[0:20]) elif user.fb_access_token != cookie['access_token']: user.fb_access_token = cookie['access_token'] if user.fb_updated_time != profile['update_time']: user.score = _get_lifescore(profile) dbsession.merge(user) dbsession.commit() try: debug = request.GET['debug'] return dict(profile=profile, score=user.score, friends_id=_get_friends_id(graph).encode( 'ascii', 'ignore'), world_rank=_get_world_rank()[0:20]) except KeyError: pass return dict(profile=profile, score=user.score, friends_rank=_get_friends(user)[0:20], world_rank=_get_world_rank()[0:20]) else: return HTTPFound(location=route_url('home', request))
def dashboard(request): dbsession = DBSession() settings = request.registry.settings cookie = facebook.get_user_from_cookie(request.cookies, settings['facebook.app.id'], settings['facebook.app.secret']) if cookie: graph = _get_graph(cookie['access_token']) profile = graph.get_object('me') fb_id = profile['id'] user = dbsession.query(User).filter(User.fb_id==fb_id).first() if not user: user = User(fb_id, cookie['access_token'], profile['updated_time'], profile['name'], 'gender' in profile and profile['gender'] or None, 'location' in profile and profile['location']['name'] or None, _get_lifescore(profile)) dbsession.add(user) dbsession.commit() return dict(profile=profile, score=user.score, friends_id=_get_friends_id(graph).encode('ascii','ignore'), world_rank=_get_world_rank()[0:20]) elif user.fb_access_token != cookie['access_token']: user.fb_access_token = cookie['access_token'] if user.fb_updated_time != profile['update_time']: user.score = _get_lifescore(profile) dbsession.merge(user) dbsession.commit() try: debug = request.GET['debug'] return dict(profile=profile, score=user.score, friends_id=_get_friends_id(graph).encode('ascii','ignore'), world_rank=_get_world_rank()[0:20]) except KeyError: pass return dict(profile=profile, score=user.score, friends_rank=_get_friends(user)[0:20], world_rank=_get_world_rank()[0:20]) else: return HTTPFound(location=route_url('home', request))
def _get_jobs(): dbsession = DBSession() jobs = dbsession.query(Job.prestige, Job.job).all() return dict([(job.job.lower(), job.prestige) for job in jobs])
def _get_all_majors(): dbsession = DBSession() majors = dbsession.query(Major.name).order_by( desc(Major.avg_starting_salary)).limit(40) return dict([(m.name, 1) for m in majors])
def _get_friends(user): dbsession = DBSession() return dbsession.query(Friend).filter(Friend.user_id==user.id).\ order_by(desc(Friend.score)).all()
def _get_top_companies(): dbsession = DBSession() companies = dict([(c.name, 1) for c in dbsession.query(Company.name).all()]) return companies
def _get_user_from_fb_id(fb_id): dbsession = DBSession() return dbsession.query(User).filter(User.fb_id==fb_id).first()
def _get_user_from_fb_id(fb_id): dbsession = DBSession() return dbsession.query(User).filter(User.fb_id == fb_id).first()