Function parseCreateTable

packages/wl-sdk/scripts/sql-parser.ts:207–245

(stmt: string)

  /^create\s+table\s+(?:if\s+not\s+exists\s+)?([A-Za-z_][A-Za-z0-9_]*)\s*\(([\s\S]*)\)\s*$/i;

export function parseCreateTable(stmt: string): ParsedTable | null {
  const m = CREATE_TABLE_RE.exec(stmt.trim());
  if (!m) return null;
  const name = m[1];
  const body = m[2];

  const lines = splitColumnList(body);
  const columns: ParsedColumn[] = [];
  const extras: string[] = [];

  for (const line of lines) {
    const col = parseColumnLine(line);
    if (col) {
      columns.push(col);
      continue;
    }
    const trimmed = line.trim().replace(/,$/, '').trim();
    if (trimmed.length > 0) extras.push(trimmed);
  }

  let primaryKey: string | null = columns.find(c => c.isPrimaryKey)?.name ?? null;
  if (!primaryKey) {
    for (const extra of extras) {
      const pkMatch = /^primary\s+key\s*\(\s*`?([A-Za-z_][A-Za-z0-9_]*)`?\s*\)/i.exec(extra);
      if (pkMatch) {
        primaryKey = pkMatch[1];
        break;
      }
    }
  }

  return {
    name,
    columns,
    primaryKey,
    extraConstraints: extras,
    rawDdl: stmt.trim(),
  };
}

/**
 * Split a column-list body on top-level commas (i.e. commas not inside