@Override protected void generateStatementsImpl() throws CustomChangeException { String userAttributeTableName = database.correctObjectName("USER_ATTRIBUTE", Table.class); try { PreparedStatement statement = jdbcConnection.prepareStatement("select NAME, USER_ID from " + getTableName("USER_ATTRIBUTE")); try { ResultSet resultSet = statement.executeQuery(); try { while (resultSet.next()) { String name = resultSet.getString(1); String userId = resultSet.getString(2); UpdateStatement updateStatement = new UpdateStatement(null, null, userAttributeTableName) .addNewColumnValue("ID", KeycloakModelUtils.generateId()) .setWhereClause("NAME='" + name + "' AND USER_ID='" + userId + "'"); statements.add(updateStatement); } } finally { resultSet.close(); } } finally { statement.close(); } confirmationMessage.append("Updated " + statements.size() + " attributes in USER_ATTRIBUTE table"); } catch (Exception e) { throw new CustomChangeException(getTaskId() + ": Exception when updating data from previous version", e); } }
@Override protected void generateStatementsImpl() throws CustomChangeException { String userAttributeTableName = database.correctObjectName("USER_ATTRIBUTE", Table.class); try { PreparedStatement statement = jdbcConnection.prepareStatement("select NAME, USER_ID from " + getTableName("USER_ATTRIBUTE")); try { ResultSet resultSet = statement.executeQuery(); try { while (resultSet.next()) { String name = resultSet.getString(1); String userId = resultSet.getString(2); UpdateStatement updateStatement = new UpdateStatement(null, null, userAttributeTableName) .addNewColumnValue("ID", KeycloakModelUtils.generateId()) .setWhereClause("NAME='" + name + "' AND USER_ID='" + userId + "'"); statements.add(updateStatement); } } finally { resultSet.close(); } } finally { statement.close(); } confirmationMessage.append("Updated " + statements.size() + " attributes in USER_ATTRIBUTE table"); } catch (Exception e) { throw new CustomChangeException(getTaskId() + ": Exception when updating data from previous version", e); } }