Package org.openwms.tms.routing

Interface ActionRepository

All Superinterfaces:

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

public interface ActionRepository
extends org.springframework.data.jpa.repository.JpaRepository<Action,Long>

A ActionRepository.

Author:

Heiko Scherrer

Method Summary

Modifier and Type	Method	Description
Optional<Action>	findByActionTypeAndRouteAndLocationGroupName(String actionType, String routeId, String locationGroupName)
Optional<Action>	findByActionTypeAndRouteAndLocationKey(String actionType, String routeId, String locationKey)
Optional<Action>	findBypKey(String pKey)

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, findAll, findAll, findAllById, flush, getById, getOne, getReferenceById, saveAll, saveAllAndFlush, saveAndFlush

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

findBypKey

Optional<Action> findBypKey(String pKey)

findByActionTypeAndRouteAndLocationKey

@Query("select a\n  from Action a\n where a.actionType = :actionType\n   and a.route.routeId = :routeId\n   and a.locationKey is not null\n   and a.locationKey = :locationKey\n   and a.enabled = true\n")
Optional<Action> findByActionTypeAndRouteAndLocationKey(@Param("actionType")
 String actionType,
 @Param("routeId")
 String routeId,
 @Param("locationKey")
 String locationKey)

findByActionTypeAndRouteAndLocationGroupName

@Query("select a\n  from Action a\n where a.actionType = :actionType\n   and a.route.routeId = :routeId\n   and a.locationGroupName is not null\n   and a.locationGroupName = :locationGroupName\n   and a.enabled = true\n")
Optional<Action> findByActionTypeAndRouteAndLocationGroupName(@Param("actionType")
 String actionType,
 @Param("routeId")
 String routeId,
 @Param("locationGroupName")
 String locationGroupName)