Function getOrCreateConfigVersion

server/src/addie/config-version.ts:83–143

()

 * Hashes rule file content + router rules + code version.
 */
export async function getOrCreateConfigVersion(): Promise<ConfigVersion> {
  const routerHash = computeRouterRulesHash();
  const rulesHash = computeRulesContentHash();
  const configHash = computeConfigHash(rulesHash, routerHash);

  // Check cache first
  const now = Date.now();
  if (cachedVersion && cachedVersion.config_hash === configHash && now < cacheExpiry) {
    return cachedVersion;
  }

  try {
    // Try to find existing version with this hash
    const existing = await query<ConfigVersion>(
      `SELECT * FROM addie_config_versions WHERE config_hash = $1`,
      [configHash]
    );

    if (existing.rows.length > 0) {
      cachedVersion = existing.rows[0];
      cacheExpiry = now + CACHE_TTL_MS;
      return cachedVersion;
    }

    // Create new version
    const result = await query<ConfigVersion>(
      `INSERT INTO addie_config_versions (
        config_hash, active_rule_ids, rules_snapshot, router_rules_hash, code_version
      ) VALUES ($1, $2, $3, $4, $5)
      RETURNING *`,
      [
        configHash,
        [], // Rule IDs no longer used — rules are in files
        JSON.stringify({ rules_content_hash: rulesHash }),
        routerHash,
        CODE_VERSION,
      ]
    );

    cachedVersion = result.rows[0];
    cacheExpiry = now + CACHE_TTL_MS;

    logger.info({
      version_id: cachedVersion.version_id,
      config_hash: configHash,
      rules_hash: rulesHash,
      code_version: CODE_VERSION,
    }, 'Config: Created new configuration version');

    return cachedVersion;
  } catch (error) {
    // If DB is temporarily unreachable but we have a cached version, return stale
    // cache instead of crashing callers. Config rarely changes so stale is fine.
    if (cachedVersion) {
      logger.warn({ error }, 'Config: DB unreachable, returning stale cached version');
      return cachedVersion;
    }
    logger.error({ error }, 'Config: Failed to get/create config version');