123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128 |
- from typing import Union, Optional
- from core.generator.llm_generator import LLMGenerator
- from libs.infinite_scroll_pagination import InfiniteScrollPagination
- from extensions.ext_database import db
- from models.account import Account
- from models.model import Conversation, App, EndUser, Message
- from services.errors.conversation import ConversationNotExistsError, LastConversationNotExistsError
- from services.errors.message import MessageNotExistsError
- class 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()
|