Function writeDatabaseSchema

apps/desktop/src/main/databases.ts:235–246

(
  root: string,
  rel: string,
  sidecar: DatabaseSidecar,
  rows: DbRow[]
)

 * re-reading the on-disk CSV, whose header may no longer match a renamed field.
 */
export async function writeDatabaseSchema(
  root: string,
  rel: string,
  sidecar: DatabaseSidecar,
  rows: DbRow[]
): Promise<DatabaseDoc> {
  const normalized = normalizeSidecar(sidecar)
  if (!normalized) throw new Error(`Invalid database schema: ${rel}`)
  await persistSidecar(root, rel, normalized)
  await writeFileAtomic(databaseDataPath(root, rel), serializeRows(rows, normalized.fields))
  return hydrate(rel, normalized, rows.map((r) => ({ ...r })))
}

/**
 * Create a new empty database (`id` + `Name` fields) under `folder`/`subpath`