conversation_service.py 3.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394
  1. from typing import Union, Optional
  2. from libs.infinite_scroll_pagination import InfiniteScrollPagination
  3. from extensions.ext_database import db
  4. from models.account import Account
  5. from models.model import Conversation, App, EndUser
  6. from services.errors.conversation import ConversationNotExistsError, LastConversationNotExistsError
  7. class ConversationService:
  8. @classmethod
  9. def pagination_by_last_id(cls, app_model: App, user: Optional[Union[Account | EndUser]],
  10. last_id: Optional[str], limit: int,
  11. include_ids: Optional[list] = None, exclude_ids: Optional[list] = None) -> InfiniteScrollPagination:
  12. if not user:
  13. return InfiniteScrollPagination(data=[], limit=limit, has_more=False)
  14. base_query = db.session.query(Conversation).filter(
  15. Conversation.app_id == app_model.id,
  16. Conversation.from_source == ('api' if isinstance(user, EndUser) else 'console'),
  17. Conversation.from_end_user_id == (user.id if isinstance(user, EndUser) else None),
  18. Conversation.from_account_id == (user.id if isinstance(user, Account) else None),
  19. )
  20. if include_ids is not None:
  21. base_query = base_query.filter(Conversation.id.in_(include_ids))
  22. if exclude_ids is not None:
  23. base_query = base_query.filter(~Conversation.id.in_(exclude_ids))
  24. if last_id:
  25. last_conversation = base_query.filter(
  26. Conversation.id == last_id,
  27. ).first()
  28. if not last_conversation:
  29. raise LastConversationNotExistsError()
  30. conversations = base_query.filter(
  31. Conversation.created_at < last_conversation.created_at,
  32. Conversation.id != last_conversation.id
  33. ).order_by(Conversation.created_at.desc()).limit(limit).all()
  34. else:
  35. conversations = base_query.order_by(Conversation.created_at.desc()).limit(limit).all()
  36. has_more = False
  37. if len(conversations) == limit:
  38. current_page_first_conversation = conversations[-1]
  39. rest_count = base_query.filter(
  40. Conversation.created_at < current_page_first_conversation.created_at,
  41. Conversation.id != current_page_first_conversation.id
  42. ).count()
  43. if rest_count > 0:
  44. has_more = True
  45. return InfiniteScrollPagination(
  46. data=conversations,
  47. limit=limit,
  48. has_more=has_more
  49. )
  50. @classmethod
  51. def rename(cls, app_model: App, conversation_id: str,
  52. user: Optional[Union[Account | EndUser]], name: str):
  53. conversation = cls.get_conversation(app_model, conversation_id, user)
  54. conversation.name = name
  55. db.session.commit()
  56. return conversation
  57. @classmethod
  58. def get_conversation(cls, app_model: App, conversation_id: str, user: Optional[Union[Account | EndUser]]):
  59. conversation = db.session.query(Conversation) \
  60. .filter(
  61. Conversation.id == conversation_id,
  62. Conversation.app_id == app_model.id,
  63. Conversation.from_source == ('api' if isinstance(user, EndUser) else 'console'),
  64. Conversation.from_end_user_id == (user.id if isinstance(user, EndUser) else None),
  65. Conversation.from_account_id == (user.id if isinstance(user, Account) else None),
  66. ).first()
  67. if not conversation:
  68. raise ConversationNotExistsError()
  69. return conversation
  70. @classmethod
  71. def delete(cls, app_model: App, conversation_id: str, user: Optional[Union[Account | EndUser]]):
  72. conversation = cls.get_conversation(app_model, conversation_id, user)
  73. db.session.delete(conversation)
  74. db.session.commit()