backend/com.tecknobit.nova.helpers.services.repositories.releaseutils/ReleaseEventsRepository

ReleaseEventsRepository

@Service
@Repository
interface ReleaseEventsRepository : JpaRepository<T, ID>

The ReleaseEventsRepository interface is useful to manage the queries for the events of the releases

Author

N7ghtm4r3 - Tecknobit

See also

JpaRepository

Functions

Link copied to clipboard
abstract fun <S : T?> count(example: Example<S>): Long
Link copied to clipboard
abstract fun delete(entity: T)
Link copied to clipboard
abstract fun deleteAll(entities: Iterable<out T>)
Link copied to clipboard
abstract fun deleteAllById(ids: Iterable<out ID>)
Link copied to clipboard
abstract fun deleteAllByIdInBatch(ids: Iterable<ID>)
Link copied to clipboard
abstract fun deleteAllInBatch(entities: Iterable<T>)
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + ASSET_UPLOADING_EVENTS_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
abstract fun deleteAssetUploadingReleaseEvent(@Param(value = "id") eventId: String)
Method to execute the query to delete an existing asset uploading event (AssetUploadingEvent)
Link copied to clipboard
abstract fun deleteById(id: ID)
Link copied to clipboard
open fun deleteInBatch(entities: Iterable<T>)
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + REJECTED_RELEASE_EVENTS_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
abstract fun deleteRejectedReleaseEvent(@Param(value = "id") eventId: String)
Method to execute the query to delete an existing rejected release event (RejectedReleaseEvent)
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""DELETE FROM " + RELEASE_EVENTS_KEY + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
abstract fun deleteReleaseEvent(@Param(value = "id") eventId: String)
Method to execute the query to delete an existing release event
Link copied to clipboard
abstract fun <S : T?> exists(example: Example<S>): Boolean
Link copied to clipboard
abstract fun existsById(id: ID): Boolean
Link copied to clipboard
abstract fun <S : T?> findAll(example: Example<S>): List<S>
abstract fun findAll(): Iterable<T>
abstract fun findAll(): List<T>
abstract fun findAll(pageable: Pageable): Page<T>
abstract fun <S : T?> findAll(example: Example<S>): Iterable<S>
abstract fun <S : T?> findAll(example: Example<S>, pageable: Pageable): Page<S>
Link copied to clipboard
abstract fun findAllById(ids: Iterable<ID>): Iterable<T>
abstract fun findAllById(ids: Iterable<ID>): List<T>
Link copied to clipboard
abstract fun <S : T?, R> findBy(example: Example<S>, queryFunction: (FluentQuery.FetchableFluentQuery<S>) -> R): R
Link copied to clipboard
abstract fun findById(id: ID): Optional<T>
Link copied to clipboard
abstract fun <S : T?> findOne(example: Example<S>): Optional<S>
Link copied to clipboard
abstract fun flush()
Link copied to clipboard
abstract fun getById(id: ID): T
Link copied to clipboard
abstract fun getOne(id: ID): T
Link copied to clipboard
abstract fun getReferenceById(id: ID): T
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = "INSERT INTO " + ASSETS_UPLOADED_KEY + " (" + IDENTIFIER_KEY + "," + ASSET_URL_KEY + "," + ASSET_UPLOADING_EVENT_IDENTIFIER_KEY + "," + NAME_KEY + " )" + " VALUES (" + ":" + IDENTIFIER_KEY + "," + ":" + ASSET_URL_KEY + "," + ":" + ASSET_UPLOADING_EVENT_IDENTIFIER_KEY + "," + ":" + NAME_KEY + ")", nativeQuery = true)
abstract fun insertAsset(@Param(value = "id") assetId: String, @Param(value = "asset_url") assetUrl: String, @Param(value = "asset_uploading_event_id") eventId: String, @Param(value = "name") assetName: String)
Method to execute the query to insert a new asset uploaded (AssetUploaded)
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = "INSERT INTO " + ASSET_UPLOADING_EVENTS_KEY + " (" + IDENTIFIER_KEY + "," + RELEASE_EVENT_DATE_KEY + "," + RELEASE_IDENTIFIER_KEY + "," + RELEASE_EVENT_STATUS_KEY + "," + COMMENT_KEY + " )" + " VALUES (" + ":" + IDENTIFIER_KEY + "," + ":" + RELEASE_EVENT_DATE_KEY + "," + ":" + RELEASE_IDENTIFIER_KEY + "," + ":" + RELEASE_EVENT_STATUS_KEY + "," + ":" + COMMENT_KEY + ")", nativeQuery = true)
abstract fun insertAssetUploading(@Param(value = "id") eventId: String, @Param(value = "release_event_date") releaseEventDate: Long, @Param(value = "release_id") releaseId: String, @Param(value = "status") status: String, @Param(value = "comment") comment: String)
Method to execute the query to insert a new asset uploading event (AssetUploadingEvent)
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = "INSERT INTO " + REJECTED_RELEASE_EVENTS_KEY + " (" + IDENTIFIER_KEY + "," + RELEASE_EVENT_DATE_KEY + "," + RELEASE_IDENTIFIER_KEY + "," + RELEASE_EVENT_STATUS_KEY + "," + REASONS_KEY + " )" + " VALUES (" + ":" + IDENTIFIER_KEY + "," + ":" + RELEASE_EVENT_DATE_KEY + "," + ":" + RELEASE_IDENTIFIER_KEY + "," + ":" + RELEASE_EVENT_STATUS_KEY + "," + ":" + REASONS_KEY + ")", nativeQuery = true)
abstract fun insertRejectedReleaseEvent(@Param(value = "id") eventId: String, @Param(value = "release_event_date") releaseEventDate: Long, @Param(value = "release_id") releaseId: String, @Param(value = "status") status: String, @Param(value = "reasons") reasons: String)
Method to execute the query to insert a new rejected release event (RejectedReleaseEvent)
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = "INSERT INTO " + RELEASE_EVENTS_KEY + " (" + IDENTIFIER_KEY + "," + RELEASE_EVENT_DATE_KEY + "," + RELEASE_IDENTIFIER_KEY + "," + RELEASE_EVENT_STATUS_KEY + " )" + " VALUES (" + ":" + IDENTIFIER_KEY + "," + ":" + RELEASE_EVENT_DATE_KEY + "," + ":" + RELEASE_IDENTIFIER_KEY + "," + ":" + RELEASE_EVENT_STATUS_KEY + ")", nativeQuery = true)
abstract fun insertReleaseEvent(@Param(value = "id") eventId: String, @Param(value = "release_event_date") releaseEventDate: Long, @Param(value = "release_id") releaseId: String, @Param(value = "status") status: String)
Method to execute the query to insert a new release event
Link copied to clipboard
abstract fun <S : T?> save(entity: S): S
Link copied to clipboard
abstract fun <S : T?> saveAll(entities: Iterable<S>): Iterable<S>
abstract fun <S : T?> saveAll(entities: Iterable<S>): List<S>
Link copied to clipboard
abstract fun <S : T?> saveAllAndFlush(entities: Iterable<S>): List<S>
Link copied to clipboard
abstract fun <S : T?> saveAndFlush(entity: S): S
Link copied to clipboard
@Modifying(clearAutomatically = true)
@Query(value = ""UPDATE " + ASSET_UPLOADING_EVENTS_KEY + " SET " + COMMENTED_KEY + "= '1'" + " WHERE " + IDENTIFIER_KEY + "=:" + IDENTIFIER_KEY", nativeQuery = true)
abstract fun setUploadingCommented(@Param(value = "id") eventId: String)
Method to execute the query to set as commented the last AssetUploadingEvent