def get_all_channel_db(db: Session): channels = db.query(channel.Channel).all() for c in channels: c.number_of_manager = crud_channel_manager.count_manager_of_channel( db=db, channel_id=c.id) c.number_of_shop = crud_shop.count_shop(db=db, channel_id=c.id) return channels
def get_all_channel(db: Session, skip: int = 0, limit: int = 100): channels = db.query(channel.Channel).offset(skip).limit(limit).all() for c in channels: c.number_of_manager = crud_channel_manager.count_manager_of_channel( db=db, channel_id=c.id) c.number_of_shop = crud_shop.count_shop(db=db, channel_id=c.id) return channels
def Count_shop_of_channel( channel_id:str, current_user= Security(deps.get_current_active_user,scopes=["read_channel"]), db: Session = Depends(deps.get_db) ): if crud_channel.get_channel(db=db,channel_id=channel_id) is None: raise UnicornException( messages="CHANNEL ID NOT FOUND", name=channel_id ) return crud_shop.count_shop(db=db,channel_id=channel_id)
def Count_shop_of_channel(channel_id: str, token: Optional[str] = Header(None), db: Session = Depends(deps.get_db)): try: check_sercurity_scopes(token=token, scopes=settings.VIEW_CHANNEL_DETAIL_SCOPE) except (JWTError, ValidationError): raise HTTPException( status_code=status.HTTP_401_UNAUTHORIZED, detail="Unauthorized ", headers={"WWW-Authenticate": "Bearer"}, ) except (mysql.connector.Error): raise HTTPException( status_code=status.HTTP_502_BAD_GATEWAY, detail="My sql connection error ", headers={"WWW-Authenticate": "Bearer"}, ) return crud_shop.count_shop(db=db, channel_id=channel_id)
def Count_shop_of_channel(channel_id: str, current_user=Security(deps.get_current_active_user, scopes=["read_channel"]), db: Session = Depends(deps.get_db)): return crud_shop.count_shop(db=db, channel_id=channel_id)