from typing import List
from sqlalchemy.orm import Session
from fastapi import HTTPException
from app.api.competitor_category_analyses import schema
from app.dependency.authantication import JWTPayloadSchema
from app.locale.messages import Messages
from app.models.main.competitor_category_analyses import CompetitorCategoryAnalysesBase, TblCompetitorCategoryAnalyses
from app.utils.schemas_utils import CustomResponse

class CompetitorCategoryAnalysesService:
    def __init__(self, db:Session, token:JWTPayloadSchema):
        self.db = db
        self.token = token
        
    async def create_competitor_category_analyses(self, request:schema.CompetitorCategoryAnalysesCreate):
        created_competitor_category_analyses = CompetitorCategoryAnalysesBase.model_validate(request.model_dump())
        TblCompetitorCategoryAnalyses.create(created_competitor_category_analyses, self.db)
        self.db.commit()
        return CustomResponse(status="1", message=Messages.COMPETITOR_CATEGORY_ANALYSES_CREATE)
    
    async def get_competitor_category_analyse(self, competitor_category_id:int):
        new_get_competitor_category_analyse = TblCompetitorCategoryAnalyses.get_competitor_category_analyses(competitor_category_id, self.db)
        return schema.CompetitorCategoryAnalysesResponse.model_validate(new_get_competitor_category_analyse)
    
    async def get_group_competitor_category_analyse(self, group_id:int) ->"TblCompetitorCategoryAnalyses":
        new_get_group_competitor_category_analyse = self.db.query(TblCompetitorCategoryAnalyses).filter(TblCompetitorCategoryAnalyses.group_id == group_id).all()
        if not new_get_group_competitor_category_analyse:
            raise HTTPException(status_code=404, detail="Get group ID not found")
        return [schema.CompetitorCategoryAnalysesResponse.model_validate(get_group) for get_group in new_get_group_competitor_category_analyse]
    
    async def update_competitor_category_analyse(self, request:List[schema.CompetitorCategoryAnalysesUpdate]):
        for req in request:
            updated_competitor_category_analyse = CompetitorCategoryAnalysesBase.model_validate(req.model_dump())
            if updated_competitor_category_analyse.competitor_category_id is None:
                return CustomResponse(status="-1", message=Messages.COMPETITOR_CATEGORY_ANALYSES_NOT_UPDATE)
            TblCompetitorCategoryAnalyses.update_competitor_category_analyses(updated_competitor_category_analyse.competitor_category_id, updated_competitor_category_analyse, self.db)
        self.db.commit()
        return CustomResponse(status="1", message=Messages.COMPETITOR_CATEGORY_ANALYSES_UPDATE_SUC)
    
    async def delete_competitor_category_analyse(self, competitor_category_delete_id:int):
        deleted_competitor_category_analyse = TblCompetitorCategoryAnalyses.delete_competitor_category_analyses(competitor_category_delete_id, self.db)
        if not deleted_competitor_category_analyse:
            return CustomResponse(status="-1", message=Messages.COMPETITOR_CATEGORY_ANALYSES_NOT_UPDATE)
        return CustomResponse(status="1", message=Messages.COMPETITOR_CATEGORY_ANALYSES_DELETE_SUC)