def get_people(filters, page_size=25): q = Person.query q = add_person_leaderboard_filters(q) q = q.options( orm.subqueryload_all( Person.contributions, Contribution.package ) ) for k, v in filters.iteritems(): if k == "tags": pass # don't do anything for these for now for people else: if k == "host": k = "main_language" v = make_language(v) attr = getattr(Person, k) q = q.filter(attr==v) total_count = q.count() q = q.order_by(Person.impact.desc()) q = q.limit(page_size) objects = q.all() return (total_count, objects)
def get_people(filters, page_size=25): q = Person.query q = add_person_leaderboard_filters(q) q = q.options( orm.subqueryload_all( Person.contributions, Contribution.package ) ) for k, v in filters.iteritems(): if k == "tags": pass # don't do anything for these for now for people else: if k == "host": k = "main_language" v = make_language(v) attr = getattr(Person, k) q = q.filter(attr==v) total_count = q.count() q = q.filter(Person.impact != None) q = q.order_by(Person.impact.desc()) q = q.limit(page_size) objects = q.all() return (total_count, objects)
shortcut_fn=PypiPackage.shortcut_impact_rank )) q = db.session.query(CranPackage.id) q = q.filter(CranPackage.impact_rank == None) update_registry.register(Update( job=CranPackage.set_impact_rank, query=q, queue_id=9, shortcut_fn=CranPackage.shortcut_impact_rank )) q = db.session.query(Person.id) q = q.filter(Person.impact_rank == None) q = add_person_leaderboard_filters(q) update_registry.register(Update( job=Person.set_impact_rank, query=q, queue_id=9, shortcut_fn=Person.shortcut_impact_rank )) q = db.session.query(Package.id) q = q.filter(Package.github_owner != None) q = q.filter(Package.github_api_raw == None) update_registry.register(Update( job=Package.refresh_github_ids, query=q,
q = db.session.query(PypiPackage.id) q = q.filter(PypiPackage.impact_rank == None) update_registry.register( Update(job=PypiPackage.set_impact_rank, query=q, queue_id=9, shortcut_fn=PypiPackage.shortcut_impact_rank) ) q = db.session.query(CranPackage.id) q = q.filter(CranPackage.impact_rank == None) update_registry.register( Update(job=CranPackage.set_impact_rank, query=q, queue_id=9, shortcut_fn=CranPackage.shortcut_impact_rank) ) q = db.session.query(Person.id) q = q.filter(Person.impact_rank == None) q = add_person_leaderboard_filters(q) update_registry.register( Update(job=Person.set_impact_rank, query=q, queue_id=9, shortcut_fn=Person.shortcut_impact_rank) ) q = db.session.query(Package.id) q = q.filter(Package.github_owner != None) q = q.filter(Package.github_api_raw == None) update_registry.register(Update(job=Package.refresh_github_ids, query=q, queue_id=7)) q = db.session.query(Package.id) q = q.filter(Package.credit == None) update_registry.register(Update(job=Package.set_credit, query=q, queue_id=7))