saved_message_service.py 2.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. from typing import Optional, Union
  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 App, EndUser
  6. from models.web import SavedMessage
  7. from services.message_service import MessageService
  8. class SavedMessageService:
  9. @classmethod
  10. def pagination_by_last_id(cls, app_model: App, user: Optional[Union[Account | EndUser]],
  11. last_id: Optional[str], limit: int) -> InfiniteScrollPagination:
  12. saved_messages = db.session.query(SavedMessage).filter(
  13. SavedMessage.app_id == app_model.id,
  14. SavedMessage.created_by_role == ('account' if isinstance(user, Account) else 'end_user'),
  15. SavedMessage.created_by == user.id
  16. ).order_by(SavedMessage.created_at.desc()).all()
  17. message_ids = [sm.message_id for sm in saved_messages]
  18. return MessageService.pagination_by_last_id(
  19. app_model=app_model,
  20. user=user,
  21. last_id=last_id,
  22. limit=limit,
  23. include_ids=message_ids
  24. )
  25. @classmethod
  26. def save(cls, app_model: App, user: Optional[Union[Account | EndUser]], message_id: str):
  27. saved_message = db.session.query(SavedMessage).filter(
  28. SavedMessage.app_id == app_model.id,
  29. SavedMessage.message_id == message_id,
  30. SavedMessage.created_by_role == ('account' if isinstance(user, Account) else 'end_user'),
  31. SavedMessage.created_by == user.id
  32. ).first()
  33. if saved_message:
  34. return
  35. message = MessageService.get_message(
  36. app_model=app_model,
  37. user=user,
  38. message_id=message_id
  39. )
  40. saved_message = SavedMessage(
  41. app_id=app_model.id,
  42. message_id=message.id,
  43. created_by_role='account' if isinstance(user, Account) else 'end_user',
  44. created_by=user.id
  45. )
  46. db.session.add(saved_message)
  47. db.session.commit()
  48. @classmethod
  49. def delete(cls, app_model: App, user: Optional[Union[Account | EndUser]], message_id: str):
  50. saved_message = db.session.query(SavedMessage).filter(
  51. SavedMessage.app_id == app_model.id,
  52. SavedMessage.message_id == message_id,
  53. SavedMessage.created_by_role == ('account' if isinstance(user, Account) else 'end_user'),
  54. SavedMessage.created_by == user.id
  55. ).first()
  56. if not saved_message:
  57. return
  58. db.session.delete(saved_message)
  59. db.session.commit()