Files
SakuraHub/tests/test_ocr_gallery_search.py
2026-11-16 20:45:22 +08:00

184 lines
7.3 KiB
Python

from __future__ import annotations
import tempfile
from pathlib import Path
from unittest import TestCase
from fastapi import FastAPI
from fastapi.testclient import TestClient
from sqlalchemy import create_engine, select
from sqlalchemy.orm import sessionmaker
from sakura_cloud.api.v1.router import api_router
from sakura_cloud.core.config import settings
from sakura_cloud.core.security import create_access_token
from sakura_cloud.db.base import Base
from sakura_cloud.db.session import get_db
from sakura_cloud.models.artwork import Artwork
from sakura_cloud.models.ocr import ArtworkOcrText
from sakura_cloud.models.user import User, UserRole
from sakura_cloud.services.ocr import run_ocr_for_artwork
class OcrGallerySearchTest(TestCase):
def setUp(self) -> None:
self.temp_dir = tempfile.TemporaryDirectory()
self.root = Path(self.temp_dir.name)
self.db_path = self.root / "cloud.db"
self.image_path = self.root / "image.jpg"
self.text_path = self.root / "note.txt"
self.image_path.write_bytes(b"fake image")
self.text_path.write_text("not image", encoding="utf-8")
self.engine = create_engine(f"sqlite:///{self.db_path}", connect_args={"check_same_thread": False})
self.SessionLocal = sessionmaker(bind=self.engine, autoflush=False, autocommit=False)
Base.metadata.create_all(self.engine)
self.old_ocr_enabled = settings.ocr_enabled
settings.ocr_enabled = True
self.app = FastAPI()
self.app.include_router(api_router, prefix=settings.api_prefix)
self.app.dependency_overrides[get_db] = self._override_db
self.client = TestClient(self.app)
self.user_a_id = "user-a"
self.user_b_id = "user-b"
self.art_a_id = "art-a"
self.art_b_id = "art-b"
self.text_art_id = "text-art"
with self.SessionLocal() as db:
db.add_all(
[
User(
id=self.user_a_id,
username="alice",
email="alice@example.test",
password_hash="unused",
role=UserRole.USER,
),
User(
id=self.user_b_id,
username="bob",
email="bob@example.test",
password_hash="unused",
role=UserRole.USER,
),
Artwork(
id=self.art_a_id,
user_id=self.user_a_id,
source_platform="pixiv",
source_id="100",
content_type="illust",
title="Sakura",
file_path=str(self.image_path),
file_size=10,
mime_type="image/jpeg",
tags=["flower"],
artwork_metadata={},
),
Artwork(
id=self.art_b_id,
user_id=self.user_b_id,
source_platform="pixiv",
source_id="200",
content_type="illust",
title="Other",
file_path=str(self.image_path),
file_size=10,
mime_type="image/jpeg",
tags=[],
artwork_metadata={},
),
Artwork(
id=self.text_art_id,
user_id=self.user_a_id,
source_platform="pixiv",
content_type="illust",
title="Text file",
file_path=str(self.text_path),
file_size=8,
mime_type="text/plain",
tags=[],
artwork_metadata={},
),
]
)
db.commit()
self.auth_a = {"Authorization": f"Bearer {create_access_token(self.user_a_id)}"}
self.auth_b = {"Authorization": f"Bearer {create_access_token(self.user_b_id)}"}
def tearDown(self) -> None:
self.client.close()
self.engine.dispose()
settings.ocr_enabled = self.old_ocr_enabled
self.temp_dir.cleanup()
def _override_db(self):
db = self.SessionLocal()
try:
yield db
finally:
db.close()
def test_ocr_result_is_saved_and_searchable_by_scope(self) -> None:
with self.SessionLocal() as db:
artwork = db.get(Artwork, self.art_a_id)
self.assertIsNotNone(artwork)
row = run_ocr_for_artwork(
db,
artwork,
extractor=lambda _path: ("舰娘 远征记录", 0.92, "ch"),
)
self.assertEqual(row.status, "done")
self.assertIn("舰娘", row.ocr_text)
ocr_search = self.client.get("/api/v1/gallery?query=舰娘&search_scope=ocr", headers=self.auth_a)
self.assertEqual(ocr_search.status_code, 200)
items = ocr_search.json()["data"]["items"]
self.assertEqual([item["id"] for item in items], [self.art_a_id])
self.assertEqual(items[0]["matched_by"], "ocr")
title_search = self.client.get("/api/v1/gallery?query=舰娘&search_scope=title", headers=self.auth_a)
self.assertEqual(title_search.status_code, 200)
self.assertEqual(title_search.json()["data"]["items"], [])
def test_ocr_data_is_isolated_by_user(self) -> None:
with self.SessionLocal() as db:
artwork = db.get(Artwork, self.art_a_id)
run_ocr_for_artwork(db, artwork, extractor=lambda _path: ("舰娘", 0.9, "ch"))
other_user = self.client.get("/api/v1/gallery?query=舰娘&search_scope=ocr", headers=self.auth_b)
self.assertEqual(other_user.status_code, 200)
self.assertEqual(other_user.json()["data"]["items"], [])
self.assertEqual(self.client.get(f"/api/v1/gallery/{self.art_a_id}/ocr", headers=self.auth_b).status_code, 404)
def test_non_image_file_is_skipped(self) -> None:
with self.SessionLocal() as db:
artwork = db.get(Artwork, self.text_art_id)
row = run_ocr_for_artwork(db, artwork, extractor=lambda _path: ("should not run", 1.0, "ch"))
self.assertEqual(row.status, "failed")
self.assertEqual(row.error, "unsupported_file_type")
stored = db.scalar(select(ArtworkOcrText).where(ArtworkOcrText.artwork_id == self.text_art_id))
self.assertIsNotNone(stored)
self.assertEqual(stored.ocr_text, "")
def test_ocr_failure_does_not_block_gallery_create(self) -> None:
settings.ocr_enabled = False
response = self.client.post(
"/api/v1/gallery",
headers=self.auth_a,
json={
"source_platform": "pixiv",
"content_type": "illust",
"title": "New upload",
"file_path": str(self.image_path),
"file_size": 10,
"mime_type": "image/jpeg",
"tags": [],
"metadata": {},
},
)
self.assertEqual(response.status_code, 201)