Files
dbx-main/tests/test_project_drive_files.py
king bca1082c26 feat(project): 업무를 옮기면 설명 링크 속 드라이브 파일도 새 폴더로
업무의 섹션·프로젝트가 바뀌거나 세부 업무를 다른 상위 업무로 옮기면
드라이브 폴더 경로(프로젝트/섹션/업무/세부 업무)가 달라지는데 파일은
예전 폴더에 남았다. 이동 API(업무 수정·move-parent·move-project) 뒤
백그라운드로 업무와 모든 하위 업무의 설명 링크 파일을 새 폴더로 옮긴다.
그 업무가 올린 파일(appProperties dbxTaskId)만 옮기고, 예전 폴더는 둔다.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-10-20 12:32:06 +09:00

245 lines
12 KiB
Python

"""업무 파일 → 구글 드라이브(2026-10-19) — 폴더 경로·업로드 API·설명 링크 append·링크 지우면 휴지통. DB·Google 없이 가짜로."""
import importlib
import tempfile
import unittest
from unittest.mock import MagicMock, patch
from fastapi import FastAPI
from fastapi.testclient import TestClient
from app.integrations import google_drive
api = importlib.import_module("app.modules.project.router")
ME = {"email": "me@test.local", "role": "user"}
class FakeDrive:
enabled = True
reason = ""
def __init__(self):
self.paths, self.uploads, self.trash = [], [], []
self.meta = {}
def ensure_folder_path(self, names, root=None):
self.paths.append(list(names))
return "FOLDER"
def upload(self, *, folder_id, name, stream, mimetype, task_id):
self.uploads.append({"folder": folder_id, "name": name, "data": stream.read(), "task_id": task_id})
fid = "F%dabcdefghij" % len(self.uploads)
return {"id": fid, "name": name, "url": google_drive.file_url(fid)}
def ours(self, file_id):
return self.meta.get(file_id)
def set_trashed(self, file_id, trashed):
self.trash.append((file_id, trashed))
def move_to(self, file_id, folder_id, *, task_id):
self.moves = getattr(self, "moves", []) + [(file_id, folder_id, task_id)]
return True
class Store(MagicMock):
TASKS = {
1: {"id": 1, "project_id": 7, "project_name": "신제품", "stage_name": "기획", "title": "패키지 디자인",
"parent_task_id": None, "description": "<p>기존</p>"},
2: {"id": 2, "project_id": 7, "project_name": "신제품", "stage_name": None, "title": "시안 A",
"parent_task_id": 1, "description": ""},
}
def get_task(self, task_id):
t = self.TASKS.get(int(task_id))
return dict(t) if t else None
class Base(unittest.TestCase):
def setUp(self):
self.st = Store()
self.st.update_task.side_effect = lambda task_id, fields, actor, assignee_allowed=None: {
**self.st.get_task(task_id), **fields}
self.drive = FakeDrive()
app = FastAPI()
app.include_router(api.router)
app.state.project_store = self.st
app.state.data_dir = tempfile.mkdtemp(prefix="pj-drive-")
self.client = TestClient(app, raise_server_exceptions=False)
for p in (patch.object(api, "_require_user", return_value=ME), patch.object(api, "_db_or_503", return_value=self.st),
patch.object(api, "_require_task", return_value="full"),
patch.object(google_drive, "get_client", return_value=self.drive)):
p.start()
self.addCleanup(p.stop)
class HelperTests(unittest.TestCase):
def test_file_ids_in_description(self):
html = ('<p><a href="https://drive.google.com/file/d/AbC_12-xyz9/view" target="_blank">a.pdf</a> '
'<a href="https://example.com/file/d/zzzzzzzzzzzz/view">x</a></p>')
self.assertEqual(google_drive.file_ids_in(html), {"AbC_12-xyz9"})
self.assertEqual(google_drive.file_ids_in(""), set())
def test_folder_name_and_query_escape(self):
self.assertEqual(google_drive.folder_name(" 기획\n 2차 "), "기획 2차")
self.assertEqual(google_drive.folder_name(""), "(이름 없음)")
self.assertEqual(google_drive._q("A's \\ b"), "A\\'s \\\\ b")
def test_folder_path_project_section_task_subtask(self):
st = Store()
self.assertEqual(api._drive_folder_names(st, st.get_task(1)), ["신제품", "기획", "패키지 디자인"])
# 세부 업무 = 맨 위 업무의 섹션 + 업무 + 세부 업무
self.assertEqual(api._drive_folder_names(st, st.get_task(2)), ["신제품", "기획", "패키지 디자인", "시안 A"])
def test_link_html_escapes_name(self):
html = api.drive_link_html("https://drive.google.com/file/d/X1234567890/view", "<견적>.pdf")
self.assertIn("&lt;견적&gt;.pdf</a>", html)
self.assertIn('target="_blank"', html)
class UploadApiTests(Base):
def test_upload_returns_link_without_touching_description(self):
r = self.client.post("/project/api/tasks/1/drive-files", files={"file": ("도면 v2.dwg", b"abc", "application/acad")})
self.assertEqual(r.status_code, 201, r.text)
body = r.json()
self.assertEqual(body["file"]["name"], "도면 v2.dwg")
self.assertTrue(body["file"]["url"].startswith("https://drive.google.com/file/d/"))
self.assertEqual(self.drive.paths, [["신제품", "기획", "패키지 디자인"]])
self.assertEqual(self.drive.uploads[0]["data"], b"abc")
self.assertEqual(self.drive.uploads[0]["task_id"], 1)
self.st.update_task.assert_not_called()
def test_upload_append_adds_link_to_subtask_description(self):
r = self.client.post("/project/api/tasks/2/drive-files", files={"file": ("시안.png", b"png", "image/png")},
data={"append": "true"})
self.assertEqual(r.status_code, 201, r.text)
self.assertEqual(self.drive.paths, [["신제품", "기획", "패키지 디자인", "시안 A"]])
fields = self.st.update_task.call_args.kwargs["fields"]
self.assertIn('href="https://drive.google.com/file/d/F1abcdefghij/view"', fields["description"])
self.assertIn(">시안.png</a>", fields["description"])
self.assertEqual(r.json()["task"]["description"], fields["description"])
def test_empty_file_and_disabled_drive(self):
r = self.client.post("/project/api/tasks/1/drive-files", files={"file": ("a.txt", b"", "text/plain")})
self.assertEqual(r.status_code, 400)
self.drive.enabled = False
self.drive.reason = "Google 인증 미설정"
r = self.client.post("/project/api/tasks/1/drive-files", files={"file": ("a.txt", b"x", "text/plain")})
self.assertEqual(r.status_code, 503)
self.assertIn("Google 인증 미설정", r.json()["detail"])
def test_drive_error_is_502_with_message(self):
self.drive.ensure_folder_path = MagicMock(side_effect=google_drive.GoogleDriveError("업무 파일 폴더를 찾을 수 없습니다"))
r = self.client.post("/project/api/tasks/1/drive-files", files={"file": ("a.txt", b"x", "text/plain")})
self.assertEqual(r.status_code, 502)
self.assertIn("폴더", r.json()["detail"])
class LinkSyncTests(Base):
def test_removed_link_trashes_our_file_added_link_restores(self):
self.drive.meta = {"GONE1234567": {"trashed": False, "task_id": "1"},
"BACK1234567": {"trashed": True, "task_id": "1"},
"KEEP1234567": {"trashed": False, "task_id": "1"},
"OTHER123456": None}
self.st.description_mentions.side_effect = lambda text, exclude_task_id: text == "KEEP1234567"
api._sync_drive_links(self.st, 1, {"GONE1234567", "KEEP1234567", "OTHER123456"}, {"BACK1234567"})
self.assertIn(("GONE1234567", True), self.drive.trash)
self.assertIn(("BACK1234567", False), self.drive.trash)
# 다른 업무 설명에 남은 링크·우리가 올리지 않은 파일은 그대로
self.assertNotIn(("KEEP1234567", True), self.drive.trash)
self.assertNotIn(("OTHER123456", True), self.drive.trash)
def test_description_save_schedules_sync(self):
old = '<p><a href="https://drive.google.com/file/d/GONE1234567/view">a.pdf</a></p>'
self.st.TASKS = {1: {**Store.TASKS[1], "description": old}}
with patch.object(api, "_sync_drive_links") as sync, patch.object(api, "_record_mentions", return_value=[]):
r = self.client.put("/project/api/tasks/1", json={"description": "<p>링크 지움</p>"})
self.assertEqual(r.status_code, 200, r.text)
sync.assert_called_once()
_, task_id, removed, added = sync.call_args.args
self.assertEqual((task_id, removed, added), (1, {"GONE1234567"}, set()))
def test_description_save_without_link_change_does_not_sync(self):
with patch.object(api, "_sync_drive_links") as sync, patch.object(api, "_record_mentions", return_value=[]):
r = self.client.put("/project/api/tasks/1", json={"description": "<p>글만 바뀜</p>"})
self.assertEqual(r.status_code, 200, r.text)
sync.assert_not_called()
def _link(fid):
return f'<p><a href="https://drive.google.com/file/d/{fid}/view">{fid}.pdf</a></p>'
class RelocateTests(Base):
"""업무·세부 업무를 옮기면 설명란 링크 속 드라이브 파일도 새 폴더로(2026-10-20)."""
def test_relocate_moves_files_of_task_and_subtasks_to_their_folders(self):
self.st.TASKS = {1: {**Store.TASKS[1], "stage_name": "제작", "description": _link("TOPFILE1234")},
2: {**Store.TASKS[2], "description": _link("SUBFILE1234") + _link("SUB2FILE123")}}
self.st.task_subtree_ids.return_value = [1, 2]
paths = {}
self.drive.ensure_folder_path = lambda names, root=None: paths.setdefault("/".join(names), "D%d" % len(paths))
api._relocate_drive_files(self.st, 1)
self.assertEqual(paths, {"신제품/제작/패키지 디자인": "D0", "신제품/제작/패키지 디자인/시안 A": "D1"})
self.assertEqual(sorted(self.drive.moves), [("SUB2FILE123", "D1", 2), ("SUBFILE1234", "D1", 2),
("TOPFILE1234", "D0", 1)])
def test_relocate_skips_tasks_without_links_and_disabled_drive(self):
self.st.task_subtree_ids.return_value = [1, 2]
api._relocate_drive_files(self.st, 1) # 링크 없음 — 폴더도 안 만듦
self.assertEqual(self.drive.paths, [])
self.drive.enabled = False
self.st.task_subtree_ids.reset_mock()
api._relocate_drive_files(self.st, 1)
self.st.task_subtree_ids.assert_not_called()
def test_section_change_schedules_relocate_but_title_change_does_not(self):
self.st.TASKS = {1: {**Store.TASKS[1], "stage_id": 3}}
with patch.object(api, "_relocate_drive_files") as rel:
r = self.client.put("/project/api/tasks/1", json={"stage_id": 4})
self.assertEqual(r.status_code, 200, r.text)
rel.assert_called_once()
self.assertEqual(rel.call_args.args[1], 1)
rel.reset_mock()
r = self.client.put("/project/api/tasks/1", json={"title": "새 이름"})
self.assertEqual(r.status_code, 200, r.text)
rel.assert_not_called()
def test_move_subtask_to_other_parent_schedules_relocate(self):
self.st.move_subtask.return_value = {**Store.TASKS[2], "parent_task_id": 5}
with patch.object(api, "_relocate_drive_files") as rel:
r = self.client.post("/project/api/tasks/2/move-parent", json={"parent_task_id": 5})
self.assertEqual(r.status_code, 200, r.text)
rel.assert_called_once()
self.assertEqual(rel.call_args.args[1], 2)
class MoveToTests(unittest.TestCase):
"""GoogleDriveFiles.move_to — 그 업무가 올린 파일만, 부모 교체."""
def _client(self, meta):
c = google_drive.GoogleDriveFiles.__new__(google_drive.GoogleDriveFiles)
c.enabled, c.reason = True, ""
svc = MagicMock()
svc.files.return_value.get.return_value.execute.return_value = meta
c._service = lambda: svc
return c, svc
def test_moves_own_file(self):
c, svc = self._client({"parents": ["OLD"], "appProperties": {"dbxTaskId": "7"}})
self.assertTrue(c.move_to("F1", "NEW", task_id=7))
kw = svc.files.return_value.update.call_args.kwargs
self.assertEqual((kw["addParents"], kw["removeParents"]), ("NEW", "OLD"))
def test_skips_other_task_file_and_same_folder(self):
c, svc = self._client({"parents": ["OLD"], "appProperties": {"dbxTaskId": "8"}})
self.assertFalse(c.move_to("F1", "NEW", task_id=7))
c, svc = self._client({"parents": ["NEW"], "appProperties": {"dbxTaskId": "7"}})
self.assertFalse(c.move_to("F1", "NEW", task_id=7))
c, svc = self._client({"parents": ["OLD"]})
self.assertFalse(c.move_to("F1", "NEW", task_id=7))
svc.files.return_value.update.assert_not_called()
if __name__ == "__main__":
unittest.main()