Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/adapters/db/repositories/ai_prompt_repository.py
2026-06-13 23:49:34 +00:00

77 lines
3 KiB
Python
Executable file

from typing import Optional, List
from sqlalchemy.orm import Session
from sqlalchemy import and_
from adapters.db.models.ai_prompt import AIPrompt, PromptRole, PromptType
from adapters.db.repositories.base_repo import BaseRepository
class AIPromptRepository(BaseRepository[AIPrompt]):
def __init__(self, db: Session):
super().__init__(db, AIPrompt)
def get_default_by_key(self, prompt_key: str) -> Optional[AIPrompt]:
return self.db.query(self.model_class).filter(
and_(
self.model_class.prompt_key == prompt_key,
self.model_class.is_default == True, # noqa: E712
self.model_class.user_id == None, # noqa: E711
self.model_class.is_active == True, # noqa: E712
)
).first()
def get_default_prompt(
self,
role: PromptRole,
prompt_type: PromptType = PromptType.SYSTEM,
) -> Optional[AIPrompt]:
"""دریافت prompt پیش‌فرض بر اساس نقش (سازگاری عقب‌رو)"""
return self.db.query(self.model_class).filter(
and_(
self.model_class.role == role.value,
self.model_class.prompt_type == prompt_type.value,
self.model_class.is_default == True, # noqa: E712
self.model_class.user_id == None, # noqa: E711
self.model_class.is_active == True, # noqa: E712
)
).first()
def get_user_prompt(
self,
user_id: int,
role: PromptRole,
prompt_type: PromptType = PromptType.SYSTEM,
) -> Optional[AIPrompt]:
return self.db.query(self.model_class).filter(
and_(
self.model_class.user_id == user_id,
self.model_class.role == role.value,
self.model_class.prompt_type == prompt_type.value,
self.model_class.is_active == True, # noqa: E712
)
).first()
def get_user_prompts(self, user_id: int) -> List[AIPrompt]:
return self.db.query(self.model_class).filter(
and_(
self.model_class.user_id == user_id,
self.model_class.is_active == True, # noqa: E712
)
).order_by(self.model_class.created_at.desc()).all()
def get_all_default_prompts(
self,
role: Optional[str] = None,
category: Optional[str] = None,
) -> List[AIPrompt]:
query = self.db.query(self.model_class).filter(
and_(
self.model_class.is_default == True, # noqa: E712
self.model_class.user_id == None, # noqa: E711
self.model_class.is_active == True, # noqa: E712
)
)
if role:
query = query.filter(self.model_class.role == role)
if category:
query = query.filter(self.model_class.category == category)
return query.order_by(self.model_class.category, self.model_class.prompt_key).all()