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