alter method

Future<void> alter(
  1. String name,
  2. void callback(
    1. Blueprint table
    )
)

Modifies an existing table by adding new columns.

Implementation

Future<void> alter(String name, void Function(Blueprint table) callback) async {
  final blueprint = Blueprint(name);
  callback(blueprint);
  for (final col in blueprint._columns) {
    await _db.query('ALTER TABLE "${_sanitize(name)}" ADD COLUMN ${col._toSql()}');
  }
}