Package com.spaghetticodegang.trylater.recommendation.assignment

Schnittstelle RecommendationAssignmentRepository

Alle Superschnittstellen:

org.springframework.data.repository.CrudRepository<RecommendationAssignment,Long>, org.springframework.data.jpa.repository.JpaRepository<RecommendationAssignment,Long>, org.springframework.data.repository.ListCrudRepository<RecommendationAssignment,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<RecommendationAssignment,Long>, org.springframework.data.repository.PagingAndSortingRepository<RecommendationAssignment,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<RecommendationAssignment>, org.springframework.data.repository.Repository<RecommendationAssignment,Long>

public interface RecommendationAssignmentRepository
extends org.springframework.data.jpa.repository.JpaRepository<RecommendationAssignment,Long>

Repository interface for accessing and managing recommendation assignment entities in the database.

Methodenübersicht

Modifizierer und Typ	Methode	Beschreibung
void	deleteRecommendationAssignmentsByUserId(Long userId)	Deletes all assignment for the given user.
boolean	existsRecommendationAssignmentByRecommendationId(Long recommendationId)	Checks if a recommendation assignment for a given recommendation ID exists.
List<RecommendationAssignment>	findAllRecommendationAssignmentByUserId(Long userId)	Finds all recommendation assignments for the given user ID.
RecommendationAssignment	findRecommendationAssignmentByUserIdAndRecommendationId(Long userId, Long recommendationId)	Finds the recommendation assignment for the given user ID and recommendation ID.
List<Recommendation>	findRecommendationsByUserIdAndRecommendationAssignmentStatus(Long id, RecommendationAssignmentStatus recommendationAssignmentStatus)	Finds all assigned recommendations for a given user with a specific status.

Von Schnittstelle geerbte Methoden org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Von Schnittstelle geerbte Methoden org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

Von Schnittstelle geerbte Methoden org.springframework.data.repository.ListCrudRepository

findAll, findAllById, saveAll

Von Schnittstelle geerbte Methoden org.springframework.data.repository.ListPagingAndSortingRepository

findAll

Von Schnittstelle geerbte Methoden org.springframework.data.repository.PagingAndSortingRepository

findAll

Von Schnittstelle geerbte Methoden org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Methodendetails

findRecommendationsByUserIdAndRecommendationAssignmentStatus

@Query("SELECT r.recommendation FROM RecommendationAssignment r WHERE r.receiver.id = :id AND r.recommendationAssignmentStatus = :recommendationAssignmentStatus\n")
List<Recommendation> findRecommendationsByUserIdAndRecommendationAssignmentStatus(Long id,
 RecommendationAssignmentStatus recommendationAssignmentStatus)

Finds all assigned recommendations for a given user with a specific status.

Parameter:

id - the user ID

recommendationAssignmentStatus - the assignment status

Gibt zurück:

a list of recommendation entities or an empty list

findRecommendationAssignmentByUserIdAndRecommendationId

@Query("SELECT r FROM RecommendationAssignment r WHERE r.receiver.id = :userId AND r.recommendation.id = :recommendationId\n")
RecommendationAssignment findRecommendationAssignmentByUserIdAndRecommendationId(Long userId,
 Long recommendationId)

Finds the recommendation assignment for the given user ID and recommendation ID.

Parameter:

userId - the given user ID

recommendationId - the given recommendation ID

Gibt zurück:

A RecommendationAssignment Entity

findAllRecommendationAssignmentByUserId

@Query("SELECT r FROM RecommendationAssignment r WHERE r.receiver.id = :userId\n")
List<RecommendationAssignment> findAllRecommendationAssignmentByUserId(Long userId)

Finds all recommendation assignments for the given user ID.

Parameter:

userId - the given user ID

Gibt zurück:

A RecommendationAssignment Entity

existsRecommendationAssignmentByRecommendationId

@Query("SELECT CASE WHEN count(r) > 0 THEN true ELSE false END\nFROM RecommendationAssignment r\nWHERE r.recommendation.id = :recommendationId\n")
boolean existsRecommendationAssignmentByRecommendationId(Long recommendationId)

Checks if a recommendation assignment for a given recommendation ID exists.

Parameter:

recommendationId - the ID of the recommendation

Gibt zurück:

TRUE or FALSE

deleteRecommendationAssignmentsByUserId

@Modifying
@Query("DELETE FROM RecommendationAssignment r WHERE r.receiver.id = :userId\n")
void deleteRecommendationAssignmentsByUserId(Long userId)

Deletes all assignment for the given user.

Parameter:

userId - the ID for the user that assignments should be deleting