SPB Git

Repository Public

metre-seed-examples.mts 6.6 KB 51 lines typescript

1// UQO Éval — Métré : crée (ou recrée) les trois projets-gabarits d'exemple (QA humaine, docs/construction/VALIDATION_PLAN.md §4)2// au nom d'un compte enseignant « Exemples UQO Éval ». Idempotent : les gabarits existants du même nom sont remplacés.3// Usage (sur le nœud, dans ~/apps/uqo-eval) : npx tsx scripts/metre-seed-examples.mts4import fs from "fs";5import path from "path";67for (const line of fs.readFileSync(path.join(process.cwd(), ".env.local"), "utf8").split("\n")) { const m = line.match(/^([A-Z_0-9]+)=(.*)$/); if (m && !process.env[m[1]]) process.env[m[1]] = m[2]; }89const [{ getMetreDb, nowIso }, auth, projects, plans, estimates] = await Promise.all([import("../src/lib/metre/db"), import("../src/lib/metre/auth"), import("../src/lib/metre/projects"), import("../src/lib/metre/plans"), import("../src/lib/metre/estimates")]);1011const d = getMetreDb();12const user = auth.login(d, { code: process.env.METRE_INSTRUCTOR_CODE!, displayName: "Exemples UQO Éval", ip: null, userAgent: "seed" }).user;13const ctx = { db: d, user, ip: null };1415const A = (wbs: string, description: string, quantity: number, unit: string, unitPrice: number, note: string) => ({ wbs, description, basis: "assumption", unitPrice, installed: true, quantity, unit, assumptionNote: note });1617interface Ex { name: string; address: string; municipality: string; regionCode: string; buildingKind: string; stories: number; unitSystem: "metric" | "imperial"; notes: string; measures: { name: string; value: number; unit: string; note: string }[]; lines: Record<string, unknown>[]; params: Record<string, unknown>; valuation?: Record<string, unknown> }1819const EXAMPLES: Ex[] = [20  { name: "Exemple 1 — Bungalow 1 étage (Gatineau)", address: "Plan 12,2 m × 9,1 m", municipality: "Gatineau", regionCode: "QC-GAT", buildingKind: "detached", stories: 1, unitSystem: "metric",21    notes: "Gabarit QA : quantités vérifiées à la main (VALIDATION_PLAN §4). Prix = hypothèses pédagogiques explicites, pas des observations.",22    measures: [{ name: "Dalle sur sol 100 mm", value: 11.102, unit: "m3", note: "12,2 × 9,1 × 0,10" }, { name: "Plancher", value: 111.02, unit: "m2", note: "12,2 × 9,1" }, { name: "Toit pente 4/12", value: 117.03, unit: "m2", note: "111,02 × √(1 + (4/12)²)" }, { name: "Murs extérieurs bruts (h 2,44 m)", value: 103.94, unit: "m2", note: "périmètre 42,6 m × 2,44" }],23    lines: [A("03", "Dalle sur sol 100 mm (béton livré + finition)", 11.102, "m3", 285, "hypothèse pédagogique"), A("06", "Murs extérieurs 2×6 + revêtement (installé)", 103.94, "m2", 165, "hypothèse pédagogique"), A("07", "Toiture bardeau d'asphalte (installé)", 117.03, "m2", 48, "hypothèse pédagogique"), A("09", "Finitions intérieures ($/m² plancher)", 111.02, "m2", 310, "hypothèse pédagogique")],24    params: { generalConditionsPct: 8, overheadPct: 7, profitPct: 8, contingencyPct: 5 } },25  { name: "Exemple 2 — Cottage 2 étages + garage (Montréal, impérial)", address: "40 × 28 pi par étage, garage 22 × 22 pi", municipality: "Montréal", regionCode: "QC-MTL", buildingKind: "detached", stories: 2, unitSystem: "imperial",26    notes: "Gabarit QA en unités impériales : 2 240 pi² de plancher, dalle de garage 484 pi² × 5 po. Taxes activées pour illustrer TPS/TVQ non composées.",27    measures: [{ name: "Plancher 2 étages", value: 2240, unit: "ft2", note: "2 × 40 × 28" }, { name: "Dalle garage 5 po", value: 5.621, unit: "m3", note: "484 pi² × 0,125 m" }],28    lines: [A("09", "Planchers finis ($/pi²)", 2240, "ft2", 28, "hypothèse pédagogique"), A("03", "Dalle de garage (béton livré)", 5.621, "m3", 300, "hypothèse pédagogique"), A("08", "Fenêtres PVC (unité)", 14, "unit", 950, "hypothèse pédagogique")],29    params: { generalConditionsPct: 8, overheadPct: 7, profitPct: 8, contingencyPct: 5, applyGst: true, applyQst: true } },30  { name: "Exemple 3 — Triplex 1965 (Québec) : méthode du coût", address: "320 m² habitables", municipality: "Québec", regionCode: "QC-QUE", buildingKind: "plex", stories: 3, unitSystem: "metric",31    notes: "Gabarit QA : coût à neuf de classe (2 150 $/m², hypothèse), actualisation 3 % saisie, puis méthode du coût avec garde anti-double déduction.",32    measures: [{ name: "Aire habitable", value: 320, unit: "m2", note: "3 logements" }],33    lines: [A("00", "Coût à neuf du triplex ($/m², benchmark de classe)", 320, "m2", 2150, "hypothèse — benchmark de classe")],34    params: { generalConditionsPct: 6, overheadPct: 6, profitPct: 6, contingencyPct: 0, escalateTo: "2027-01-01", escalationFactor: 1.03, escalationSource: "hypothèse 3 % (exemple)" },35    valuation: { basis: "replacement", basisAdjustmentPct: -5, siteImprovements: 15000, physical: { method: "age_life", effectiveAge: 35, economicLife: 70 }, functional: [{ label: "Cuisines désuètes", curable: true, amount: 45000, eliminatedByReplacement: true }, { label: "Absence de stationnement", curable: false, amount: 20000, eliminatedByReplacement: false }], external: { amount: 10000, note: "bruit autoroutier" }, land: { value: 210000, source: "role", note: "valeur au rôle (exemple)" } } },36];3738for (const ex of EXAMPLES) {39  for (const old of d.prepare("SELECT id FROM metre_projects WHERE owner_id=? AND name=? AND deleted_at IS NULL").all(user.id, ex.name) as { id: string }[]) d.prepare("UPDATE metre_projects SET deleted_at=? WHERE id=?").run(nowIso(), old.id);40  const p = projects.createProject(ctx, { name: ex.name, address: ex.address, municipality: ex.municipality, regionCode: ex.regionCode, valuationDate: "2026-10-28", buildingKind: ex.buildingKind, stories: ex.stories, unitSystem: ex.unitSystem, notes: ex.notes, isTemplate: true });41  const ms = ex.measures.map((m) => plans.createManualMeasurement(ctx, p.id, { name: m.name, value: m.value, unit: m.unit, confidence: "estimated", note: m.note }));42  for (const m of ms) plans.verifyMeasurement(ctx, m.id, true);43  const e = estimates.createEstimate(ctx, p.id, "Estimation de référence", ex.regionCode, "2026-10-28");44  const lines = ex.lines.map((l, i) => ({ ...l, measurementId: ms.find((m) => Math.abs(m.value - Number(l.quantity)) < 1e-6 && m.unit === l.unit)?.id ?? null, sortOrder: i }));45  estimates.updateEstimate(ctx, e.id, { params: { ...ex.params, priceDate: "2026-10-28", regionCode: ex.regionCode }, lines });46  const v = estimates.freezeVersion(ctx, e.id, "Révision de référence", "exemple");47  if (ex.valuation) estimates.saveValuationCase(ctx, p.id, { ...ex.valuation, estimateVersionId: v.id, name: "Méthode du coût (exemple)" });48  console.log(`✓ ${ex.name} → projet ${p.id}, révision r${v.number} total ${v.result.totals.total} $`);49}50console.log("terminé");51
Files main
Menu

Theme