Reset User after sandbox refresh
Usage examples
// reset a user that contains name
resetUserAfterRefreshByName('Evgenii Azimzhanov');
resetUserAfterRefreshByName('Evgenii Azi');
resetUserAfterRefreshByName('Azi');
// reset a user by id
resetUserAfterRefreshById('0054M000003QHQNQA4');
Script
public class ResetUserException extends Exception {}
/**
* Resets the user after a refresh by their name.
*
* @param name The name of the user to reset.
* @throws ResetUserException if the name is empty.
* @throws ResetUserException if more than one user is found with the given name.
* @throws ResetUserException if user was not found
*/
public void resetUserAfterRefreshByName(String name) {
if (String.isBlank(name)) {
throw new ResetUserException('Empty name');
}
List<User> users = selectUsers(name, null);
// validate that we found only single user by name
User foundUser;
for (User u : users) {
if (u.Name.contains(name)) {
if (foundUser != null) {
throw new ResetUserException('Two users found');
} else {
foundUser = u;
}
}
}
resetUser(foundUser);
}
/**
* Resets the user after a refresh by their Id
*
* @param userId The Id of the user to reset.
* @throws ResetUserException if user was not found
*/
public void resetUserAfterRefreshById(Id userId) {
User foundUser = selectUsers(null, userId).get(0);
resetUser(foundUser);
}
private void resetUser(User userToReset) {
if (userToReset == null) {
throw new ResetUserException('Cannot find the user');
}
// resetting user after refresh
userToReset.isActive = true;
if (userToReset.Email?.endsWith('.invalid')) {
userToReset.Email = userToReset.Email.replace('.invalid', '');
}
userToReset.ProfileId = [SELECT Id FROM Profile WHERE Name = 'System Administrator' LIMIT 1].Id;
update userToReset;
System.debug('___________________Success___________________');
}
private List<User> selectUsers(String name, Id userId) {
String query = 'SELECT Id, Name, Email, Profile.Name, Profile.UserLicenseId, CompanyName, IsActive FROM User ';
if (!String.isBlank(name)) {
query += 'WHERE Name LIKE \'%' + name + '%\'';
} else if (userId != null) {
query += 'WHERE Id = :userId';
} else {
throw new ResetUserException('Either name or userId must be provided');
}
query += ' ORDER BY CompanyName NULLS LAST';
return Database.query(query);
}