Meine Entity:
und das Repository:
und eine entsprechender Test:
Java:
@Entity
@Table(name="user")
public class User implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@JoinColumn(name = "created_by", referencedColumnName = "id")
@ManyToOne(fetch = FetchType.LAZY)
private User created_by;
@OneToMany(mappedBy = "created_by", fetch = FetchType.LAZY)
private List<User> userList;
@NotNull
@CreationTimestamp
private LocalDateTime created_at;
@OneToOne(cascade = CascadeType.REMOVE, fetch=FetchType.LAZY)
@JoinColumn(name="updated_by")
private User updated_by;
private LocalDateTime updated_at;
@OneToOne(cascade = CascadeType.REMOVE, fetch=FetchType.LAZY)
@JoinColumn(name="deleted_by")
private User deleted_by;
private LocalDateTime deleted_at;
@NotNull
@NotBlank
@Length(min=3, max=255)
private String firstname;
@NotNull
@NotBlank
@Length(min=3, max=255)
private String lastname;
@NotNull
@NotBlank
@Length(min=3, max=255)
@Column(unique=true)
private String email;
@NotNull
@NotBlank
@Length(min=3, max=255)
private String password;
public User() {
}
public User(@NotNull @NotBlank @Length(min = 3, max = 255) String firstname,
@NotNull @NotBlank @Length(min = 3, max = 255) String lastname,
@NotNull @NotBlank @Length(min = 3, max = 255) String email,
@NotNull @NotBlank @Length(min = 3, max = 255) String password) {
super();
this.firstname = firstname;
this.lastname = lastname;
this.email = email;
this.password = password;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public LocalDateTime getCreatedAt() {
return created_at;
}
public void setCreatedAt(LocalDateTime created_at) {
this.created_at = created_at;
}
public User getUpdatedBy() {
return updated_by;
}
public void setUpdatedBy(User updated_by) {
this.updated_by = updated_by;
}
public LocalDateTime getUpdatedAt() {
return updated_at;
}
public void setUpdatedAt(LocalDateTime updated_at) {
this.updated_at = updated_at;
}
public User getDeletedBy() {
return deleted_by;
}
public void setDeletedBy(User deleted_by) {
this.deleted_by = deleted_by;
}
public LocalDateTime getDeletedAt() {
return deleted_at;
}
public void setDeletedAt(LocalDateTime deleted_at) {
this.deleted_at = deleted_at;
}
public String getFirstname() {
return firstname;
}
public void setFirstname(String firstname) {
this.firstname = firstname;
}
public String getLastname() {
return lastname;
}
public User getCreatedBy() {
return created_by;
}
public void setCreatedBy(User created_by) {
this.created_by = created_by;
}
public List<User> getUserList() {
return userList;
}
public void setUserList(List<User> userList) {
this.userList = userList;
}
public void setLastname(String lastname) {
this.lastname = lastname;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + ((created_at == null) ? 0 : created_at.hashCode());
result = prime * result + ((created_by == null) ? 0 : created_by.hashCode());
result = prime * result + ((email == null) ? 0 : email.hashCode());
result = prime * result + ((firstname == null) ? 0 : firstname.hashCode());
result = prime * result + ((id == null) ? 0 : id.hashCode());
result = prime * result + ((lastname == null) ? 0 : lastname.hashCode());
result = prime * result + ((password == null) ? 0 : password.hashCode());
result = prime * result + ((updated_at == null) ? 0 : updated_at.hashCode());
result = prime * result + ((userList == null) ? 0 : userList.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
User other = (User) obj;
if (created_at == null) {
if (other.created_at != null)
return false;
} else if (!created_at.equals(other.created_at))
return false;
if (created_by == null) {
if (other.created_by != null)
return false;
} else if (!created_by.equals(other.created_by))
return false;
if (email == null) {
if (other.email != null)
return false;
} else if (!email.equals(other.email))
return false;
if (firstname == null) {
if (other.firstname != null)
return false;
} else if (!firstname.equals(other.firstname))
return false;
if (id == null) {
if (other.id != null)
return false;
} else if (!id.equals(other.id))
return false;
if (lastname == null) {
if (other.lastname != null)
return false;
} else if (!lastname.equals(other.lastname))
return false;
if (password == null) {
if (other.password != null)
return false;
} else if (!password.equals(other.password))
return false;
if (updated_at == null) {
if (other.updated_at != null)
return false;
} else if (!updated_at.equals(other.updated_at))
return false;
if (userList == null) {
if (other.userList != null)
return false;
} else if (!userList.equals(other.userList))
return false;
return true;
}
@Override
public String toString() {
return "User [id=" + id + ", created_at=" + created_at + ", updated_at=" + updated_at + ", firstname="
+ firstname + ", lastname=" + lastname + ", email=" + email + ", password=" + password + "]";
}
}und das Repository:
Code:
@Repository
public interface UserRepository extends CrudRepository<User, Long> {
@Query("SELECT u FROM User AS u WHERE lower(u.email) LIKE lower(CONCAT('%',:email,'%'))")
public boolean existsByEmailRegEx(@Param("email") String email);
}und eine entsprechender Test:
Code:
@SpringBootTest
class UserRepositoryTest {
@Autowired
UserService userService;
@Autowired
UserRepository userRepository;
@Test
void testExistsEmailIfEmailExists() throws ResourceNotFoundException, DuplicateException {
String firstname = "firstname";
String lastname = "lastname";
String email = "email@email.com";
String password = "password";
User user = new User(
firstname,
lastname,
email,
password
);
User createdUser = userService.createUser(null, user);
Optional<User> foundUser = userService.findUserById(createdUser.getId());
assertTrue( foundUser.isPresent(), "testExistsEmailIfEmailExists(): User (" + user + ") not stored");
// test 1
String testEmail1 = "email@email.com";
assertTrue(userRepository.existsByEmailRegEx(testEmail1), "Test 1 with '" + testEmail1 + "' not exists");
// test 2
String testEmail2 = " email@email.com ";
assertTrue(userRepository.existsByEmailRegEx(testEmail2), "Test 2 with '" + testEmail2 + "' not exists");
// test 3
String testEmail3 = " email@email.com";
assertTrue(userRepository.existsByEmailRegEx(testEmail3), "Test 3 with '" + testEmail3 + "' not exists");
// test 4
String testEmail4 = "email@email.com ";
assertTrue(userRepository.existsByEmailRegEx(testEmail4), "Test 4 with '" + testEmail4 + "' not exists");
// test 5
String testEmail5 = "EMAIL@EMAIL.com";
assertTrue(userRepository.existsByEmailRegEx(testEmail5), "Test 5 with '" + testEmail5 + "' not exists");
// clean up
userService.removeUser(foundUser.get().getId());
}
}Also wenn ich es richtig verstehe liegt ein Cast-Fehler vor, aber Spring Data exists.... liefert boolean zurück, deshalb verstehe ich den Fehler nicht.
