createIfNotExists method

@override void createIfNotExists(String tableName, void callback(Blueprint table))

Creates the table if it does not exist already.

Implementation

@override
void createIfNotExists(
  String tableName,
  void Function(Blueprint table) callback,
) {
  final blueprint = Blueprint(tableName);
  callback(blueprint);

  final columnSQLs = blueprint.columns.map(_columnToSQL).toList();
  final constraints = _generateConstraints(blueprint, tableName);
  final fullSQL = [
    ...columnSQLs,
    ...constraints,
  ].join(', ');

  _queries.add('CREATE TABLE IF NOT EXISTS `$tableName` ($fullSQL);');
}