conversation_service.py 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132
  1. from typing import Optional, Union
  2. from sqlalchemy import or_
  3. from core.app.entities.app_invoke_entities import InvokeFrom
  4. from core.llm_generator.llm_generator import LLMGenerator
  5. from extensions.ext_database import db
  6. from libs.infinite_scroll_pagination import InfiniteScrollPagination
  7. from models.account import Account
  8. from models.model import App, Conversation, EndUser, Message
  9. from services.errors.conversation import ConversationNotExistsError, LastConversationNotExistsError
  10. from services.errors.message import MessageNotExistsError
  11. class ConversationService:
  12. @classmethod
  13. def pagination_by_last_id(cls, app_model: App, user: Optional[Union[Account, EndUser]],
  14. last_id: Optional[str], limit: int,
  15. invoke_from: InvokeFrom,
  16. include_ids: Optional[list] = None,
  17. exclude_ids: Optional[list] = None) -> InfiniteScrollPagination:
  18. if not user:
  19. return InfiniteScrollPagination(data=[], limit=limit, has_more=False)
  20. base_query = db.session.query(Conversation).filter(
  21. Conversation.is_deleted == False,
  22. Conversation.app_id == app_model.id,
  23. Conversation.from_source == ('api' if isinstance(user, EndUser) else 'console'),
  24. Conversation.from_end_user_id == (user.id if isinstance(user, EndUser) else None),
  25. Conversation.from_account_id == (user.id if isinstance(user, Account) else None),
  26. or_(Conversation.invoke_from.is_(None), Conversation.invoke_from == invoke_from.value)
  27. )
  28. if include_ids is not None:
  29. base_query = base_query.filter(Conversation.id.in_(include_ids))
  30. if exclude_ids is not None:
  31. base_query = base_query.filter(~Conversation.id.in_(exclude_ids))
  32. if last_id:
  33. last_conversation = base_query.filter(
  34. Conversation.id == last_id,
  35. ).first()
  36. if not last_conversation:
  37. raise LastConversationNotExistsError()
  38. conversations = base_query.filter(
  39. Conversation.created_at < last_conversation.created_at,
  40. Conversation.id != last_conversation.id
  41. ).order_by(Conversation.created_at.desc()).limit(limit).all()
  42. else:
  43. conversations = base_query.order_by(Conversation.created_at.desc()).limit(limit).all()
  44. has_more = False
  45. if len(conversations) == limit:
  46. current_page_first_conversation = conversations[-1]
  47. rest_count = base_query.filter(
  48. Conversation.created_at < current_page_first_conversation.created_at,
  49. Conversation.id != current_page_first_conversation.id
  50. ).count()
  51. if rest_count > 0:
  52. has_more = True
  53. return InfiniteScrollPagination(
  54. data=conversations,
  55. limit=limit,
  56. has_more=has_more
  57. )
  58. @classmethod
  59. def rename(cls, app_model: App, conversation_id: str,
  60. user: Optional[Union[Account, EndUser]], name: str, auto_generate: bool):
  61. conversation = cls.get_conversation(app_model, conversation_id, user)
  62. if auto_generate:
  63. return cls.auto_generate_name(app_model, conversation)
  64. else:
  65. conversation.name = name
  66. db.session.commit()
  67. return conversation
  68. @classmethod
  69. def auto_generate_name(cls, app_model: App, conversation: Conversation):
  70. # get conversation first message
  71. message = db.session.query(Message) \
  72. .filter(
  73. Message.app_id == app_model.id,
  74. Message.conversation_id == conversation.id
  75. ).order_by(Message.created_at.asc()).first()
  76. if not message:
  77. raise MessageNotExistsError()
  78. # generate conversation name
  79. try:
  80. name = LLMGenerator.generate_conversation_name(
  81. app_model.tenant_id, message.query, conversation.id, app_model.id
  82. )
  83. conversation.name = name
  84. except:
  85. pass
  86. db.session.commit()
  87. return conversation
  88. @classmethod
  89. def get_conversation(cls, app_model: App, conversation_id: str, user: Optional[Union[Account, EndUser]]):
  90. conversation = db.session.query(Conversation) \
  91. .filter(
  92. Conversation.id == conversation_id,
  93. Conversation.app_id == app_model.id,
  94. Conversation.from_source == ('api' if isinstance(user, EndUser) else 'console'),
  95. Conversation.from_end_user_id == (user.id if isinstance(user, EndUser) else None),
  96. Conversation.from_account_id == (user.id if isinstance(user, Account) else None),
  97. Conversation.is_deleted == False
  98. ).first()
  99. if not conversation:
  100. raise ConversationNotExistsError()
  101. return conversation
  102. @classmethod
  103. def delete(cls, app_model: App, conversation_id: str, user: Optional[Union[Account, EndUser]]):
  104. conversation = cls.get_conversation(app_model, conversation_id, user)
  105. conversation.is_deleted = True
  106. db.session.commit()