Spaces:
Paused
Paused
| from pydantic import BaseModel | |
| from typing import List, Union, Optional | |
| from peewee import * | |
| from playhouse.shortcuts import model_to_dict | |
| import json | |
| import uuid | |
| import time | |
| from apps.webui.internal.db import DB | |
| #################### | |
| # Chat DB Schema | |
| #################### | |
| class Chat(Model): | |
| id = CharField(unique=True) | |
| user_id = CharField() | |
| title = TextField() | |
| chat = TextField() # Save Chat JSON as Text | |
| created_at = BigIntegerField() | |
| updated_at = BigIntegerField() | |
| share_id = CharField(null=True, unique=True) | |
| archived = BooleanField(default=False) | |
| class Meta: | |
| database = DB | |
| class ChatModel(BaseModel): | |
| id: str | |
| user_id: str | |
| title: str | |
| chat: str | |
| created_at: int # timestamp in epoch | |
| updated_at: int # timestamp in epoch | |
| share_id: Optional[str] = None | |
| archived: bool = False | |
| #################### | |
| # Forms | |
| #################### | |
| class ChatForm(BaseModel): | |
| chat: dict | |
| class ChatTitleForm(BaseModel): | |
| title: str | |
| class ChatResponse(BaseModel): | |
| id: str | |
| user_id: str | |
| title: str | |
| chat: dict | |
| updated_at: int # timestamp in epoch | |
| created_at: int # timestamp in epoch | |
| share_id: Optional[str] = None # id of the chat to be shared | |
| archived: bool | |
| class ChatTitleIdResponse(BaseModel): | |
| id: str | |
| title: str | |
| updated_at: int | |
| created_at: int | |
| class ChatTable: | |
| def __init__(self, db): | |
| self.db = db | |
| db.create_tables([Chat]) | |
| def insert_new_chat(self, user_id: str, form_data: ChatForm) -> Optional[ChatModel]: | |
| id = str(uuid.uuid4()) | |
| chat = ChatModel( | |
| **{ | |
| "id": id, | |
| "user_id": user_id, | |
| "title": ( | |
| form_data.chat["title"] if "title" in form_data.chat else "New Chat" | |
| ), | |
| "chat": json.dumps(form_data.chat), | |
| "created_at": int(time.time()), | |
| "updated_at": int(time.time()), | |
| } | |
| ) | |
| result = Chat.create(**chat.model_dump()) | |
| return chat if result else None | |
| def update_chat_by_id(self, id: str, chat: dict) -> Optional[ChatModel]: | |
| try: | |
| query = Chat.update( | |
| chat=json.dumps(chat), | |
| title=chat["title"] if "title" in chat else "New Chat", | |
| updated_at=int(time.time()), | |
| ).where(Chat.id == id) | |
| query.execute() | |
| chat = Chat.get(Chat.id == id) | |
| return ChatModel(**model_to_dict(chat)) | |
| except: | |
| return None | |
| def insert_shared_chat_by_chat_id(self, chat_id: str) -> Optional[ChatModel]: | |
| # Get the existing chat to share | |
| chat = Chat.get(Chat.id == chat_id) | |
| # Check if the chat is already shared | |
| if chat.share_id: | |
| return self.get_chat_by_id_and_user_id(chat.share_id, "shared") | |
| # Create a new chat with the same data, but with a new ID | |
| shared_chat = ChatModel( | |
| **{ | |
| "id": str(uuid.uuid4()), | |
| "user_id": f"shared-{chat_id}", | |
| "title": chat.title, | |
| "chat": chat.chat, | |
| "created_at": chat.created_at, | |
| "updated_at": int(time.time()), | |
| } | |
| ) | |
| shared_result = Chat.create(**shared_chat.model_dump()) | |
| # Update the original chat with the share_id | |
| result = ( | |
| Chat.update(share_id=shared_chat.id).where(Chat.id == chat_id).execute() | |
| ) | |
| return shared_chat if (shared_result and result) else None | |
| def update_shared_chat_by_chat_id(self, chat_id: str) -> Optional[ChatModel]: | |
| try: | |
| print("update_shared_chat_by_id") | |
| chat = Chat.get(Chat.id == chat_id) | |
| print(chat) | |
| query = Chat.update( | |
| title=chat.title, | |
| chat=chat.chat, | |
| ).where(Chat.id == chat.share_id) | |
| query.execute() | |
| chat = Chat.get(Chat.id == chat.share_id) | |
| return ChatModel(**model_to_dict(chat)) | |
| except: | |
| return None | |
| def delete_shared_chat_by_chat_id(self, chat_id: str) -> bool: | |
| try: | |
| query = Chat.delete().where(Chat.user_id == f"shared-{chat_id}") | |
| query.execute() # Remove the rows, return number of rows removed. | |
| return True | |
| except: | |
| return False | |
| def update_chat_share_id_by_id( | |
| self, id: str, share_id: Optional[str] | |
| ) -> Optional[ChatModel]: | |
| try: | |
| query = Chat.update( | |
| share_id=share_id, | |
| ).where(Chat.id == id) | |
| query.execute() | |
| chat = Chat.get(Chat.id == id) | |
| return ChatModel(**model_to_dict(chat)) | |
| except: | |
| return None | |
| def toggle_chat_archive_by_id(self, id: str) -> Optional[ChatModel]: | |
| try: | |
| chat = self.get_chat_by_id(id) | |
| query = Chat.update( | |
| archived=(not chat.archived), | |
| ).where(Chat.id == id) | |
| query.execute() | |
| chat = Chat.get(Chat.id == id) | |
| return ChatModel(**model_to_dict(chat)) | |
| except: | |
| return None | |
| def archive_all_chats_by_user_id(self, user_id: str) -> bool: | |
| try: | |
| chats = self.get_chats_by_user_id(user_id) | |
| for chat in chats: | |
| query = Chat.update( | |
| archived=True, | |
| ).where(Chat.id == chat.id) | |
| query.execute() | |
| return True | |
| except: | |
| return False | |
| def get_archived_chat_list_by_user_id( | |
| self, user_id: str, skip: int = 0, limit: int = 50 | |
| ) -> List[ChatModel]: | |
| return [ | |
| ChatModel(**model_to_dict(chat)) | |
| for chat in Chat.select() | |
| .where(Chat.archived == True) | |
| .where(Chat.user_id == user_id) | |
| .order_by(Chat.updated_at.desc()) | |
| # .limit(limit) | |
| # .offset(skip) | |
| ] | |
| def get_chat_list_by_user_id( | |
| self, | |
| user_id: str, | |
| include_archived: bool = False, | |
| skip: int = 0, | |
| limit: int = 50, | |
| ) -> List[ChatModel]: | |
| if include_archived: | |
| return [ | |
| ChatModel(**model_to_dict(chat)) | |
| for chat in Chat.select() | |
| .where(Chat.user_id == user_id) | |
| .order_by(Chat.updated_at.desc()) | |
| # .limit(limit) | |
| # .offset(skip) | |
| ] | |
| else: | |
| return [ | |
| ChatModel(**model_to_dict(chat)) | |
| for chat in Chat.select() | |
| .where(Chat.archived == False) | |
| .where(Chat.user_id == user_id) | |
| .order_by(Chat.updated_at.desc()) | |
| # .limit(limit) | |
| # .offset(skip) | |
| ] | |
| def get_chat_list_by_chat_ids( | |
| self, chat_ids: List[str], skip: int = 0, limit: int = 50 | |
| ) -> List[ChatModel]: | |
| return [ | |
| ChatModel(**model_to_dict(chat)) | |
| for chat in Chat.select() | |
| .where(Chat.archived == False) | |
| .where(Chat.id.in_(chat_ids)) | |
| .order_by(Chat.updated_at.desc()) | |
| ] | |
| def get_chat_by_id(self, id: str) -> Optional[ChatModel]: | |
| try: | |
| chat = Chat.get(Chat.id == id) | |
| return ChatModel(**model_to_dict(chat)) | |
| except: | |
| return None | |
| def get_chat_by_share_id(self, id: str) -> Optional[ChatModel]: | |
| try: | |
| chat = Chat.get(Chat.share_id == id) | |
| if chat: | |
| chat = Chat.get(Chat.id == id) | |
| return ChatModel(**model_to_dict(chat)) | |
| else: | |
| return None | |
| except: | |
| return None | |
| def get_chat_by_id_and_user_id(self, id: str, user_id: str) -> Optional[ChatModel]: | |
| try: | |
| chat = Chat.get(Chat.id == id, Chat.user_id == user_id) | |
| return ChatModel(**model_to_dict(chat)) | |
| except: | |
| return None | |
| def get_chats(self, skip: int = 0, limit: int = 50) -> List[ChatModel]: | |
| return [ | |
| ChatModel(**model_to_dict(chat)) | |
| for chat in Chat.select().order_by(Chat.updated_at.desc()) | |
| # .limit(limit).offset(skip) | |
| ] | |
| def get_chats_by_user_id(self, user_id: str) -> List[ChatModel]: | |
| return [ | |
| ChatModel(**model_to_dict(chat)) | |
| for chat in Chat.select() | |
| .where(Chat.user_id == user_id) | |
| .order_by(Chat.updated_at.desc()) | |
| # .limit(limit).offset(skip) | |
| ] | |
| def get_archived_chats_by_user_id(self, user_id: str) -> List[ChatModel]: | |
| return [ | |
| ChatModel(**model_to_dict(chat)) | |
| for chat in Chat.select() | |
| .where(Chat.archived == True) | |
| .where(Chat.user_id == user_id) | |
| .order_by(Chat.updated_at.desc()) | |
| ] | |
| def delete_chat_by_id(self, id: str) -> bool: | |
| try: | |
| query = Chat.delete().where((Chat.id == id)) | |
| query.execute() # Remove the rows, return number of rows removed. | |
| return True and self.delete_shared_chat_by_chat_id(id) | |
| except: | |
| return False | |
| def delete_chat_by_id_and_user_id(self, id: str, user_id: str) -> bool: | |
| try: | |
| query = Chat.delete().where((Chat.id == id) & (Chat.user_id == user_id)) | |
| query.execute() # Remove the rows, return number of rows removed. | |
| return True and self.delete_shared_chat_by_chat_id(id) | |
| except: | |
| return False | |
| def delete_chats_by_user_id(self, user_id: str) -> bool: | |
| try: | |
| self.delete_shared_chats_by_user_id(user_id) | |
| query = Chat.delete().where(Chat.user_id == user_id) | |
| query.execute() # Remove the rows, return number of rows removed. | |
| return True | |
| except: | |
| return False | |
| def delete_shared_chats_by_user_id(self, user_id: str) -> bool: | |
| try: | |
| shared_chat_ids = [ | |
| f"shared-{chat.id}" | |
| for chat in Chat.select().where(Chat.user_id == user_id) | |
| ] | |
| query = Chat.delete().where(Chat.user_id << shared_chat_ids) | |
| query.execute() # Remove the rows, return number of rows removed. | |
| return True | |
| except: | |
| return False | |
| Chats = ChatTable(DB) | |