build_column_alter_statements — build_column_alter

Builds the ALTER TABLE ... MODIFY COLUMN statements needed to bring a target table's drifted columns to their desired column type, while preserving each column's existing nullability on the target (see get_column_type_drift for why nullability is never tightened to match the source). Pure string-building function with no database access, given the output of get_column_type_drift.

Usage

build_column_alter_statements(drift, target_table)

Arguments

drift,: a dataframe as returned by get_column_type_drift
target_table,: the name of the table the generated statements will alter

Value

a character vector of ALTER TABLE statements, one per drifted column

Examples

if (FALSE) { # \dontrun{
build_column_alter_statements(drift, "redcap_projects_history")
} # }