Function parseColumnConstraint

src/drivers/sqlite/sql-parse-table.ts:211–416

(
  schemaName: string,
  cursor: CursorV2
)

}

export function parseColumnConstraint(
  schemaName: string,
  cursor: CursorV2
): DatabaseTableColumnConstraint | undefined {
  if (cursor.match("CONSTRAINT")) {
    cursor.next();
    const constraintName = cursor.consume();

    return {
      ...parseColumnConstraint(schemaName, cursor),
      name: constraintName,
    };
  } else if (cursor.match("PRIMARY")) {
    let primaryKeyOrder: SqlOrder | undefined;
    let primaryColumns: string[] | undefined;
    let autoIncrement = false;

    cursor.next();
    if (!cursor.match("KEY")) throw new Error("PRIMARY must follow by KEY");

    cursor.next();

    if (cursor.match("(")) {
      primaryColumns = parseColumnList(cursor.consumeParen());
    }

    if (cursor.match("ASC")) {
      primaryKeyOrder = "ASC";
      cursor.next();
    } else if (cursor.match("DESC")) {
      primaryKeyOrder = "DESC";
      cursor.next();
    }

    const conflict = parseConstraintConflict(cursor);

    if (cursor.match("AUTOINCREMENT")) {
      autoIncrement = true;
      cursor.next();
    }

    return {
      primaryKey: true,
      primaryKeyOrder,
      primaryColumns,
      autoIncrement,
      primaryKeyConflict: conflict,
      ...parseColumnConstraint(schemaName, cursor),
    };
  } else if (cursor.match("NOT")) {
    cursor.next();
    if (!cursor.match("NULL")) throw new Error("NOT should follow by NULL");
    cursor.next();

    const conflict = parseConstraintConflict(cursor);
    return {
      notNull: true,
      notNullConflict: conflict,