Function uploadTranslationsFromFolder

scripts/dbRefresh.ts:245–314

* Discovers all non-English locale directories under jsonDbDir, loads their * translation JSON files, validates them against the English source, and * upserts into `{collectionPrefix}translations`.

(
  db: Db,
  jsonDbDir: string,
  collectionPrefix: string
)

 * upserts into `{collectionPrefix}translations`.
 */
async function uploadTranslationsFromFolder(
  db: Db,
  jsonDbDir: string,
  collectionPrefix: string
): Promise<void> {
  const translationCollectionName = `${collectionPrefix}translations`;
  const translationCollection = db.collection(translationCollectionName);

  try {
    await translationCollection.drop();
    console.log(`  Dropped existing collection '${translationCollectionName}'.`);
  } catch (err) {
    if (!(err instanceof MongoServerError && err.codeName === 'NamespaceNotFound')) {
      throw err;
    }
  }

  const enDir = `${jsonDbDir}/en`;
  if (!existsSync(enDir)) {
    console.warn(
      `  No English source directory at ${enDir}. Skipping translations for ${jsonDbDir}.`
    );
    return;
  }

  let langDirs: string[];
  try {
    langDirs = readdirSync(jsonDbDir, { withFileTypes: true })
      .filter(
        (e) =>
          e.isDirectory() &&
          LOCALE_PATTERN.test(e.name) &&
          e.name !== 'en' &&
          !TRANSLATION_SKIP_DIRS.has(e.name)
      )
      .map((e) => e.name);
  } catch (e) {
    console.error(`Error reading ${jsonDbDir}:`, e);
    return;
  }

  if (langDirs.length === 0) {
    console.log(`  No translation directories found in ${jsonDbDir}.`);
    await _refreshLocaleCollection(db, collectionPrefix, []);
    return;
  }

  console.log(`  Found translation languages: ${langDirs.join(', ')}`);
  const translationDocs: TranslationDocument[] = [];

  for (const lang of langDirs) {
    const docs = _processLangDir(lang, `${jsonDbDir}/${lang}`, enDir);
    translationDocs.push(...docs);
  }

  if (translationDocs.length > 0) {
    await translationCollection.createIndex(
      { source_collection: 1, source_index: 1, lang: 1 },