Function parseColumnLine

packages/wl-sdk/scripts/sql-parser.ts:143–202

(line: string)

 * Returns null for non-column lines (constraints, empty lines).
 */
export function parseColumnLine(line: string): ParsedColumn | null {
  const trimmed = line.trim().replace(/,$/, '').trim();
  if (trimmed.length === 0) return null;

  const upper = trimmed.toUpperCase();
  if (
    upper.startsWith('PRIMARY KEY') ||
    upper.startsWith('UNIQUE KEY') ||
    upper.startsWith('UNIQUE (') ||
    upper.startsWith('KEY ') ||
    upper.startsWith('INDEX ') ||
    upper.startsWith('CHECK') ||
    upper.startsWith('FOREIGN KEY') ||
    upper.startsWith('CONSTRAINT')
  ) {
    return null;
  }

  // Identifier: backticked or plain.
  let rawName: string;
  let rest: string;
  if (trimmed.startsWith('`')) {
    const close = trimmed.indexOf('`', 1);
    if (close < 0) return null;
    rawName = trimmed.slice(0, close + 1);
    rest = trimmed.slice(close + 1).trim();
  } else {
    const space = trimmed.search(/\s/);
    if (space < 0) return null;
    rawName = trimmed.slice(0, space);
    rest = trimmed.slice(space).trim();
  }

  const name = rawName.replace(/^`|`$/g, '');

  // Type token: `VARCHAR(255)`, `TINYINT(1)`, `INT`, etc. May contain a
  // parenthesised arg list with no spaces in commons.sql.
  const typeMatch = /^([A-Za-z]+(?:\([^)]*\))?)/.exec(rest);
  if (!typeMatch) return null;
  const rawType = typeMatch[1];
  const tail = rest.slice(rawType.length).trim();

  const tailUpper = tail.toUpperCase();
  const notNull = /\bNOT\s+NULL\b/.test(tailUpper);
  const isPrimaryKey = /\bPRIMARY\s+KEY\b/.test(tailUpper);
  const defaultMatch = /\bDEFAULT\s+(.+?)(?:\s+(?:NOT\s+NULL|PRIMARY\s+KEY|UNIQUE)\b|$)/i.exec(
    tail
  );
  const defaultValue = defaultMatch ? defaultMatch[1].trim() : null;

  return {
    name,
    rawName,
    type: parseColumnType(rawType),
    rawType,
    notNull: notNull || isPrimaryKey,
    isPrimaryKey,
    default: defaultValue,