Package eu.dnetlib.openaire.dsm.dao

Interface DatasourceDbEntryRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<DatasourceDbEntry,String>, org.springframework.data.jpa.repository.JpaRepository<DatasourceDbEntry,String>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<DatasourceDbEntry>, org.springframework.data.repository.PagingAndSortingRepository<DatasourceDbEntry,String>, org.springframework.data.repository.query.QueryByExampleExecutor<DatasourceDbEntry>, org.springframework.data.repository.Repository<DatasourceDbEntry,String>

@Repository
@ConditionalOnProperty(value="openaire.exporter.enable.dsm",
                       havingValue="true")
public interface DatasourceDbEntryRepository
extends org.springframework.data.jpa.repository.JpaRepository<DatasourceDbEntry,String>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<DatasourceDbEntry>

Created by claudio on 12/04/2017.

Method Summary

Modifier and Type	Method	Description
Optional<DatasourceDbEntry>	findByNamespaceprefix(String namespaceprefix)
Boolean	hasRegistrationdate(String id)
boolean	isManaged(String id)
void	setCoordinates(String dsId, Double latitude, Double longitude)
void	setDatasourcename(String id, String officialname, String englishname)
void	setEoscDatasourceType(String dsId, String type)
void	setLogoUrl(String dsId, String logourl)
void	setManaged(String id, boolean managed)
void	setPlatform(String id, String platform)
void	setRegisteringUser(String id, String registeredby)
void	setRegistrationDate(String id, Date registrationdate)
void	setTimezone(String dsId, String timezone)

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, saveAll, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

count, findAll, findAll, findAll, findOne

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

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

Method Details

findByNamespaceprefix

Optional<DatasourceDbEntry> findByNamespaceprefix(String namespaceprefix)

isManaged

@Query("select d.managed from #{#entityName} d where d.id = ?1")
boolean isManaged(String id)

setManaged

@Modifying
@Query("update #{#entityName} d set d.managed = ?2 where d.id = ?1")
void setManaged(String id,
 boolean managed)

setDatasourcename

@Modifying
@Query("update #{#entityName} d set d.officialname = ?2, d.englishname = ?3 where d.id = ?1")
void setDatasourcename(String id,
 String officialname,
 String englishname)

setLogoUrl

@Modifying
@Query("update #{#entityName} d set d.logourl = ?2 where d.id = ?1")
void setLogoUrl(String dsId,
 String logourl)

setCoordinates

@Modifying
@Query("update #{#entityName} d set d.latitude = ?2, d.longitude = ?3 where d.id = ?1")
void setCoordinates(String dsId,
 Double latitude,
 Double longitude)

setTimezone

@Modifying
@Query("update #{#entityName} d set d.timezone = ?2 where d.id = ?1")
void setTimezone(String dsId,
 String timezone)

setEoscDatasourceType

@Modifying
@Query("update #{#entityName} d set d.eoscDatasourceType = ?2 where d.id = ?1")
void setEoscDatasourceType(String dsId,
 String type)

setRegisteringUser

@Modifying
@Query("update #{#entityName} d set d.registeredby = ?2 where d.id = ?1")
void setRegisteringUser(String id,
 String registeredby)

hasRegistrationdate

@Query("select case when registrationdate <> null then true else false end as hasregistrationdate from #{#entityName} where id = ?1")
Boolean hasRegistrationdate(String id)

setRegistrationDate

@Modifying
@Query("update #{#entityName} d set d.registrationdate = ?2 where d.id = ?1")
void setRegistrationDate(String id,
 Date registrationdate)

setPlatform

@Modifying
@Query("update #{#entityName} d set d.platform = ?2 where d.id = ?1")
void setPlatform(String id,
 String platform)