| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128 | from typing import Union, Optionalfrom core.generator.llm_generator import LLMGeneratorfrom libs.infinite_scroll_pagination import InfiniteScrollPaginationfrom extensions.ext_database import dbfrom models.account import Accountfrom models.model import Conversation, App, EndUser, Messagefrom services.errors.conversation import ConversationNotExistsError, LastConversationNotExistsErrorfrom services.errors.message import MessageNotExistsErrorclass ConversationService:    @classmethod    def pagination_by_last_id(cls, app_model: App, user: Optional[Union[Account | EndUser]],                              last_id: Optional[str], limit: int,                              include_ids: Optional[list] = None, exclude_ids: Optional[list] = None,                              exclude_debug_conversation: bool = False) -> InfiniteScrollPagination:        if not user:            return InfiniteScrollPagination(data=[], limit=limit, has_more=False)        base_query = db.session.query(Conversation).filter(            Conversation.is_deleted == False,            Conversation.app_id == app_model.id,            Conversation.from_source == ('api' if isinstance(user, EndUser) else 'console'),            Conversation.from_end_user_id == (user.id if isinstance(user, EndUser) else None),            Conversation.from_account_id == (user.id if isinstance(user, Account) else None),        )        if include_ids is not None:            base_query = base_query.filter(Conversation.id.in_(include_ids))        if exclude_ids is not None:            base_query = base_query.filter(~Conversation.id.in_(exclude_ids))        if exclude_debug_conversation:            base_query = base_query.filter(Conversation.override_model_configs == None)        if last_id:            last_conversation = base_query.filter(                Conversation.id == last_id,            ).first()            if not last_conversation:                raise LastConversationNotExistsError()            conversations = base_query.filter(                Conversation.created_at < last_conversation.created_at,                Conversation.id != last_conversation.id            ).order_by(Conversation.created_at.desc()).limit(limit).all()        else:            conversations = base_query.order_by(Conversation.created_at.desc()).limit(limit).all()        has_more = False        if len(conversations) == limit:            current_page_first_conversation = conversations[-1]            rest_count = base_query.filter(                Conversation.created_at < current_page_first_conversation.created_at,                Conversation.id != current_page_first_conversation.id            ).count()            if rest_count > 0:                has_more = True        return InfiniteScrollPagination(            data=conversations,            limit=limit,            has_more=has_more        )    @classmethod    def rename(cls, app_model: App, conversation_id: str,               user: Optional[Union[Account | EndUser]], name: str, auto_generate: bool):        conversation = cls.get_conversation(app_model, conversation_id, user)        if auto_generate:            return cls.auto_generate_name(app_model, conversation)        else:            conversation.name = name            db.session.commit()        return conversation    @classmethod    def auto_generate_name(cls, app_model: App, conversation: Conversation):        # get conversation first message        message = db.session.query(Message) \            .filter(                Message.app_id == app_model.id,                Message.conversation_id == conversation.id            ).order_by(Message.created_at.asc()).first()        if not message:            raise MessageNotExistsError()        # generate conversation name        try:            name = LLMGenerator.generate_conversation_name(app_model.tenant_id, message.query)            conversation.name = name        except:            pass        db.session.commit()        return conversation    @classmethod    def get_conversation(cls, app_model: App, conversation_id: str, user: Optional[Union[Account | EndUser]]):        conversation = db.session.query(Conversation) \            .filter(            Conversation.id == conversation_id,            Conversation.app_id == app_model.id,            Conversation.from_source == ('api' if isinstance(user, EndUser) else 'console'),            Conversation.from_end_user_id == (user.id if isinstance(user, EndUser) else None),            Conversation.from_account_id == (user.id if isinstance(user, Account) else None),            Conversation.is_deleted == False        ).first()        if not conversation:            raise ConversationNotExistsError()        return conversation    @classmethod    def delete(cls, app_model: App, conversation_id: str, user: Optional[Union[Account | EndUser]]):        conversation = cls.get_conversation(app_model, conversation_id, user)        conversation.is_deleted = True        db.session.commit()
 |