q = q.filter(attr == v)
total_count = q.count()
q = q.filter(Package.impact != None)
q = q.order_by(Package.impact.desc(), Package.num_downloads.desc())
q = q.limit(page_size)
objects = q.all()
return (total_count, objects)
q = db.session.query(CranPackage.id)
update_registry.register(
Update(job=CranPackage.set_rev_deps_tree,
query=q,
shortcut_fn=CranPackage.shortcut_rev_deps_pairs))
q = db.session.query(PypiPackage.id)
update_registry.register(
Update(job=PypiPackage.set_rev_deps_tree,
query=q,
shortcut_fn=PypiPackage.shortcut_rev_deps_pairs))
q = db.session.query(PypiPackage.id)
q = q.filter(PypiPackage.requires_files != None)
update_registry.register(
Update(job=PypiPackage.set_host_deps, query=q, queue_id=5))
q = db.session.query(PypiPackage.id)
q = q.filter(PypiPackage.import_name == None)
q = db.session.query(GithubRepo.login, GithubRepo.repo_name)
q = q.filter(GithubRepo.api_raw.contains({"fork": False}))
q = q.filter(GithubRepo.language == 'r')
q = q.filter(GithubRepo.cran_descr_file == None)
q = q.order_by(GithubRepo.login)
q = q.limit(limit)
enqueue_jobs(GithubRepo, "set_cran_descr_file", q, 3, use_rq)
q = db.session.query(GithubRepo.id)
q = q.filter(GithubRepo.bucket != None)
q = q.filter(GithubRepo.setup_py == None)
update_registry.register(
Update(job=GithubRepo.set_setup_py, query=q, queue_id=4))
q = db.session.query(GithubRepo.id)
q = q.filter(GithubRepo.api_raw == None)
update_registry.register(
Update(job=GithubRepo.set_github_about, query=q, queue_id=4))
q = db.session.query(GithubRepo.id)
q = q.filter(GithubRepo.language == 'r')
q = q.filter(GithubRepo.dep_lines != None)
update_registry.register(
Update(job=GithubRepo.set_cran_dependencies, query=q, queue_id=6))
q = db.session.query(GithubRepo.id)
q = q.filter(GithubRepo.language == 'r')
from sqlalchemy.dialects.postgresql import JSONB
from app import db
import app
from jobs import update_registry
from jobs import Update
from models.product import Product
from models.person import Person
from models import person
q = db.session.query(Person.id)
q = q.filter(Person.orcid_id != None)
update_registry.register(Update(
job=Person.refresh,
query=q,
shortcut_fn=person.shortcut_all_percentile_refsets
))
q = db.session.query(Person.id)
update_registry.register(Update(
job=Person.set_first_name,
query=q
))
q = db.session.query(Person.id)
update_registry.register(Update(
job=Person.calculate,
query=q
))
from sqlalchemy import text
from sqlalchemy import orm
from sqlalchemy.dialects.postgresql import JSONB
from app import db
import app
from jobs import update_registry
from jobs import Update
from models.product import Product
from models.person import Person
from models import person
q = db.session.query(Person.id)
q = q.filter(Person.orcid_id != None)
update_registry.register(Update(job=Person.refresh, query=q, queue_id=0))
q = db.session.query(Person.id)
q = q.filter(Person.claimed_at != None)
update_registry.register(Update(
job=Person.email_new_stuff,
query=q,
))
q = db.session.query(Person.id)
update_registry.register(Update(
job=Person.calculate,
query=q,
))
q = db.session.query(Person.id)
from sqlalchemy import text from sqlalchemy import orm from sqlalchemy.dialects.postgresql import JSONB from app import db import app from jobs import update_registry from jobs import Update from publication import Publication q = db.session.query(Publication.id) update_registry.register(Update(job=Publication.refresh, query=q, queue_id=0))