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