@Repository public interface VersionRepository extends org.springframework.data.jpa.repository.JpaRepository<Version,java.lang.Integer>
| Modifier and Type | Method and Description |
|---|---|
void |
deleteByDocId(int docId) |
java.util.List<Version> |
findByDocId(int docId) |
Version |
findByDocIdAndNo(int docId,
int no) |
Version |
findDefault(int docId) |
Version |
findLatest(int docId) |
Version |
findWorking(int docId) |
void |
updateDefaultNo(int docId,
int no,
int userId) |
deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAll, flush, getOne, save, saveAndFlushfindAll@Query(value="SELECT v FROM Version v WHERE v.docId = ?1 ORDER BY v.no") java.util.List<Version> findByDocId(int docId)
@Modifying @Query(value="DELETE FROM Version v WHERE v.docId = ?1") void deleteByDocId(int docId)
Version findByDocIdAndNo(int docId, int no)
@Query(value="SELECT v FROM Version v WHERE v.no = 0 AND v.docId = ?1") Version findWorking(int docId)
@Query(value="SELECT v FROM Meta m, Version v WHERE m.defaultVersionNo = v.no AND m.id = v.docId AND m.id = ?1") Version findDefault(int docId)
@Query(value="SELECT v FROM Version v WHERE v.id = (SELECT max(v.id) FROM Version v WHERE v.docId = ?1)") Version findLatest(int docId)
@Modifying
@Query(value="UPDATE Meta m SET m.defaultVersionNo = :no, m.publisherId = :publisherId WHERE m.id = :docId")
void updateDefaultNo(@Param(value="docId")
int docId,
@Param(value="no")
int no,
@Param(value="publisherId")
int userId)