@Query(value = "SELECT DISTINCT ON (runningid) * from Fragment WHERE variantid = :variantID AND open = :isOpen ORDER BY runningid DESC LIMIT :limit", nativeQuery = true)

abstract fun findAllRunningVersionsOfVariant(@Param(value = "variantID") variantID: String, @Param(value = "limit") limit: Int, @Param(value = "isOpen") isOpen: Boolean = false): List<Fragment>

findBy

abstract fun <S : Fragment, R : Any> findBy(example: Example<S>, queryFunction: Function<FluentQuery.FetchableFluentQuery<S>, R>): R

findById

abstract fun findById(id: Long): Optional<Fragment>

findFragmentByIsReferenceIsTrue

abstract fun findFragmentByIsReferenceIsTrue(): List<Fragment>

findFragmentByVariantID

abstract fun findFragmentByVariantID(variantID: String): List<Fragment>

findFragmentByVariantIDAndVariantTime

abstract fun findFragmentByVariantIDAndVariantTime(variantID: String, variantTime: Timestamp): List<Fragment>

findFragmentByVariantTime

abstract fun findFragmentByVariantTime(variantTime: Timestamp): List<Fragment>

findModelOnlyFragmentWithVariantAndRunningIDFirstLazy

@Query(value = "SELECT f.* from Fragment f WHERE f.variantID = :variantID AND f.runningID = :runningID AND f.instance_dataid is NULL AND f.open = :isOpen", nativeQuery = true)

abstract fun findModelOnlyFragmentWithVariantAndRunningIDFirstLazy(@Param(value = "variantID") variantID: String, @Param(value = "runningID") runningID: String, @Param(value = "isOpen") isOpen: Boolean = false): Fragment?

findMostRecentFragmentByVariantIDLazy

@Query(value = "SELECT DISTINCT ON (running_time, variantID) * from Fragment f WHERE f.variantID = :variantID AND running_time = ( SELECT MAX(running_time) FROM Fragment f1 WHERE f1.variantID = :variantID) AND f.open = :isOpen ORDER BY running_time DESC, variantID LIMIT 1", nativeQuery = true)

abstract fun findMostRecentFragmentByVariantIDLazy(@Param(value = "variantID") variantID: String, @Param(value = "isOpen") isOpen: Boolean = false): Fragment?

findMostRecentFragmentsByVariantNameLazy

@Query(value = "SELECT DISTINCT ON (running_time, variantID) f.* from Fragment f WHERE f.variant_name = :variantName AND running_time = ( SELECT MAX(running_time) FROM Fragment f1 WHERE f1.variant_name = :variantName) AND f.open = :isOpen ORDER BY running_time DESC, variantID LIMIT :limit", nativeQuery = true)

abstract fun findMostRecentFragmentsByVariantNameLazy(@Param(value = "variantName") variantName: String, @Param(value = "limit") limit: Int, @Param(value = "isOpen") isOpen: Boolean = false): List<Fragment>

findMostRecentFragmentsByVariantTimeLazy

@Query(value = "SELECT * from Fragment f WHERE f.variant_time = :variantTime AND running_time = ( SELECT MAX(running_time) FROM Fragment f1 WHERE f1.variant_time = :variantTime) AND f.open = :isOpen ORDER BY running_time DESC LIMIT :limit", nativeQuery = true)

abstract fun findMostRecentFragmentsByVariantTimeLazy(@Param(value = "variantTime") variantTime: Timestamp, @Param(value = "limit") limit: Int, @Param(value = "isOpen") isOpen: Boolean = false): List<Fragment>

findOne