All files / services/job-manager-service/src persistence.js

95.88% Statements 163/170
43.85% Branches 25/57
100% Functions 6/6
95.88% Lines 163/170

Press n or j to go to the next uncovered block, b, p or k for the previous block.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 1711x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 25x 25x 24x 24x 25x 25x 25x 1x 1x 1x 25x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 13x 13x 13x 13x 129x 114x 114x 13x 13x 1x 12x 12x 12x 12x 12x 12x 12x 12x 1x 1x 1x 1x 1x 1x 12x 12x 1x 12x 12x 12x 12x   12x 1x 1x 1x 1x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x 13x       13x 1x 1x 1x 1x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 12x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 12x 12x 12x 12x 12x 12x 12x 12x 12x       12x 1x 1x  
/**
 * Persistance MongoDB de l'état des jobs — UNE SEULE collection : `jobs`.
 *
 * RÈGLE : seul le job-manager-service écrit dans `jobs`, à partir des informations
 * calculées par le workflow (result) ou remontées via la query `getStatus`.
 * Les jobs crawler y stockent aussi leurs champs spécifiques dans `crawler`
 * (`stats`, `progress`, `routedTo`, `stopReason`).
 */
const { MongoClient } = require("mongodb");
 
let mongoClient = null;
let db = null;
 
async function getDb() {
  if (mongoClient && mongoClient.topology && mongoClient.topology.isConnected()) {
    return db;
  }
  const uri = process.env.MONGODB_URI || "mongodb://mongodb:27017/nooloom";
  mongoClient = new MongoClient(uri, { maxPoolSize: 5 });
  await mongoClient.connect();
  db = mongoClient.db("nooloom");
  console.log("[Persistence] Connected to MongoDB");
  return db;
}
 
// Champs sensibles à ne jamais persister dans `inputs`
const SENSITIVE_FIELDS = [
  "llmApiKey",
  "authToken",
  "markerApiKey",
  "brightdataWs",
  "browserlessWs",
  "apiKey",
  "token",
];
 
function sanitizeInput(input) {
  if (!input || typeof input !== "object") return input || {};
  const out = {};
  for (const [k, v] of Object.entries(input)) {
    if (SENSITIVE_FIELDS.includes(k)) continue;
    out[k] = v;
  }
  return out;
}
 
function deriveMetadata(result) {
  if (!result || typeof result !== "object") return {};
  const meta = {};
  if (result.mode) meta.mode = result.mode;
  if (result.sourceType) meta.sourceType = result.sourceType;
  if (result.title) meta.title = result.title;
  if (result.url) meta.url = result.url;
  if (result.stats && typeof result.stats === "object") {
    meta.type = "crawler";
    meta.stopReason = result.stopReason || null;
    meta.pagesCrawled = result.stats.pagesCrawled || 0;
    meta.pagesRelevant = result.stats.pagesRelevant || 0;
    meta.pagesFailed = result.stats.pagesFailed || 0;
  }
  return meta;
}
 
function deriveOutputs(result) {
  if (!result || typeof result !== "object") return [];
  if (Array.isArray(result.outputs)) return result.outputs;
  if (result.output && typeof result.output === "object") return [result.output];
  return [];
}
 
/**
 * Crée (ou met à jour) le doc `jobs` au démarrage du workflow : statut `running`.
 */
async function storeRunning({ jobId, organizationId, type, workflowType, input }) {
  if (!jobId) return { success: false, error: "jobId required" };
  try {
    const database = await getDb();
    const now = new Date();
    const set = {
      jobId,
      organizationId: organizationId || null,
      // `type` (crawler|workflow) + `workflowType` (Workflow Temporal appelé)
      type: type || null,
      workflowType: workflowType || null,
      status: "running",
      crawlerConfigId: (input && input.crawlerConfigId) || null,
      inputs: sanitizeInput(input),
      updatedAt: now,
    };
    if (input && input.scheduleId) set.scheduleId = input.scheduleId;
 
    await database.collection("jobs").updateOne(
      { jobId },
      {
        $set: set,
        $setOnInsert: { createdAt: now, outputs: [], phases: [] },
      },
      { upsert: true },
    );
    console.log(`[Persistence] running ${jobId}${type ? ` (${type})` : ""}`);
    return { success: true };
  } catch (e) {
    console.error(`[Persistence] storeRunning error for ${jobId}: ${e.message}`);
    return { success: false, error: e.message };
  }
}
 
/**
 * Met à jour le doc `jobs` à la clôture, à partir du résultat du workflow.
 */
async function storeFinal(jobId, { status, result, error } = {}) {
  if (!jobId) return { success: false, error: "jobId required" };
  try {
    const database = await getDb();
    const now = new Date();
    const collection = database.collection("jobs");
 
    const existing = await collection.findOne(
      { jobId },
      { projection: { type: 1, organizationId: 1 } },
    );
    const isCrawler = existing?.type === "crawler";
    const resultError = result && result.error ? result.error : null;
    const finalStatus =
      status === "failed" || error || resultError ? "failed" : "completed";
 
    const set = {
      status: finalStatus,
      outputs: deriveOutputs(result),
      metadata: deriveMetadata(result),
      error: error || resultError || null,
      closeTime: now.toISOString(),
      updatedAt: now,
    };
    if (result && result.phases) set.phases = result.phases;
    if (existing && existing.organizationId) set.organizationId = existing.organizationId;
 
    if (isCrawler) {
      const stats = (result && result.stats) || {};
      const progress = (result && result.progress) || {};
      set.metadata = {
        ...(set.metadata || {}),
        type: "crawler",
        stopReason: (result && result.stopReason) || progress.stopReason || null,
        pagesCrawled: stats.pagesCrawled || progress.pagesCrawled || 0,
        pagesRelevant: stats.pagesRelevant || progress.pagesRelevant || 0,
        pagesFailed: stats.pagesFailed || progress.pagesFailed || 0,
      };
      set.crawler = {
        stats,
        progress,
        routedTo: stats.dispatchedTo || [],
        stopReason: (result && result.stopReason) || progress.stopReason || null,
      };
    }
 
    await collection.updateOne(
      { jobId },
      { $set: set, $setOnInsert: { jobId, createdAt: now } },
      { upsert: true },
    );
    console.log(`[Persistence] final ${jobId}: ${finalStatus}`);
    return { success: true };
  } catch (e) {
    console.error(`[Persistence] storeFinal error for ${jobId}: ${e.message}`);
    return { success: false, error: e.message };
  }
}
 
module.exports = { storeRunning, storeFinal, sanitizeInput };