AbstractProtectedalterAdds a new column to a database table corresponding to the provided class name.
The name of the class whose table will be altered. The table name is derived by converting the class name from camelCase to snake_case.
The name of the new column to add.
The SQL data type of the new column (e.g., "INTEGER", "VARCHAR(255)").
Whether the new column should be defined as NOT NULL.
OptionaldefaultValue: string
Optional default value for the new column. If supplied, the default is applied unless deleteDefault is true.
OptionaldeleteDefault: boolean
When true and a default value is supplied, the default is dropped after the column is added.
A promise that resolves to true if all SQL statements executed successfully, otherwise false.
ProtectedalterDeletes a column from the database table that corresponds to the given class name.
The name of the class representing the table. The method converts this name from camelCase to snake_case to derive the actual table name.
The name of the column to be removed from the table.
A promise that resolves to true when the column has been successfully dropped from all executed queries; otherwise it resolves to false.
ProtectedinitInitialize a new table in the database. This method is used to create a new table in the database.
Abstractperform
Abstract helper class for performing database schema updates on PostgreSQL.
Extends CoreDBUpdate specialized for the PGCon connection type.