com.silverpeas.sharing.repository
Interface TicketRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Ticket,UuidPk>, org.springframework.data.jpa.repository.JpaRepository<Ticket,UuidPk>, org.springframework.data.repository.PagingAndSortingRepository<Ticket,UuidPk>, org.springframework.data.repository.Repository<Ticket,UuidPk>

public interface TicketRepository
extends org.springframework.data.jpa.repository.JpaRepository<Ticket,UuidPk>

Author:

ehugonnet

Method Summary

List<Ticket>	findAllReservationsForUser(String userId)
List<Ticket>	findAllTicketForSharedObjectId(Long sharedObjectId, String ticketType)

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, flush, save, saveAndFlush

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, delete, delete, deleteAll, exists, findAll, findOne, save

Method Detail

findAllTicketForSharedObjectId

@Query(value="SELECT t FROM Ticket t WHERE t.sharedObjectId = :sharedObjectId AND t.sharedObjectType = :ticketType")
List<Ticket> findAllTicketForSharedObjectId(@Param(value="sharedObjectId")
                                                  Long sharedObjectId,
                                                  @Param(value="ticketType")
                                                  String ticketType)

findAllReservationsForUser

@Query(value="SELECT DISTINCT ticket FROM Ticket ticket WHERE ticket.creatorId = :userId")
List<Ticket> findAllReservationsForUser(@Param(value="userId")
                                              String userId)