Function parseTableDefinition

src/drivers/sqlite/sql-parse-table.ts:418–486

(
  schemaName: string,
  cursor: CursorV2
)

}

function parseTableDefinition(
  schemaName: string,
  cursor: CursorV2
): {
  columns: DatabaseTableColumn[];
  constraints: DatabaseTableColumnConstraint[];
} {
  let moveNext = true;
  const columns: DatabaseTableColumn[] = [];
  const constraints: DatabaseTableColumnConstraint[] = [];

  while (moveNext) {
    moveNext = false;

    if (
      cursor.matchTokens([
        "CONSTRAINT",
        "PRIMARY",
        "UNIQUE",
        "CHECK",
        "FOREIGN",
      ])
    ) {
      const constraint = parseColumnConstraint(schemaName, cursor);
      if (constraint) {
        constraints.push(constraint);
        moveNext = true;
      }
    } else {
      const column = parseColumnDef(schemaName, cursor);
      if (column) {
        columns.push(column);
        moveNext = true;
      }
    }

    while (cursor.read() !== "," && !cursor.end()) {
      cursor.next();
    }

    if (cursor.end()) break;
    cursor.next();
  }

  // console.log(columns, constraints);

  for (const constraint of constraints) {
    if (constraint.primaryKey && constraint.primaryColumns) {
      for (const pkColumn of constraint.primaryColumns) {
        const column = columns.find(
          (col) => pkColumn.toLowerCase() === col.name.toLowerCase()
        );

        if (column) {
          column.pk = true;
        }
      }
    }