def get_recent_entity_changes(db: Session, entity_id: int, params: Params = DEFAULT_PARAMS) \ -> Page[ChangeRequest]: q = db.query(ChangeRequest)\ .filter(ChangeRequest.object_id == entity_id, ChangeRequest.object_type == EditableObjectType.ENTITY)\ .order_by(ChangeRequest.created_at.desc()) return paginate(q, params)
def read_tickets(db: Session = Depends(deps.get_db), request: ReadTicketsGetParams = Depends()) -> Any: """ Retrieve tickets. """ service = TicketService(db).get_paginate_query(request=request) result = handle_result(service) return paginate(result)
def read_claims( db: Session = Depends(deps.get_db), request: ReadClaimsGetParams = Depends() ) -> t.Any: """ Retrieve claims. """ service = ClaimService(db).get_paginate_query(request=request) result = handle_result(service) return paginate(result)
def get_pending_change_requests(db: Session, params: Params = DEFAULT_PARAMS, obj_type: Optional[EditableObjectType] = None) \ -> Page[ChangeRequest]: q = db.query(ChangeRequest) \ .filter(ChangeRequest.status == ChangeStatus.PENDING) \ .order_by(ChangeRequest.created_at.desc()) if obj_type: q = q.filter(ChangeRequest.object_type == obj_type) return paginate(q, params)
def get_recent_schema_changes(db: Session, schema_id: int, params: Params = DEFAULT_PARAMS) \ -> Page[ChangeRequest]: pending_entity_creations = db.query(ChangeRequest)\ .filter(ChangeRequest.status == ChangeStatus.PENDING, ChangeRequest.change_type == ChangeType.CREATE, ChangeRequest.object_type == EditableObjectType.ENTITY)\ .join(Change)\ .filter(Change.field_name == 'schema_id')\ .join(ChangeValueInt, Change.value_id == ChangeValueInt.id)\ .filter(ChangeValueInt.new_value == schema_id)\ .distinct() schema_history = db.query(ChangeRequest)\ .filter(ChangeRequest.object_id == schema_id, ChangeRequest.object_type == EditableObjectType.SCHEMA) q = pending_entity_creations.union(schema_history)\ .order_by(ChangeRequest.created_at.desc(), ChangeRequest.status == ChangeStatus.PENDING) return paginate(q, params)
async def get_discoveries( conn_id: int, plan_id, plan_instance_id: int, rule_id: Optional[int] = None, db: Session = Depends(get_db), params: Params = Depends(), ): disvcoveries = (db.query(models.Discovery).outerjoin( models.Rule).outerjoin(models.PlanInstance).outerjoin( models.Plan).outerjoin(models.Connection).filter( models.Connection.id == conn_id, models.Plan.id == plan_id, models.PlanInstance.id == plan_instance_id, models.Rule.id == rule_id if rule_id else True, )) return paginate(disvcoveries, params)
def read_users(db: Session = Depends(get_db)) -> Any: # return crud.get_users(db) return paginate(crud.get_users(db))
def route(db: Session = Depends(get_db)): return paginate(db.query(User))
def route(params: LimitOffsetPaginationParams = Depends(), db: Session = Depends(get_db)): return paginate(db.query(User), params)
def get_users(db: Session = Depends(get_db)) -> Any: return paginate(db.query(User))