Function migrateOneLegacyDatabase

apps/desktop/src/main/vault.ts:1358–1428

(
  root: string,
  csvRel: string,
  sidecarRel: string
)

}

async function migrateOneLegacyDatabase(
  root: string,
  csvRel: string,
  sidecarRel: string
): Promise<boolean> {
  const name = path.basename(csvRel).replace(/\.csv$/i, '')
  const parentRel = csvRel.includes('/') ? csvRel.slice(0, csvRel.lastIndexOf('/')) : ''
  const formDirRel = parentRel ? `${parentRel}/${name}${FORM_DIR_SUFFIX}` : `${name}${FORM_DIR_SUFFIX}`
  const formDirAbs = resolveSafe(root, formDirRel)
  // Idempotent / collision safety: never clobber an existing folder.
  try {
    await fs.access(formDirAbs)
    return false
  } catch {
    /* target free — proceed */
  }

  let sidecar: Record<string, unknown> = {}
  try {
    sidecar = JSON.parse(await fs.readFile(resolveSafe(root, sidecarRel), 'utf8')) as Record<
      string,
      unknown
    >
  } catch {
    /* unreadable sidecar — still migrate the data, infer schema on next open */
  }

  await fs.mkdir(formDirAbs, { recursive: true })

  // Move record-page notes into the folder; rewrite pages → relative basenames.
  const pages =
    sidecar.pages && typeof sidecar.pages === 'object'
      ? (sidecar.pages as Record<string, unknown>)
      : {}
  const newPages: Record<string, string> = {}
  const oldPageDirs = new Set<string>()
  for (const [rowId, p] of Object.entries(pages)) {
    if (typeof p !== 'string') continue
    const srcAbs = resolveSafe(root, p)
    try {
      await fs.access(srcAbs)
    } catch {
      continue // page note already gone — drop the mapping
    }
    const finalTitle = await uniqueTitle(formDirAbs, sanitizeNoteTitle(path.basename(p, '.md')))
    await fs.rename(srcAbs, resolveSafe(root, `${formDirRel}/${finalTitle}.md`))
    newPages[rowId] = `${finalTitle}.md`
    if (p.includes('/')) oldPageDirs.add(p.slice(0, p.lastIndexOf('/')))
  }

  // Move the data file, write schema.json (relative pages), drop the old sidecar.
  await fs.rename(resolveSafe(root, csvRel), resolveSafe(root, `${formDirRel}/${FORM_DATA_FILE}`))
  const outSidecar: Record<string, unknown> = { ...sidecar }
  if (Object.keys(newPages).length > 0) outSidecar.pages = newPages
  else delete outSidecar.pages
  await writeFileAtomic(
    resolveSafe(root, `${formDirRel}/${FORM_SCHEMA_FILE}`),
    `${JSON.stringify(outSidecar, null, 2)}\n`