Function splitStatements

packages/wl-sdk/scripts/sql-parser.ts:74–112

(sql: string)

 * tricks because `commons.sql` doesn't use them.
 */
export function splitStatements(sql: string): string[] {
  const cleaned = stripLineComments(sql);
  const out: string[] = [];
  let depth = 0;
  let inSingle = false;
  let inBacktick = false;
  let buf = '';

  for (let i = 0; i < cleaned.length; i++) {
    const ch = cleaned[i];
    buf += ch;
    if (inSingle) {
      if (ch === "'" && cleaned[i - 1] !== '\\') inSingle = false;
      continue;
    }
    if (inBacktick) {
      if (ch === '`') inBacktick = false;
      continue;
    }
    if (ch === "'") {
      inSingle = true;
      continue;
    }
    if (ch === '`') {
      inBacktick = true;
      continue;
    }
    if (ch === '(') depth++;
    else if (ch === ')') depth--;
    else if (ch === ';' && depth === 0) {
      const stmt = buf.slice(0, -1).trim();
      if (stmt.length > 0) out.push(stmt);
      buf = '';
    }
  }
  const tail = buf.trim();
  if (tail.length > 0) out.push(tail);
  return out;
}

const VARCHAR_RE = /^varchar\((\d+)\)$/i;
const TINYINT_RE = /^tinyint\((\d+)\)$/i;