Package de.dlr.proseo.model.dao
Schnittstelle OrbitRepository
- Alle Superschnittstellen:
org.springframework.data.repository.CrudRepository<Orbit,
,Long> org.springframework.data.jpa.repository.JpaRepository<Orbit,
,Long> org.springframework.data.repository.PagingAndSortingRepository<Orbit,
,Long> org.springframework.data.repository.query.QueryByExampleExecutor<Orbit>
,org.springframework.data.repository.Repository<Orbit,
Long>
@Repository
public interface OrbitRepository
extends org.springframework.data.jpa.repository.JpaRepository<Orbit,Long>
Data Access Object for the Orbit class
- Autor:
- Dr. Thomas Bassler
-
Methodenübersicht
Modifizierer und TypMethodeBeschreibungfindByMissionCodeAndSpacecraftCodeAndOrbitNumber
(String missionCode, String spacecraftCode, Integer orbitNumber) Get the orbit with the given spacecraft and orbit numberfindByMissionCodeAndSpacecraftCodeAndOrbitNumberBetween
(String missionCode, String spacecraftCode, Integer orbitNumberFrom, Integer orbitNumberTo) Get all orbits for the given spacecraft and orbit number rangefindByMissionCodeAndSpacecraftCodeAndStartTimeBetween
(String missionCode, String spacecraftCode, Instant startTimeFrom, Instant startTimeTo) Get all orbits for a given spacecraft that start in the given time interval (inclusive)findByMissionCodeAndSpacecraftCodeAndTimeIntersect
(String missionCode, String spacecraftCode, Instant startTime, Instant stopTime) Get all orbits for a given spacecraft that start and stop time intersects the given time interval (inclusive)Von Schnittstelle geerbte Methoden org.springframework.data.repository.CrudRepository
count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save
Von Schnittstelle geerbte Methoden org.springframework.data.jpa.repository.JpaRepository
deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush
Von Schnittstelle geerbte Methoden org.springframework.data.repository.PagingAndSortingRepository
findAll
Von Schnittstelle geerbte Methoden org.springframework.data.repository.query.QueryByExampleExecutor
count, exists, findAll, findOne
-
Methodendetails
-
findByMissionCodeAndSpacecraftCodeAndOrbitNumber
@Query("select o from Orbit o where o.spacecraft.mission.code = ?1 and o.spacecraft.code = ?2 and o.orbitNumber = ?3") Orbit findByMissionCodeAndSpacecraftCodeAndOrbitNumber(String missionCode, String spacecraftCode, Integer orbitNumber) Get the orbit with the given spacecraft and orbit number- Parameter:
missionCode
- the mission codespacecraftCode
- the spacecraft codeorbitNumber
- the orbit number- Gibt zurück:
- the unique orbit identified by the spacecraft code and the orbit number
-
findByMissionCodeAndSpacecraftCodeAndOrbitNumberBetween
@Query("select o from Orbit o where o.spacecraft.mission.code = ?1 and o.spacecraft.code = ?2 and o.orbitNumber between ?3 and ?4") List<Orbit> findByMissionCodeAndSpacecraftCodeAndOrbitNumberBetween(String missionCode, String spacecraftCode, Integer orbitNumberFrom, Integer orbitNumberTo) Get all orbits for the given spacecraft and orbit number range- Parameter:
missionCode
- the mission codespacecraftCode
- the spacecraft codeorbitNumberFrom
- the first orbit numberorbitNumberTo
- the last orbit number- Gibt zurück:
- a list of orbits satisfying the spacecraft code and the orbit number range
-
findByMissionCodeAndSpacecraftCodeAndStartTimeBetween
@Query("select o from Orbit o where o.spacecraft.mission.code = ?1 and o.spacecraft.code = ?2 and o.startTime between ?3 and ?4") List<Orbit> findByMissionCodeAndSpacecraftCodeAndStartTimeBetween(String missionCode, String spacecraftCode, Instant startTimeFrom, Instant startTimeTo) Get all orbits for a given spacecraft that start in the given time interval (inclusive)- Parameter:
missionCode
- the mission codespacecraftCode
- the spacecraft codestartTimeFrom
- the earliest start timestartTimeTo
- the latest start time- Gibt zurück:
- a list of orbits satisfying the selection criteria
-
findByMissionCodeAndSpacecraftCodeAndTimeIntersect
@Query("select o from Orbit o where o.spacecraft.mission.code = ?1 and o.spacecraft.code = ?2 and o.stopTime > ?3 and o.startTime < ?4") List<Orbit> findByMissionCodeAndSpacecraftCodeAndTimeIntersect(String missionCode, String spacecraftCode, Instant startTime, Instant stopTime) Get all orbits for a given spacecraft that start and stop time intersects the given time interval (inclusive)- Parameter:
missionCode
- the mission codespacecraftCode
- the spacecraft codestartTime
- the start timestopTime
- the stop time- Gibt zurück:
- a list of orbits satisfying the selection criteria
-