file_service.py 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  1. import datetime
  2. import hashlib
  3. import time
  4. import uuid
  5. from cachetools import TTLCache
  6. from flask import request, current_app
  7. from flask_login import current_user
  8. from werkzeug.datastructures import FileStorage
  9. from werkzeug.exceptions import NotFound
  10. from core.data_loader.file_extractor import FileExtractor
  11. from extensions.ext_storage import storage
  12. from extensions.ext_database import db
  13. from models.model import UploadFile
  14. from services.errors.file import FileTooLargeError, UnsupportedFileTypeError
  15. ALLOWED_EXTENSIONS = ['txt', 'markdown', 'md', 'pdf', 'html', 'htm', 'xlsx', 'docx', 'csv']
  16. PREVIEW_WORDS_LIMIT = 3000
  17. cache = TTLCache(maxsize=None, ttl=30)
  18. class FileService:
  19. @staticmethod
  20. def upload_file(file: FileStorage) -> UploadFile:
  21. # read file content
  22. file_content = file.read()
  23. # get file size
  24. file_size = len(file_content)
  25. file_size_limit = current_app.config.get("UPLOAD_FILE_SIZE_LIMIT") * 1024 * 1024
  26. if file_size > file_size_limit:
  27. message = f'File size exceeded. {file_size} > {file_size_limit}'
  28. raise FileTooLargeError(message)
  29. extension = file.filename.split('.')[-1]
  30. if extension.lower() not in ALLOWED_EXTENSIONS:
  31. raise UnsupportedFileTypeError()
  32. # user uuid as file name
  33. file_uuid = str(uuid.uuid4())
  34. file_key = 'upload_files/' + current_user.current_tenant_id + '/' + file_uuid + '.' + extension
  35. # save file to storage
  36. storage.save(file_key, file_content)
  37. # save file to db
  38. config = current_app.config
  39. upload_file = UploadFile(
  40. tenant_id=current_user.current_tenant_id,
  41. storage_type=config['STORAGE_TYPE'],
  42. key=file_key,
  43. name=file.filename,
  44. size=file_size,
  45. extension=extension,
  46. mime_type=file.mimetype,
  47. created_by=current_user.id,
  48. created_at=datetime.datetime.utcnow(),
  49. used=False,
  50. hash=hashlib.sha3_256(file_content).hexdigest()
  51. )
  52. db.session.add(upload_file)
  53. db.session.commit()
  54. return upload_file
  55. @staticmethod
  56. def upload_text(text: str, text_name: str) -> UploadFile:
  57. # user uuid as file name
  58. file_uuid = str(uuid.uuid4())
  59. file_key = 'upload_files/' + current_user.current_tenant_id + '/' + file_uuid + '.txt'
  60. # save file to storage
  61. storage.save(file_key, text.encode('utf-8'))
  62. # save file to db
  63. config = current_app.config
  64. upload_file = UploadFile(
  65. tenant_id=current_user.current_tenant_id,
  66. storage_type=config['STORAGE_TYPE'],
  67. key=file_key,
  68. name=text_name + '.txt',
  69. size=len(text),
  70. extension='txt',
  71. mime_type='text/plain',
  72. created_by=current_user.id,
  73. created_at=datetime.datetime.utcnow(),
  74. used=True,
  75. used_by=current_user.id,
  76. used_at=datetime.datetime.utcnow()
  77. )
  78. db.session.add(upload_file)
  79. db.session.commit()
  80. return upload_file
  81. @staticmethod
  82. def get_file_preview(file_id: str) -> str:
  83. # get file storage key
  84. key = file_id + request.path
  85. cached_response = cache.get(key)
  86. if cached_response and time.time() - cached_response['timestamp'] < cache.ttl:
  87. return cached_response['response']
  88. upload_file = db.session.query(UploadFile) \
  89. .filter(UploadFile.id == file_id) \
  90. .first()
  91. if not upload_file:
  92. raise NotFound("File not found")
  93. # extract text from file
  94. extension = upload_file.extension
  95. if extension.lower() not in ALLOWED_EXTENSIONS:
  96. raise UnsupportedFileTypeError()
  97. text = FileExtractor.load(upload_file, return_text=True)
  98. text = text[0:PREVIEW_WORDS_LIMIT] if text else ''
  99. return text