Package energy.eddie.aiida.repositories

Interface ConnectionLimitDefaultRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<ConnectionLimitDefault,Long>, org.springframework.data.jpa.repository.JpaRepository<ConnectionLimitDefault,Long>, org.springframework.data.repository.ListCrudRepository<ConnectionLimitDefault,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<ConnectionLimitDefault,Long>, org.springframework.data.repository.PagingAndSortingRepository<ConnectionLimitDefault,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<ConnectionLimitDefault>, org.springframework.data.repository.Repository<ConnectionLimitDefault,Long>
public interface ConnectionLimitDefaultRepository extends org.springframework.data.jpa.repository.JpaRepository<ConnectionLimitDefault,Long>

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    closeOpenDefaults(UUID permissionId, Instant end)
    Ends all open defaults of a permission at the given instant, keeping them as historical defaults.
    List<ConnectionLimitDefault>
    findByUserIdAndPermissionId(UUID userId, UUID permissionId, Instant from, Instant to)
     

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

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

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

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

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

    findAll, findAllById, saveAll

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

    findAll

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

    findAll

    Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

    count, exists, findAll, findBy, findOne

  • Method Details

    • findByUserIdAndPermissionId

      @Query("SELECT d\nFROM ConnectionLimitDefault d, Permission p\nWHERE d.permissionId = p.permissionId\n AND p.userId = :userId\n AND (:permissionId IS NULL OR p.permissionId = :permissionId)\n AND d.start < :to AND (d.end IS NULL OR d.end > :from)\n") List<ConnectionLimitDefault> findByUserIdAndPermissionId(UUID userId, @Nullable UUID permissionId, Instant from, Instant to)

    • closeOpenDefaults

      @Modifying @Query("UPDATE ConnectionLimitDefault d SET d.end = :end\nWHERE d.permissionId = :permissionId AND d.end IS NULL\n") void closeOpenDefaults(UUID permissionId, Instant end)
      Ends all open defaults of a permission at the given instant, keeping them as historical defaults.