Download server/projects.js from SSSAssist/Thoth: direct link, hf CLI and curl.
- Browser
- Download file 11.7 kB
-
https://huggingface.co/spaces/SSSAssist/Thoth/resolve/main/server/projects.js
- Command line
-
hf download hf://spaces/SSSAssist/Thoth/server/projects.js
-
curl -L -o projects.js https://huggingface.co/spaces/SSSAssist/Thoth/resolve/main/server/projects.js
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 }); | |
| }); | |