CRUD存储库不尊重唯一约束

Question

我有以下JPA实体

@Entity
class UserEntity {

    companion object {
        fun fromParameters(uuid: String, email: String, password: String, firstName: String, lastName: String) =
            UserEntity().apply {
                this.uuid = uuid
                this.email = email
                this.password = password
                this.firstName = firstName
                this.lastName = lastName
            }
    }

    @Id
    lateinit var uuid: String

    @Column(nullable = false, unique = true)
    lateinit var email: String

    @Column(nullable = false)
    lateinit var password: String

    @Column(nullable = false)
    lateinit var firstName: String

    @Column(nullable = false)
    lateinit var lastName: String
}

这是我检查唯一约束的测试，插入具有相同电子邮件的另一个用户。

@RunWith(SpringRunner::class)
@DataJpaTest
@AutoConfigureTestEntityManager
class TestUserCrudRepository {

    @Autowired
    private lateinit var userCrudRepository: UserCrudRepository

    private val testUserEntity = UserEntity.fromParameters(
        UUID.randomUUID().toString(),
        "[e-mail]",
        "password".toHash(),
        "Caetano",
        "Veloso"
    )

    @Test
    fun `when email already exists it should throw error`() {
        with (userCrudRepository) {
            save(testUserEntity)
            val newUserEntity = with (testUserEntity) { UserEntity.fromParameters(UUID.randomUUID().toString(), email, password, firstName, lastName) }
            shouldThrow<SQLException> { save(newUserEntity) }
        }
    }
}

Expected exception java.sql.SQLException but no exception was thrown

Hibernate: drop table user_entity if exists
Hibernate: create table user_entity (uuid varchar(255) not null, email varchar(255) not null, first_name varchar(255) not null, last_name varchar(255) not null, password varchar(255) not null, primary key (uuid))
Hibernate: alter table user_entity add constraint UK_4xad1enskw4j1t2866f7sodrx unique (email)

Answer 1

发生这种情况的原因是没有发出insert语句。

Hibernate不会刷新会话，除非它有充分的理由这样做。

1. @datajpatest是@transactional。这意味着在@test方法中执行的事务将在该方法返回后回滚。
2. userentity映射还鼓励hibernate延迟insert（尝试在id属性上使用@generatedvalue(strategy=IDENTITY)强制发出insert)

在运行测试时，不需要深入研究太多细节，会发生以下情况：

1. Spring的测试基础结构begin的事务
2. @test方法运行
3. save(testUserEntity)-Hibernate意识到没有理由命中数据库并延迟insert
4. shouldthrow {save（newUserEntity）} -与上一页相同
5. @test方法返回
6. 事务回滚。Hibernate确实执行inserts，因为没有理由执行。

最简单的方法是使用jparepository#flush:

with (userCrudRepository) {
    save(testUserEntity)
    val newUserEntity = with (testUserEntity) { UserEntity.fromParameters(UUID.randomUUID().toString(), email, password, firstName, lastName) }
    save(newUserEntity)
    assertThrows<DataIntegrityViolationException> {
        flush()
    }
}

我猜您已经扩展了crudrepository...您可能希望扩展jparepository。

请参见：Spring Data JPA中的CrudRepository和JpaRepository接口之间有什么区别？

例外情况说明

您希望抛出SQLException。

参见：一致的异常层次结构