Spaces:
Sleeping
Sleeping
File size: 1,194 Bytes
028a629 06067fa 028a629 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | from externals.databases.pg_crud import (
count_files_by_user,
count_profiles_by_user,
)
from externals.databases.pg_models import CVUser
from sqlalchemy.ext.asyncio import AsyncSession
from utils.logger import get_logger
logger = get_logger("score card")
class KnowledgeScoreCardService:
def __init__(self, db: AsyncSession, user: CVUser):
self.db = db
self.user = user
async def get_score_card(self) -> dict:
"""
Retrieve extracted profile securely
"""
# Count total files for this user (from cv_file table)
total_file = await count_files_by_user(self.db, self.user.user_id)
# Count total extracted profiles associated with this user's files
total_extracted = await count_profiles_by_user(self.db, self.user.user_id)
# percent as 0-1, safely handle division by zero
percent_extracted = round(total_extracted / total_file, 2) if total_file else 0.0
score_card = {
"total_file": total_file,
"total_extracted": total_extracted,
"percent_extracted": round(percent_extracted*100, 0) if total_file else 0,
}
return score_card |