Function generateCreateColumn

src/drivers/postgres/generate-schema.ts:15–119

(
  driver: BaseDriver,
  col: DatabaseTableColumn,
  edit?: boolean
)

}

function generateCreateColumn(
  driver: BaseDriver,
  col: DatabaseTableColumn,
  edit?: boolean
): string {
  const tokens: string[] = edit
    ? [
        driver.escapeId(col.name),
        "TYPE",
        col.type,
        "USING",
        `${driver.escapeId(col.name)}::${col.type}`,
      ]
    : [driver.escapeId(col.name), col.type];

  if (col.constraint?.primaryKey) {
    tokens.push(
      [
        "PRIMARY KEY",
        col.constraint.primaryKeyOrder,
        col.constraint.primaryKeyConflict
          ? `ON CONFLICT ${col.constraint.primaryKeyConflict}`
          : undefined,
        col.constraint.autoIncrement
          ? "GENERATED ALWAYS AS IDENTITY"
          : undefined,
      ]
        .filter(Boolean)
        .join(" ")
    );
  }

  if (col.constraint?.unique) {
    tokens.push(
      [
        "UNIQUE",
        col.constraint.uniqueConflict
          ? `ON CONFLICT ${col.constraint.uniqueConflict}`
          : undefined,
      ]
        .filter(Boolean)
        .join(" ")
    );
  }

  if (col.constraint?.notNull) {
    tokens.push(
      [
        "NOT NULL",
        col.constraint.notNullConflict
          ? `ON CONFLICT ${col.constraint.notNullConflict}`
          : undefined,
      ]
        .filter(Boolean)
        .join(" ")
    );
  }