Package sk.iway.iwcm.components.form_settings.jpa

Interface FormSettingsRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<FormSettingsEntity,Long>, DomainIdRepository<FormSettingsEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<FormSettingsEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<FormSettingsEntity>, org.springframework.data.repository.ListCrudRepository<FormSettingsEntity,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<FormSettingsEntity,Long>, org.springframework.data.repository.PagingAndSortingRepository<FormSettingsEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<FormSettingsEntity>, org.springframework.data.repository.Repository<FormSettingsEntity,Long>

@Repository
public interface FormSettingsRepository
extends DomainIdRepository<FormSettingsEntity,Long>

Nested Class Summary

Nested classes/interfaces inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

org.springframework.data.jpa.repository.JpaSpecificationExecutor.SpecificationFluentQuery<T extends Object>

Method Summary

Modifier and Type	Method	Description
void	deleteByFormNameAndDomainId(String formName, Integer domainId)
FormSettingsEntity	findByFormNameAndDomainId(String formName, Integer domainId)
Long	findId(String formName, Integer domainId)
Integer	getResponseAttempts(String formName, Integer domainId)
Integer	getViewCount(String formName, Integer domainId)
int	incrementFormViewCount(String formName, Integer domainId)
int	incrementResponseAttempts(String formName, Integer domainId)
Boolean	isDoubleOptIn(String formName, Integer domainId)
Boolean	isRowView(String formName, Integer domainId)

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

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

Methods inherited from interface sk.iway.iwcm.system.datatable.spring.DomainIdRepository

findAllByDomainId, findAllByDomainId, findFirstByIdAndDomainId

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.jpa.repository.JpaSpecificationExecutor

count, count, delete, delete, exists, exists, findAll, findAll, findAll, findAll, findAll, findBy, findBy, findOne, findOne, update

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

findByFormNameAndDomainId

FormSettingsEntity findByFormNameAndDomainId(String formName,
 Integer domainId)

deleteByFormNameAndDomainId

@Transactional
@Modifying
void deleteByFormNameAndDomainId(String formName,
 Integer domainId)

findId

@Query("SELECT fse.id FROM FormSettingsEntity fse WHERE fse.formName = :formName AND fse.domainId = :domainId")
Long findId(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)

isRowView

@Query("SELECT fse.rowView FROM FormSettingsEntity fse WHERE fse.formName = :formName AND fse.domainId = :domainId")
Boolean isRowView(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)

isDoubleOptIn

@Query("SELECT fse.doubleOptIn FROM FormSettingsEntity fse WHERE fse.formName = :formName AND fse.domainId = :domainId")
Boolean isDoubleOptIn(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)

incrementFormViewCount

@Transactional
@Modifying
@Query("UPDATE FormSettingsEntity fse SET fse.viewCount = COALESCE(fse.viewCount, 0) + 1 WHERE fse.formName = :formName AND fse.domainId = :domainId")
int incrementFormViewCount(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)

getViewCount

@Query("SELECT fse.viewCount FROM FormSettingsEntity fse WHERE fse.formName = :formName AND fse.domainId = :domainId")
Integer getViewCount(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)

getResponseAttempts

@Query("SELECT fse.responseAttempts FROM FormSettingsEntity fse WHERE fse.formName = :formName AND fse.domainId = :domainId")
Integer getResponseAttempts(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)

incrementResponseAttempts

@Transactional
@Modifying
@Query("UPDATE FormSettingsEntity fse SET fse.responseAttempts = COALESCE(fse.responseAttempts, 0) + 1 WHERE fse.formName = :formName AND fse.domainId = :domainId")
int incrementResponseAttempts(@Param("formName")
 String formName,
 @Param("domainId")
 Integer domainId)