Logo
Explore Help
Register Sign In
MOPC/MOPC-Portal
1
0
Fork 0
You've already forked MOPC-Portal
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
MOPC-Portal/prisma/migrations/20260217100000_add_document_analysis_fields/migration.sql

6 lines
265 B
MySQL
Raw Permalink Normal View History

Add document analysis: page count, text extraction & language detection Introduces a document analyzer service that extracts page count (via pdf-parse), text preview, and detected language (via franc) from uploaded files. Analysis runs automatically on upload (configurable via SystemSettings) and can be triggered retroactively for existing files. Results are displayed as badges in the FileViewer and fed to AI screening for language-based filtering criteria. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-17 10:08:04 +01:00
-- AlterTable
ALTER TABLE "ProjectFile" ADD COLUMN "textPreview" TEXT;
ALTER TABLE "ProjectFile" ADD COLUMN "detectedLang" TEXT;
ALTER TABLE "ProjectFile" ADD COLUMN "langConfidence" DOUBLE PRECISION;
ALTER TABLE "ProjectFile" ADD COLUMN "analyzedAt" TIMESTAMP(3);
Reference in New Issue Copy Permalink
Powered by Gitea Version: 1.25.4 Page: 50ms Template: 2ms
English
Bahasa Indonesia Deutsch English Español Français Gaeilge Italiano Latviešu Magyar nyelv Nederlands Polski Português de Portugal Português do Brasil Suomi Svenska Türkçe Čeština Ελληνικά Български Русский Українська فارسی മലയാളം 日本語 简体中文 繁體中文(台灣) 繁體中文(香港) 한국어
Licenses API