| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197 | import loggingimport timeimport osimport hmacimport base64import hashlibfrom typing import Union, Tuple, Generatorfrom uuid import uuid4from mimetypes import guess_extension, guess_typefrom httpx import getfrom flask import current_appfrom models.tools import ToolFilefrom models.model import MessageFilefrom extensions.ext_database import dbfrom extensions.ext_storage import storagelogger = logging.getLogger(__name__)class ToolFileManager:    @staticmethod    def sign_file(file_id: str, extension: str) -> str:        """        sign file to get a temporary url        """        base_url = current_app.config.get('FILES_URL')        file_preview_url = f'{base_url}/files/tools/{file_id}{extension}'        timestamp = str(int(time.time()))        nonce = os.urandom(16).hex()        data_to_sign = f"file-preview|{file_id}|{timestamp}|{nonce}"        secret_key = current_app.config['SECRET_KEY'].encode()        sign = hmac.new(secret_key, data_to_sign.encode(), hashlib.sha256).digest()        encoded_sign = base64.urlsafe_b64encode(sign).decode()        return f"{file_preview_url}?timestamp={timestamp}&nonce={nonce}&sign={encoded_sign}"    @staticmethod    def verify_file(file_id: str, timestamp: str, nonce: str, sign: str) -> bool:        """        verify signature        """        data_to_sign = f"file-preview|{file_id}|{timestamp}|{nonce}"        secret_key = current_app.config['SECRET_KEY'].encode()        recalculated_sign = hmac.new(secret_key, data_to_sign.encode(), hashlib.sha256).digest()        recalculated_encoded_sign = base64.urlsafe_b64encode(recalculated_sign).decode()        # verify signature        if sign != recalculated_encoded_sign:            return False        current_time = int(time.time())        return current_time - int(timestamp) <= 300  # expired after 5 minutes    @staticmethod    def create_file_by_raw(user_id: str, tenant_id: str,                             conversation_id: str, file_binary: bytes,                            mimetype: str    ) -> ToolFile:        """        create file        """        extension = guess_extension(mimetype) or '.bin'        unique_name = uuid4().hex        filename = f"/tools/{tenant_id}/{unique_name}{extension}"        storage.save(filename, file_binary)        tool_file = ToolFile(user_id=user_id, tenant_id=tenant_id,                             conversation_id=conversation_id, file_key=filename, mimetype=mimetype)        db.session.add(tool_file)        db.session.commit()        return tool_file        @staticmethod    def create_file_by_url(user_id: str, tenant_id: str,                             conversation_id: str, file_url: str,    ) -> ToolFile:        """        create file        """        # try to download image        response = get(file_url)        response.raise_for_status()        blob = response.content        mimetype = guess_type(file_url)[0] or 'octet/stream'        extension = guess_extension(mimetype) or '.bin'        unique_name = uuid4().hex        filename = f"/tools/{tenant_id}/{unique_name}{extension}"        storage.save(filename, blob)        tool_file = ToolFile(user_id=user_id, tenant_id=tenant_id,                             conversation_id=conversation_id, file_key=filename,                              mimetype=mimetype, original_url=file_url)                db.session.add(tool_file)        db.session.commit()        return tool_file    @staticmethod    def create_file_by_key(user_id: str, tenant_id: str,                             conversation_id: str, file_key: str,                            mimetype: str    ) -> ToolFile:        """        create file        """        tool_file = ToolFile(user_id=user_id, tenant_id=tenant_id,                             conversation_id=conversation_id, file_key=file_key, mimetype=mimetype)        return tool_file        @staticmethod    def get_file_binary(id: str) -> Union[Tuple[bytes, str], None]:        """        get file binary        :param id: the id of the file        :return: the binary of the file, mime type        """        tool_file: ToolFile = db.session.query(ToolFile).filter(            ToolFile.id == id,        ).first()        if not tool_file:            return None        blob = storage.load_once(tool_file.file_key)        return blob, tool_file.mimetype        @staticmethod    def get_file_binary_by_message_file_id(id: str) -> Union[Tuple[bytes, str], None]:        """        get file binary        :param id: the id of the file        :return: the binary of the file, mime type        """        message_file: MessageFile = db.session.query(MessageFile).filter(            MessageFile.id == id,        ).first()        # get tool file id        tool_file_id = message_file.url.split('/')[-1]        # trim extension        tool_file_id = tool_file_id.split('.')[0]        tool_file: ToolFile = db.session.query(ToolFile).filter(            ToolFile.id == tool_file_id,        ).first()        if not tool_file:            return None        blob = storage.load_once(tool_file.file_key)        return blob, tool_file.mimetype            @staticmethod    def get_file_generator_by_message_file_id(id: str) -> Union[Tuple[Generator, str], None]:        """        get file binary        :param id: the id of the file        :return: the binary of the file, mime type        """        message_file: MessageFile = db.session.query(MessageFile).filter(            MessageFile.id == id,        ).first()        # get tool file id        tool_file_id = message_file.url.split('/')[-1]        # trim extension        tool_file_id = tool_file_id.split('.')[0]        tool_file: ToolFile = db.session.query(ToolFile).filter(            ToolFile.id == tool_file_id,        ).first()        if not tool_file:            return None        generator = storage.load_stream(tool_file.file_key)        return generator, tool_file.mimetype    # init tool_file_parserfrom core.file.tool_file_parser import tool_file_managertool_file_manager['manager'] = ToolFileManager
 |