38             PreparedStatement statement = 
jdbcConnection.prepareStatement(
"select ID, REALM_ID, PRIORITY, DISPLAY_NAME, FULL_SYNC_PERIOD, CHANGED_SYNC_PERIOD, LAST_SYNC from " + 
getTableName(
"USER_FEDERATION_PROVIDER") + 
" WHERE PROVIDER_NAME=?");
    39             statement.setString(1, providerId);
    42                 ResultSet resultSet = statement.executeQuery();
    44                     while (resultSet.next()) {
    46                         String 
id = resultSet.getString(index++);
    47                         String realmId = resultSet.getString(index++);
    48                         int priority = resultSet.getInt(index++);
    49                         String displayName = resultSet.getString(index++);
    50                         int fullSyncPeriod = resultSet.getInt(index++);
    51                         int changedSyncPeriod = resultSet.getInt(index++);
    52                         int lastSync = resultSet.getInt(index++);
    55                         InsertStatement insertComponent = 
new InsertStatement(null, null, 
database.correctObjectName(
"COMPONENT", Table.class))
    56                                 .addColumnValue(
"ID", 
id)
    57                                 .addColumnValue(
"REALM_ID", realmId)
    58                                 .addColumnValue(
"PARENT_ID", realmId)
    59                                 .addColumnValue(
"NAME", displayName)
    60                                 .addColumnValue(
"PROVIDER_ID", providerId)
    61                                 .addColumnValue(
"PROVIDER_TYPE", UserStorageProvider.class.getName());
    69                         PreparedStatement configStatement = 
jdbcConnection.prepareStatement(
"select name, VALUE from " + 
getTableName(
"USER_FEDERATION_CONFIG") + 
" WHERE USER_FEDERATION_PROVIDER_ID=?");
    70                         configStatement.setString(1, 
id);
    72                             ResultSet configSet = configStatement.executeQuery();
    74                                 while (configSet.next()) {
    75                                     String name = configSet.getString(1);
    76                                     String value = configSet.getString(2);
    84                             configStatement.close();
    87                         if (newMapperType != null) {
    91                         DeleteStatement configDelete = 
new DeleteStatement(null, null, 
database.correctObjectName(
"USER_FEDERATION_CONFIG", Table.class));
    92                         configDelete.setWhere(
"USER_FEDERATION_PROVIDER_ID=?");
    93                         configDelete.addWhereParameters(
id);
    96                         DeleteStatement deleteStatement = 
new DeleteStatement(null, null, 
database.correctObjectName(
"USER_FEDERATION_PROVIDER", Table.class));
    97                         deleteStatement.setWhere(
"ID=?");
    98                         deleteStatement.addWhereParameters(
id);
   109             confirmationMessage.append(
"Updated " + 
statements.size() + 
" records in USER_FEDERATION_PROVIDER table for " + providerId + 
" conversion to component model");
   110         } 
catch (Exception e) {
   111             throw new CustomChangeException(
getTaskId() + 
": Exception when updating data from previous version", e);
 InsertStatement componentConfigStatement(String componentId, String name, String value)
Definition: AbstractUserFedToComponent.java:115
 
JdbcConnection jdbcConnection
Definition: CustomKeycloakTask.java:52
 
void convertFedMapperToComponent(String realmId, String parentId, String newMapperType)
Definition: AbstractUserFedToComponent.java:123
 
abstract String getTaskId()
 
String getTableName(String tableName)
Definition: CustomKeycloakTask.java:132
 
List< SqlStatement > statements
Definition: CustomKeycloakTask.java:55
 
Database database
Definition: CustomKeycloakTask.java:51
 
StringBuilder confirmationMessage
Definition: CustomKeycloakTask.java:54