private string GenerateSqlStatementConcrete(DropIndexOperation migrationOperation) { SQLiteDdlBuilder ddlBuilder = new SQLiteDdlBuilder(); ddlBuilder.AppendSql("DROP INDEX "); ddlBuilder.AppendIdentifier(SQLiteProviderManifestHelper.GetFullIdentifierName(migrationOperation.Table, migrationOperation.Name)); ddlBuilder.AppendSql(" ON "); ddlBuilder.AppendIdentifier(migrationOperation.Table); return(ddlBuilder.GetCommandText()); }
private string GenerateSqlStatementConcrete(CreateIndexOperation migrationOperation) { SQLiteDdlBuilder ddlBuilder = new SQLiteDdlBuilder(); ddlBuilder.AppendSql("CREATE "); if (migrationOperation.IsUnique) { ddlBuilder.AppendSql("UNIQUE "); } ddlBuilder.AppendSql("INDEX "); ddlBuilder.AppendIdentifier(SQLiteProviderManifestHelper.GetFullIdentifierName(migrationOperation.Table, migrationOperation.Name)); ddlBuilder.AppendSql(" ON "); ddlBuilder.AppendIdentifier(migrationOperation.Table); ddlBuilder.AppendSql(" ("); ddlBuilder.AppendIdentifierList(migrationOperation.Columns); ddlBuilder.AppendSql(")"); return(ddlBuilder.GetCommandText()); }