package de.oaa.xxx.games.chastity.community;

import java.util.UUID;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;

public interface CommunityVerificationRepository extends JpaRepository<CommunityVerificationEntity, UUID> {

	org.springframework.data.domain.Page<CommunityVerificationEntity> findAllByImageIsNotNull(Pageable pageable);

	java.util.List<CommunityVerificationEntity> findByLockId(UUID lockId);

	java.util.List<CommunityVerificationEntity> findByLockIdAndCreatedAtBetweenAndImageIsNotNull(UUID lockId, java.time.LocalDateTime from, java.time.LocalDateTime to);

	java.util.List<CommunityVerificationEntity> findByLockIdAndCreatedAtBetweenAndImageIsNull(UUID lockId, java.time.LocalDateTime from, java.time.LocalDateTime to);

	org.springframework.data.domain.Page<CommunityVerificationEntity> findByKeyholderIdIsNullAndCreatedAtBetweenAndImageIsNotNull(
			java.time.LocalDateTime from, java.time.LocalDateTime to, org.springframework.data.domain.Pageable pageable);
}
