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