dvAddColumnSql function

String dvAddColumnSql(
  1. DVAddColumn change, {
  2. bool ifNotExists = false,
})

The SQL that makes change. IF NOT EXISTS only where asked for: it is PostgreSQL's, and SQLite and MySQL refuse it.

Implementation

String dvAddColumnSql(DVAddColumn change, {bool ifNotExists = false}) =>
    'ALTER TABLE ${change.table} ADD COLUMN '
    '${ifNotExists ? 'IF NOT EXISTS ' : ''}${change.column} ${change.type}'
    '${change.nullable ? '' : ' NOT NULL'}'
    '${change.defaultSql == null ? '' : ' DEFAULT ${change.defaultSql}'}';