Function parseCreateTableScript

src/drivers/sqlite/sql-parse-table.ts:555–601

(
  schemaName: string,
  sql: string
)

// Our parser follows this spec
// https://www.sqlite.org/lang_createtable.html
export function parseCreateTableScript(
  schemaName: string,
  sql: string
): DatabaseTableSchema {
  const cursor = new CursorV2(tokenizeSql(sql, "sqlite"));

  cursor.expectToken("CREATE");
  cursor.expectTokenOptional("TEMP");
  cursor.expectTokenOptional("TEMPORARY");
  cursor.expectTokenOptional("VIRTUAL");
  cursor.expectToken("TABLE");
  cursor.expectTokensOptional(["IF", "NOT", "EXIST"]);

  const tableName = cursor.consumeIdentifier();

  // Check for FTS5
  let fts5: DatabaseTableFts5 | undefined;

  if (cursor.match("USING")) {
    cursor.next();
    if (cursor.match("FTS5")) {
      cursor.next();
      fts5 = parseFTS5(cursor.consumeParen());
    }
  }

  const defs = cursor.match("(")
    ? parseTableDefinition(schemaName, cursor.consumeParen())
    : { columns: [], constraints: [] };

  // Parsing table options
  const pk = defs.columns.filter((col) => col.pk).map((col) => col.name);

  const autoIncrement = defs.columns.some(
    (col) => !!col.constraint?.autoIncrement
  );

  return {
    tableName,
    schemaName,
    ...defs,
    pk,
    autoIncrement,
    fts5,
    ...parseTableOption(cursor),
  };
}