content: package io.aiven.klaw.repository;
  
  import io.aiven.klaw.dao.RegisterUserInfo;
  import java.util.List;
  import java.util.Optional;
  import org.springframework.data.repository.CrudRepository;
  
  public interface RegisterInfoRepo extends CrudRepository<RegisterUserInfo, String> {
    Optional<RegisterUserInfo> findByUsername(String userid);
  
    List<RegisterUserInfo> findAllByStatusAndTenantId(String status, int tenantId);
  
    int countByStatusAndTenantId(String status, int tenantId);
  
    List<RegisterUserInfo> findAllByStatus(String status);
  
    List<RegisterUserInfo> findAllByTenantId(int tenantId);
  
    RegisterUserInfo findFirstByUsernameAndStatusIn(String userId, List<String> status);
  
    RegisterUserInfo findFirstByUsernameAndStatus(String userId, String status);
  
    boolean existsRegisterUserInfoByUsernameAndStatus(String userId, String status);
  
    RegisterUserInfo findFirstByRegistrationId(String registrationId);
  
    RegisterUserInfo findFirstByRegistrationIdAndStatus(String registrationId, String status);
  
    void deleteByTenantId(int tenantId);
  }
  