Function emitSchemaFile

packages/wl-sdk/scripts/generate-from-schema.ts:154–188

(schemaSql: string)

}

function emitSchemaFile(schemaSql: string): string {
  const parsed = parseSchema(schemaSql);

  const versionStmt = parsed.statements.find(s =>
    /INSERT\s+IGNORE\s+INTO\s+_meta.+schema_version/i.test(s)
  );
  const versionMatch = versionStmt
    ? /VALUES\s*\(\s*'schema_version'\s*,\s*'([^']+)'/i.exec(versionStmt)
    : null;
  const schemaVersion = versionMatch ? versionMatch[1] : 'unknown';

  const sections: string[] = [];
  sections.push(HEADER_LINES.join('\n'));
  sections.push(`import { z } from 'zod';`);
  sections.push(`export const COMMONS_SCHEMA_VERSION = ${JSON.stringify(schemaVersion)} as const;`);

  for (const table of parsed.tables) {
    sections.push(renderRowSchema(table));
    sections.push(renderTableMeta(table));
  }

  sections.push(
    [
      '/**',
      ' * The wasteland commons DDL split into individual statements, ready to',
      " * feed to DoltHub's write API one at a time. Order is preserved from",
      ' * the source file. Statements have no trailing `;` so callers can append',
      ' * one (or not) as the API expects.',
      ' */',
      renderSchemaStatements(parsed.statements.map(renderCreateTableStatement)),
    ].join('\n')
  );

  return sections.join('\n\n') + '\n';
}

// ---------------------------------------------------------------------------
// DML helpers