def index(slug): project = object_or_404(Project.by_slug(slug)) authz.require(authz.project_manage(project)) query = Permission.all() query = query.filter_by(project=project) pager = Pager(query, slug=slug) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)
def index(slug): project = object_or_404(Project.by_slug(slug)) authz.require(authz.project_read(project)) validate_cache(last_modified=project.updated_at) query = Schema.all() query = query.filter_by(project=project) pager = Pager(query, slug=slug) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=not arg_bool('full'))
def index(): q = Project.all() q = q.outerjoin(Permission) q = q.filter(or_(Project.private==False, and_(Permission.reader==True, Permission.account==request.account))) q = q.distinct() pager = Pager(q) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)
def index(): alias = aliased(Entity) q = db.session.query(alias) query = filters.for_entities(q, alias) query = query.distinct() pager = Pager(query) validate_cache(keys=pager.cache_keys()) result = pager.to_dict() result['facets'] = facets.for_entities() return jsonify(result, index=True)
def index(): alias = aliased(Relation) q = db.session.query(alias) query = filters.for_relations(q, alias) query = query.distinct() pager = Pager(query) validate_cache(keys=pager.cache_keys()) result = pager.to_dict() result['facets'] = facets.for_relations() return jsonify(result, index=True)
def index(): q = Project.all() q = q.outerjoin(Permission) q = q.filter( or_( Project.private == False, and_(Permission.reader == True, Permission.account == request.account))) q = q.distinct() pager = Pager(q) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)
def index(pipeline_id): pipeline = object_or_404(Pipeline.by_id(pipeline_id)) authz.require(authz.project_read(pipeline.project)) query = LogEntry.all() query = query.filter(LogEntry.pipeline==pipeline) if request.args.get('level'): query = query.filter(LogEntry.level==request.args.get('level')) pager = Pager(query) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)
def _index(query, obj): authz.require(authz.project_read(obj.project)) active_only = arg_bool('active', default=True) if active_only: query = query.filter_by(active=True) if 'name' in request.args: query = query.filter_by(name=request.args.get('name')) query = query.order_by(Property.created_at.desc()) pager = Pager(query, obj_id=obj.id) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=False)
def index(): query = File.all() query = query.join(Project) query = query.outerjoin(Permission) query = query.filter(or_(Project.private == False, and_(Permission.reader == True, Permission.account==request.account))) if request.args.get('project'): query = query.filter(Project.slug == request.args.get('project')) query = query.distinct() pager = Pager(query) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)
def index(): query = filter_query(Relation, Relation.all(), request.args) if request.args.get('source'): query = query.filter(Relation.source_id==request.args.getlist('source')[0]) if request.args.get('target'): query = query.filter(Relation.target_id==request.args.getlist('target')[0]) if request.args.get('schema'): schemata = request.args.get('schema').split(',') query = query.join(Schema) query = query.filter(Schema.name.in_(schemata)) pager = Pager(query) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)
def index(): query = File.all() query = query.join(Project) query = query.outerjoin(Permission) query = query.filter( or_( Project.private == False, and_(Permission.reader == True, Permission.account == request.account))) if request.args.get('project'): query = query.filter(Project.slug == request.args.get('project')) query = query.distinct() pager = Pager(query) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)
def index(): query = Pipeline.all() query = query.join(Project) query = query.outerjoin(Permission) query = query.filter( or_(Project.private == False, and_(Permission.reader == True, Permission.account == request.account)) ) if request.args.get("project"): query = query.filter(Project.slug == request.args.get("project")) if request.args.get("operation"): query = query.filter(Pipeline.operation == request.args.get("operation")) query = query.order_by(Pipeline.updated_at.desc()) query = query.distinct() pager = Pager(query) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)
def index(): query = filter_query(Entity, Entity.all(), request.args) if 'q' in request.args and len(request.args.get('q').strip()): q = '%%%s%%' % request.args.get('q').strip() query = query.join(EntityProperty) query = query.filter(EntityProperty.name=='name') query = query.filter(EntityProperty.value_string.ilike(q)) for schema in request.args.getlist('schema'): if not len(schema.strip()): continue alias = aliased(Schema) query = query.join(alias, Entity.schemata) query = query.filter(alias.name.in_(schema.split(','))) query = query.filter(Entity.same_as==None) query = query.distinct() pager = Pager(query) validate_cache(keys=pager.cache_keys()) return jsonify(pager, index=True)