|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
import os |
|
import pathlib |
|
import re |
|
|
|
import flask |
|
from flask import request |
|
from flask_login import login_required, current_user |
|
|
|
from api.db.services.document_service import DocumentService |
|
from api.db.services.file2document_service import File2DocumentService |
|
from api.utils.api_utils import server_error_response, get_data_error_result, validate_request |
|
from api.utils import get_uuid |
|
from api.db import FileType, FileSource |
|
from api.db.services import duplicate_name |
|
from api.db.services.file_service import FileService |
|
from api import settings |
|
from api.utils.api_utils import get_json_result |
|
from api.utils.file_utils import filename_type |
|
from rag.utils.storage_factory import STORAGE_IMPL |
|
|
|
|
|
@manager.route('/upload', methods=['POST']) |
|
@login_required |
|
|
|
def upload(): |
|
pf_id = request.form.get("parent_id") |
|
|
|
if not pf_id: |
|
root_folder = FileService.get_root_folder(current_user.id) |
|
pf_id = root_folder["id"] |
|
|
|
if 'file' not in request.files: |
|
return get_json_result( |
|
data=False, message='No file part!', code=settings.RetCode.ARGUMENT_ERROR) |
|
file_objs = request.files.getlist('file') |
|
|
|
for file_obj in file_objs: |
|
if file_obj.filename == '': |
|
return get_json_result( |
|
data=False, message='No file selected!', code=settings.RetCode.ARGUMENT_ERROR) |
|
file_res = [] |
|
try: |
|
for file_obj in file_objs: |
|
e, file = FileService.get_by_id(pf_id) |
|
if not e: |
|
return get_data_error_result( |
|
message="Can't find this folder!") |
|
MAX_FILE_NUM_PER_USER = int(os.environ.get('MAX_FILE_NUM_PER_USER', 0)) |
|
if MAX_FILE_NUM_PER_USER > 0 and DocumentService.get_doc_count(current_user.id) >= MAX_FILE_NUM_PER_USER: |
|
return get_data_error_result( |
|
message="Exceed the maximum file number of a free user!") |
|
|
|
|
|
if not file_obj.filename: |
|
e, file = FileService.get_by_id(pf_id) |
|
file_obj_names = [file.name, file_obj.filename] |
|
else: |
|
full_path = '/' + file_obj.filename |
|
file_obj_names = full_path.split('/') |
|
file_len = len(file_obj_names) |
|
|
|
|
|
file_id_list = FileService.get_id_list_by_id(pf_id, file_obj_names, 1, [pf_id]) |
|
len_id_list = len(file_id_list) |
|
|
|
|
|
if file_len != len_id_list: |
|
e, file = FileService.get_by_id(file_id_list[len_id_list - 1]) |
|
if not e: |
|
return get_data_error_result(message="Folder not found!") |
|
last_folder = FileService.create_folder(file, file_id_list[len_id_list - 1], file_obj_names, |
|
len_id_list) |
|
else: |
|
e, file = FileService.get_by_id(file_id_list[len_id_list - 2]) |
|
if not e: |
|
return get_data_error_result(message="Folder not found!") |
|
last_folder = FileService.create_folder(file, file_id_list[len_id_list - 2], file_obj_names, |
|
len_id_list) |
|
|
|
|
|
filetype = filename_type(file_obj_names[file_len - 1]) |
|
location = file_obj_names[file_len - 1] |
|
while STORAGE_IMPL.obj_exist(last_folder.id, location): |
|
location += "_" |
|
blob = file_obj.read() |
|
filename = duplicate_name( |
|
FileService.query, |
|
name=file_obj_names[file_len - 1], |
|
parent_id=last_folder.id) |
|
file = { |
|
"id": get_uuid(), |
|
"parent_id": last_folder.id, |
|
"tenant_id": current_user.id, |
|
"created_by": current_user.id, |
|
"type": filetype, |
|
"name": filename, |
|
"location": location, |
|
"size": len(blob), |
|
} |
|
file = FileService.insert(file) |
|
STORAGE_IMPL.put(last_folder.id, location, blob) |
|
file_res.append(file.to_json()) |
|
return get_json_result(data=file_res) |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/create', methods=['POST']) |
|
@login_required |
|
@validate_request("name") |
|
def create(): |
|
req = request.json |
|
pf_id = request.json.get("parent_id") |
|
input_file_type = request.json.get("type") |
|
if not pf_id: |
|
root_folder = FileService.get_root_folder(current_user.id) |
|
pf_id = root_folder["id"] |
|
|
|
try: |
|
if not FileService.is_parent_folder_exist(pf_id): |
|
return get_json_result( |
|
data=False, message="Parent Folder Doesn't Exist!", code=settings.RetCode.OPERATING_ERROR) |
|
if FileService.query(name=req["name"], parent_id=pf_id): |
|
return get_data_error_result( |
|
message="Duplicated folder name in the same folder.") |
|
|
|
if input_file_type == FileType.FOLDER.value: |
|
file_type = FileType.FOLDER.value |
|
else: |
|
file_type = FileType.VIRTUAL.value |
|
|
|
file = FileService.insert({ |
|
"id": get_uuid(), |
|
"parent_id": pf_id, |
|
"tenant_id": current_user.id, |
|
"created_by": current_user.id, |
|
"name": req["name"], |
|
"location": "", |
|
"size": 0, |
|
"type": file_type |
|
}) |
|
|
|
return get_json_result(data=file.to_json()) |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/list', methods=['GET']) |
|
@login_required |
|
def list_files(): |
|
pf_id = request.args.get("parent_id") |
|
|
|
keywords = request.args.get("keywords", "") |
|
|
|
page_number = int(request.args.get("page", 1)) |
|
items_per_page = int(request.args.get("page_size", 15)) |
|
orderby = request.args.get("orderby", "create_time") |
|
desc = request.args.get("desc", True) |
|
if not pf_id: |
|
root_folder = FileService.get_root_folder(current_user.id) |
|
pf_id = root_folder["id"] |
|
FileService.init_knowledgebase_docs(pf_id, current_user.id) |
|
try: |
|
e, file = FileService.get_by_id(pf_id) |
|
if not e: |
|
return get_data_error_result(message="Folder not found!") |
|
|
|
files, total = FileService.get_by_pf_id( |
|
current_user.id, pf_id, page_number, items_per_page, orderby, desc, keywords) |
|
|
|
parent_folder = FileService.get_parent_folder(pf_id) |
|
if not FileService.get_parent_folder(pf_id): |
|
return get_json_result(message="File not found!") |
|
|
|
return get_json_result(data={"total": total, "files": files, "parent_folder": parent_folder.to_json()}) |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/root_folder', methods=['GET']) |
|
@login_required |
|
def get_root_folder(): |
|
try: |
|
root_folder = FileService.get_root_folder(current_user.id) |
|
return get_json_result(data={"root_folder": root_folder}) |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/parent_folder', methods=['GET']) |
|
@login_required |
|
def get_parent_folder(): |
|
file_id = request.args.get("file_id") |
|
try: |
|
e, file = FileService.get_by_id(file_id) |
|
if not e: |
|
return get_data_error_result(message="Folder not found!") |
|
|
|
parent_folder = FileService.get_parent_folder(file_id) |
|
return get_json_result(data={"parent_folder": parent_folder.to_json()}) |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/all_parent_folder', methods=['GET']) |
|
@login_required |
|
def get_all_parent_folders(): |
|
file_id = request.args.get("file_id") |
|
try: |
|
e, file = FileService.get_by_id(file_id) |
|
if not e: |
|
return get_data_error_result(message="Folder not found!") |
|
|
|
parent_folders = FileService.get_all_parent_folders(file_id) |
|
parent_folders_res = [] |
|
for parent_folder in parent_folders: |
|
parent_folders_res.append(parent_folder.to_json()) |
|
return get_json_result(data={"parent_folders": parent_folders_res}) |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/rm', methods=['POST']) |
|
@login_required |
|
@validate_request("file_ids") |
|
def rm(): |
|
req = request.json |
|
file_ids = req["file_ids"] |
|
try: |
|
for file_id in file_ids: |
|
e, file = FileService.get_by_id(file_id) |
|
if not e: |
|
return get_data_error_result(message="File or Folder not found!") |
|
if not file.tenant_id: |
|
return get_data_error_result(message="Tenant not found!") |
|
if file.source_type == FileSource.KNOWLEDGEBASE: |
|
continue |
|
|
|
if file.type == FileType.FOLDER.value: |
|
file_id_list = FileService.get_all_innermost_file_ids(file_id, []) |
|
for inner_file_id in file_id_list: |
|
e, file = FileService.get_by_id(inner_file_id) |
|
if not e: |
|
return get_data_error_result(message="File not found!") |
|
STORAGE_IMPL.rm(file.parent_id, file.location) |
|
FileService.delete_folder_by_pf_id(current_user.id, file_id) |
|
else: |
|
if not FileService.delete(file): |
|
return get_data_error_result( |
|
message="Database error (File removal)!") |
|
|
|
|
|
informs = File2DocumentService.get_by_file_id(file_id) |
|
for inform in informs: |
|
doc_id = inform.document_id |
|
e, doc = DocumentService.get_by_id(doc_id) |
|
if not e: |
|
return get_data_error_result(message="Document not found!") |
|
tenant_id = DocumentService.get_tenant_id(doc_id) |
|
if not tenant_id: |
|
return get_data_error_result(message="Tenant not found!") |
|
if not DocumentService.remove_document(doc, tenant_id): |
|
return get_data_error_result( |
|
message="Database error (Document removal)!") |
|
File2DocumentService.delete_by_file_id(file_id) |
|
|
|
return get_json_result(data=True) |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/rename', methods=['POST']) |
|
@login_required |
|
@validate_request("file_id", "name") |
|
def rename(): |
|
req = request.json |
|
try: |
|
e, file = FileService.get_by_id(req["file_id"]) |
|
if not e: |
|
return get_data_error_result(message="File not found!") |
|
if file.type != FileType.FOLDER.value \ |
|
and pathlib.Path(req["name"].lower()).suffix != pathlib.Path( |
|
file.name.lower()).suffix: |
|
return get_json_result( |
|
data=False, |
|
message="The extension of file can't be changed", |
|
code=settings.RetCode.ARGUMENT_ERROR) |
|
for file in FileService.query(name=req["name"], pf_id=file.parent_id): |
|
if file.name == req["name"]: |
|
return get_data_error_result( |
|
message="Duplicated file name in the same folder.") |
|
|
|
if not FileService.update_by_id( |
|
req["file_id"], {"name": req["name"]}): |
|
return get_data_error_result( |
|
message="Database error (File rename)!") |
|
|
|
informs = File2DocumentService.get_by_file_id(req["file_id"]) |
|
if informs: |
|
if not DocumentService.update_by_id( |
|
informs[0].document_id, {"name": req["name"]}): |
|
return get_data_error_result( |
|
message="Database error (Document rename)!") |
|
|
|
return get_json_result(data=True) |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/get/<file_id>', methods=['GET']) |
|
@login_required |
|
def get(file_id): |
|
try: |
|
e, file = FileService.get_by_id(file_id) |
|
if not e: |
|
return get_data_error_result(message="Document not found!") |
|
|
|
blob = STORAGE_IMPL.get(file.parent_id, file.location) |
|
if not blob: |
|
b, n = File2DocumentService.get_storage_address(file_id=file_id) |
|
blob = STORAGE_IMPL.get(b, n) |
|
|
|
response = flask.make_response(blob) |
|
ext = re.search(r"\.([^.]+)$", file.name) |
|
if ext: |
|
if file.type == FileType.VISUAL.value: |
|
response.headers.set('Content-Type', 'image/%s' % ext.group(1)) |
|
else: |
|
response.headers.set( |
|
'Content-Type', |
|
'application/%s' % |
|
ext.group(1)) |
|
return response |
|
except Exception as e: |
|
return server_error_response(e) |
|
|
|
|
|
@manager.route('/mv', methods=['POST']) |
|
@login_required |
|
@validate_request("src_file_ids", "dest_file_id") |
|
def move(): |
|
req = request.json |
|
try: |
|
file_ids = req["src_file_ids"] |
|
parent_id = req["dest_file_id"] |
|
for file_id in file_ids: |
|
e, file = FileService.get_by_id(file_id) |
|
if not e: |
|
return get_data_error_result(message="File or Folder not found!") |
|
if not file.tenant_id: |
|
return get_data_error_result(message="Tenant not found!") |
|
fe, _ = FileService.get_by_id(parent_id) |
|
if not fe: |
|
return get_data_error_result(message="Parent Folder not found!") |
|
FileService.move_file(file_ids, parent_id) |
|
return get_json_result(data=True) |
|
except Exception as e: |
|
return server_error_response(e) |