Thoth / server /projects.js
mfirat007's picture
Upload 74 files
4a51f94 verified
Raw History Blame Contribute Delete
11.7 kB
import { randomUUID } from 'node:crypto';
import { Router } from 'express';
import { unzipSync, zipSync } from 'fflate';
import multer from 'multer';
import { SUPPORT_FILES } from './compile.js';
import { db, tx } from './db.js';
import { listFiles, maybeAutoSnapshot, nextRev, putFile, withProject } from './store.js';
import { getTemplate, templateList } from './templates.js';
import { HttpError, cleanPath, isTextPath, mimeOf, requireString } from './util.js';
const upload = multer({ storage: multer.memoryStorage(), limits: { fileSize: 50 * 1024 * 1024, files: 30 } });
const utf8 = new TextDecoder('utf-8');
const decodeText = (bytes) => utf8.decode(bytes).replace(/^/, '');
// multer dosya adlarını latin1 olarak çözer; Türkçe karakterler için UTF-8'e çevrilir.
const originalName = (f) => Buffer.from(f.originalname, 'latin1').toString('utf8');
export function createProject(ownerId, title, files, mainFile) {
const id = randomUUID();
tx(() => {
db.prepare('INSERT INTO projects (id, owner_id, title, main_file) VALUES (?, ?, ?, ?)').run(id, ownerId, title, mainFile);
for (const [path, content] of Object.entries(files)) putFile(id, path, content, typeof content !== 'string');
});
return id;
}
export function pickMainFile(files) {
const texFiles = Object.keys(files).filter((p) => p.endsWith('.tex'));
const withClass = texFiles.filter((p) => typeof files[p] === 'string' && /\\documentclass/.test(files[p]));
const candidates = withClass.length ? withClass : texFiles;
return (
candidates.find((p) => p === 'main.tex') ??
candidates.sort((a, b) => a.split('/').length - b.split('/').length || a.localeCompare(b))[0] ??
'main.tex'
);
}
export const projectsRouter = Router();
projectsRouter.get('/templates', (_req, res) => res.json({ templates: templateList() }));
projectsRouter.get('/projects', (req, res) => {
const projects = db.prepare(`
SELECT p.id, p.title, p.updated_at AS updatedAt, u.name AS ownerName,
CASE WHEN p.owner_id = :uid THEN 'owner' ELSE m.role END AS role
FROM projects p
JOIN users u ON u.id = p.owner_id
LEFT JOIN project_members m ON m.project_id = p.id AND m.user_id = :uid
WHERE p.owner_id = :uid OR m.user_id = :uid
ORDER BY p.updated_at DESC
`).all({ uid: req.user.id });
res.json({ projects });
});
projectsRouter.post('/projects', (req, res) => {
const title = requireString(req.body.title, 'Proje adı', { max: 120 });
const template = getTemplate(req.body.templateId || 'bos');
if (!template) throw new HttpError(400, 'Şablon bulunamadı.');
res.json({ id: createProject(req.user.id, title, template.files, template.mainFile) });
});
/** Bir .zip arşivini proje dosyalarına çevirir (metinler string, diğerleri Buffer). */
export function filesFromZip(buffer) {
let entries;
try {
entries = unzipSync(new Uint8Array(buffer));
} catch {
throw new HttpError(400, 'Dosya geçerli bir .zip arşivi değil.');
}
const names = Object.keys(entries).filter(
(n) => !n.endsWith('/') && !n.startsWith('__MACOSX/') && !n.split('/').pop().startsWith('.DS_Store'),
);
if (!names.length) throw new HttpError(400, 'Arşivde dosya bulunamadı.');
if (names.length > 1000) throw new HttpError(400, 'Arşivde çok fazla dosya var (en fazla 1000).');
// Tüm dosyalar tek bir üst klasördeyse o klasör atılır.
const top = names[0].split('/')[0];
const strip = names.every((n) => n.startsWith(`${top}/`)) ? top.length + 1 : 0;
const files = {};
for (const name of names) {
let path;
try {
path = cleanPath(name.slice(strip));
} catch {
continue; // geçersiz adlı girdiler atlanır
}
files[path] = isTextPath(path) ? decodeText(entries[name]) : Buffer.from(entries[name]);
}
return files;
}
projectsRouter.post('/projects/import', upload.single('file'), (req, res) => {
if (!req.file) throw new HttpError(400, 'Bir .zip dosyası seçin.');
const files = filesFromZip(req.file.buffer);
const fallbackTitle = originalName(req.file).replace(/\.zip$/i, '');
const title = requireString(req.body.title || fallbackTitle || 'İçe aktarılan proje', 'Proje adı', { max: 120 });
res.json({ id: createProject(req.user.id, title, files, pickMainFile(files)) });
});
projectsRouter.get('/projects/:id', withProject(), (req, res) => {
const p = req.project;
const owner = db.prepare('SELECT id, name, email FROM users WHERE id = ?').get(p.owner_id);
const members = db.prepare(`
SELECT u.id, u.name, u.email, m.role FROM project_members m JOIN users u ON u.id = m.user_id
WHERE m.project_id = ? ORDER BY u.name
`).all(p.id);
res.json({
project: { id: p.id, title: p.title, mainFile: p.main_file, role: req.role, owner },
files: listFiles(p.id),
members,
});
});
projectsRouter.patch('/projects/:id', withProject('editor'), (req, res) => {
const { title, mainFile } = req.body;
if (title !== undefined) {
db.prepare(`UPDATE projects SET title = ?, updated_at = datetime('now') WHERE id = ?`)
.run(requireString(title, 'Proje adı', { max: 120 }), req.project.id);
}
if (mainFile !== undefined) {
const path = cleanPath(mainFile);
if (!db.prepare('SELECT 1 FROM files WHERE project_id = ? AND path = ?').get(req.project.id, path)) {
throw new HttpError(400, 'Ana dosya projede bulunamadı.');
}
db.prepare('UPDATE projects SET main_file = ? WHERE id = ?').run(path, req.project.id);
}
res.json({ ok: true });
});
projectsRouter.delete('/projects/:id', withProject('owner'), (req, res) => {
db.prepare('DELETE FROM projects WHERE id = ?').run(req.project.id);
res.json({ ok: true });
});
projectsRouter.get('/projects/:id/export', withProject(), (req, res) => {
const rows = db.prepare('SELECT path, content FROM files WHERE project_id = ?').all(req.project.id);
const archive = {};
for (const r of rows) archive[r.path] = typeof r.content === 'string' ? Buffer.from(r.content, 'utf8') : r.content;
// Thoth'un derlemede eklediği destek dosyaları (APA 7 Türkçe yerelleştirmesi) arşive de konur;
// böylece proje başka bir LaTeX kurulumunda da aynı biçimde derlenir.
if (rows.some((r) => typeof r.content === 'string' && /\{biblatex\}/.test(r.content))) {
for (const s of SUPPORT_FILES) archive[s.name] ??= s.content;
}
res.attachment(`${req.project.title}.zip`).type('application/zip').send(Buffer.from(zipSync(archive)));
});
// ---- Dosyalar ----
projectsRouter.get('/projects/:id/file', withProject(), (req, res) => {
const path = cleanPath(req.query.path);
const row = db.prepare('SELECT content, is_binary, rev FROM files WHERE project_id = ? AND path = ?').get(req.project.id, path);
if (!row) throw new HttpError(404, 'Dosya bulunamadı.');
if (row.is_binary) throw new HttpError(400, 'Bu dosya metin olarak açılamaz.');
res.json({ path, content: row.content, rev: row.rev });
});
projectsRouter.get('/projects/:id/raw', withProject(), (req, res) => {
const path = cleanPath(req.query.path);
const row = db.prepare('SELECT content FROM files WHERE project_id = ? AND path = ?').get(req.project.id, path);
if (!row) throw new HttpError(404, 'Dosya bulunamadı.');
// SVG gibi etkin içerik barındırabilen dosyalar tarayıcıda çalıştırılmasın diye sandbox uygulanır.
res.set('Content-Security-Policy', 'sandbox').type(mimeOf(path)).send(Buffer.from(row.content));
});
projectsRouter.put('/projects/:id/file', withProject('editor'), (req, res) => {
const path = cleanPath(req.body.path);
const { content, baseRev } = req.body;
if (typeof content !== 'string') throw new HttpError(400, 'Dosya içeriği gerekli.');
if (!isTextPath(path)) throw new HttpError(400, 'Bu uzantıda metin dosyası oluşturulamaz.');
const rev = tx(() => {
const current = db.prepare('SELECT rev, content FROM files WHERE project_id = ? AND path = ?').get(req.project.id, path);
if (current && baseRev == null) throw new HttpError(409, 'Bu adda bir dosya zaten var.');
if (current && baseRev !== current.rev) {
throw new HttpError(409, 'Dosya bu sırada başka biri tarafından değiştirildi.', {
conflict: { rev: current.rev, content: current.content },
});
}
const newRev = putFile(req.project.id, path, content, false);
maybeAutoSnapshot(req.project.id, req.user.id);
return newRev;
});
res.json({ rev });
});
projectsRouter.post('/projects/:id/upload', withProject('editor'), upload.array('files'), (req, res) => {
if (!req.files?.length) throw new HttpError(400, 'Yüklenecek dosya seçin.');
const dir = req.body.dir ? `${cleanPath(req.body.dir)}/` : '';
tx(() => {
for (const f of req.files) {
const path = cleanPath(dir + originalName(f));
const text = isTextPath(path);
putFile(req.project.id, path, text ? decodeText(f.buffer) : f.buffer, !text);
}
});
res.json({ files: listFiles(req.project.id) });
});
/** Tek bir dosyayı ya da bir klasörün (yol önekinin) tamamını seçen WHERE koşulu. */
const underPath = `project_id = ? AND (path = ? OR substr(path, 1, length(?) + 1) = ? || '/')`;
projectsRouter.post('/projects/:id/rename', withProject('editor'), (req, res) => {
const from = cleanPath(req.body.from);
const to = cleanPath(req.body.to);
tx(() => {
const rows = db.prepare(`SELECT path FROM files WHERE ${underPath}`).all(req.project.id, from, from, from);
if (!rows.length) throw new HttpError(404, 'Dosya bulunamadı.');
for (const { path } of rows) {
const target = to + path.slice(from.length);
if (db.prepare('SELECT 1 FROM files WHERE project_id = ? AND path = ?').get(req.project.id, target)) {
throw new HttpError(409, `"${target}" adında bir dosya zaten var.`);
}
db.prepare('UPDATE files SET path = ?, rev = ? WHERE project_id = ? AND path = ?')
.run(target, nextRev(req.project.id), req.project.id, path);
if (req.project.main_file === path) {
db.prepare('UPDATE projects SET main_file = ? WHERE id = ?').run(target, req.project.id);
}
}
});
res.json({ files: listFiles(req.project.id) });
});
projectsRouter.delete('/projects/:id/file', withProject('editor'), (req, res) => {
const path = cleanPath(req.query.path);
if (path === req.project.main_file) throw new HttpError(400, 'Ana dosya silinemez. Önce başka bir ana dosya seçin.');
const { changes } = db.prepare(`DELETE FROM files WHERE ${underPath}`).run(req.project.id, path, path, path);
if (!changes) throw new HttpError(404, 'Dosya bulunamadı.');
nextRev(req.project.id);
res.json({ files: listFiles(req.project.id) });
});
// ---- Paylaşım ----
projectsRouter.post('/projects/:id/members', withProject('owner'), (req, res) => {
const email = requireString(req.body.email, 'E-posta', { max: 120 });
const role = req.body.role === 'viewer' ? 'viewer' : 'editor';
const user = db.prepare('SELECT id FROM users WHERE email = ?').get(email);
if (!user) throw new HttpError(404, 'Bu e-posta adresiyle kayıtlı bir kullanıcı yok. Önce hesap açması gerekir.');
if (user.id === req.user.id) throw new HttpError(400, 'Projenin sahibi zaten sizsiniz.');
db.prepare(`
INSERT INTO project_members (project_id, user_id, role) VALUES (?, ?, ?)
ON CONFLICT (project_id, user_id) DO UPDATE SET role = excluded.role
`).run(req.project.id, user.id, role);
res.json({ ok: true });
});
projectsRouter.delete('/projects/:id/members/:userId', withProject('owner'), (req, res) => {
db.prepare('DELETE FROM project_members WHERE project_id = ? AND user_id = ?').run(req.project.id, Number(req.params.userId));
res.json({ ok: true });
});