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