Repository Public
1/**2 * =============================================================================3 * SP BOUCHER | ACADEMIC RESEARCH4 * ARTIFICIAL INTELLIGENCE • FINANCE • ENGINEERING5 * =============================================================================6 *7 * PROJECT METADATA8 * -----------------------------------------------------------------------------9 * Project : UQO Éval10 * File : src/app/api/metre/assignments/route.ts11 * Module : app12 * Repository : https://git.spboucher.ai/uqo-eval13 * Project Website : https://www.uqo-eval.app14 * Created : 2026-10-2815 * Last Modified : 2026-10-2816 *17 * =============================================================================18 * SOFTWARE MAINTAINER & AFFILIATION19 * =============================================================================20 *21 * Maintainer : Simon-Pierre Boucher22 * Position : Professor of Finance23 * Institution : Université du Québec en Outaouais (UQO)24 * Department : Département des sciences administratives25 * Website : https://spboucher.ai26 * Git : https://git.spboucher.ai27 *28 * Research Contact : research@spboucher.ai29 * Direct Contact : simon@spboucher.ai30 * Security/Admin : admin@spboucher.ai31 *32 * The affiliation is descriptive. It is not an institutional endorsement,33 * a license grant or a determination of ownership.34 *35 * =============================================================================36 * COPYRIGHT, AUTHORSHIP & DATA37 * =============================================================================38 *39 * Copyright (c) the author(s) of this work.40 * Ownership is not asserted by this notice; see the repository records.41 *42 * This header identifies the maintainer of the software. Scientific43 * authorship of any associated paper is stated in the paper itself and44 * is not changed by this notice. Datasets and third-party materials45 * remain the property of their respective owners and licensors.46 *47 * This file is governed by the applicable project license, copyright48 * notices, institutional agreements and relevant law.49 *50 * =============================================================================51 * LICENSE & MAINTENANCE52 * =============================================================================53 *54 * License : None specified (no license file in this repository)55 * Classification : Public56 *57 * =============================================================================58 * END OF SP BOUCHER SOURCE HEADER59 * =============================================================================60 */6162// UQO Éval — Métré : devoirs (enseignant : création avec corrigé protégé ; étudiant : liste sans corrigé).63import { NextRequest, NextResponse } from "next/server";64import { randomUUID } from "crypto";65import { HttpError, handle, readJson, requireProject, requireUser } from "@/lib/metre/auth";66import { audit } from "@/lib/metre/db";6768export const runtime = "nodejs";6970export async function GET(req: NextRequest) {71 return handle(() => {72 const ctx = requireUser(req);73 const course = (ctx.db.prepare("SELECT course FROM metre_users WHERE id=?").get(ctx.user.id) as { course: string | null } | undefined)?.course;74 const rows = ctx.db.prepare(`SELECT a.id, a.course, a.title, a.instructions, a.template_project_id templateProjectId, a.due_at dueAt, a.created_by createdBy, a.active, a.created_at createdAt,75 (SELECT COUNT(*) FROM metre_submissions s WHERE s.assignment_id=a.id) submissions,76 (SELECT s.id FROM metre_submissions s WHERE s.assignment_id=a.id AND s.user_id=? LIMIT 1) mySubmission77 FROM metre_assignments a WHERE a.active=1 ${ctx.user.role === "student" && course ? "AND a.course=?" : ""} ORDER BY a.created_at DESC`).all(...(ctx.user.role === "student" && course ? [ctx.user.id, course] : [ctx.user.id]));78 return NextResponse.json({ assignments: rows }); // answer_key_json n'est JAMAIS sélectionné ici79 });80}8182export async function POST(req: NextRequest) {83 return handle(async () => {84 const ctx = requireUser(req, { roles: ["instructor", "admin"] });85 const b = await readJson<{ course?: string; title?: string; instructions?: string; templateProjectId?: string; dueAt?: string; answerKey?: unknown }>(req);86 if (!b.title || !b.course) throw new HttpError(400, "Titre et cours requis.");87 if (b.templateProjectId) requireProject(ctx, b.templateProjectId, "read");88 const id = randomUUID();89 ctx.db.prepare("INSERT INTO metre_assignments(id,course,title,instructions,template_project_id,due_at,answer_key_json,created_by) VALUES(?,?,?,?,?,?,?,?)")90 .run(id, String(b.course).slice(0, 40), String(b.title).slice(0, 160), b.instructions ? String(b.instructions).slice(0, 8000) : null, b.templateProjectId ?? null, b.dueAt ? String(b.dueAt).slice(0, 25) : null, b.answerKey == null ? null : JSON.stringify(b.answerKey).slice(0, 20000), ctx.user.id);91 audit(ctx.db, { userId: ctx.user.id, role: ctx.user.role, action: "assignment.create", entityType: "assignment", entityId: id, ip: ctx.ip });92 return NextResponse.json({ id }, { status: 201 });93 });94}95