toCreateIndexSql method

List<String> toCreateIndexSql(
  1. DatabaseType dbType
)

Generate CREATE INDEX SQL statements with IF NOT EXISTS

Implementation

List<String> toCreateIndexSql(DatabaseType dbType) {
  if (indexes == null || indexes!.isEmpty) return [];

  return indexes!.map((idx) {
    final uniqueKeyword = idx.unique ? 'UNIQUE ' : '';
    final ifNotExists = dbType == DatabaseType.sqlite ? '' : 'IF NOT EXISTS ';
    return 'CREATE ${uniqueKeyword}INDEX $ifNotExists${idx.name} ON $tableName (${idx.columns.join(', ')});';
  }).toList();
}