D-Net

package eu.dnetlib.openaire.exporter.datasource.repository;

import javax.transaction.Transactional;

import eu.dnetlib.openaire.exporter.model.datasource.db.DatasourceDbEntry;

import org.springframework.data.jpa.repository.JpaRepository;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

import org.springframework.data.jpa.repository.Modifying;

import org.springframework.data.jpa.repository.Query;

import org.springframework.stereotype.Repository;

/**

 * Created by claudio on 12/04/2017.

 */

@Repository

public interface DatasourceDbEntryRepository extends JpaRepository<DatasourceDbEntry, String>, JpaSpecificationExecutor<DatasourceDbEntry> {

	DatasourceDbEntry findOneById(String id);

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

	boolean isManaged(String id);

	@Modifying

	@Transactional

	@Query("update #{#entityName} d set d.managed = ?2 where d.id = ?1")

	void setManaged(String id, boolean managed);

	@Modifying

	@Transactional

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

	void setDatasourcename(String id, String officialname, String englishname);

	@Modifying

	@Transactional

	@Query("update #{#entityName} d set d.latitude = ?2, d.longitude = ?3 where d.id = ?1")

	void setCoordinates(String dsId, Double latitude, Double longitude);

	@Modifying

	@Transactional

	@Query("update #{#entityName} d set d.timezone = ?2 where d.id = ?1")

	void setTimezone(String dsId, String timezone);

	@Modifying

	@Transactional

	@Query("update #{#entityName} d set d.typology = ?2 where d.id = ?1")

	void setTypology(String dsId, String typology);

	@Modifying

	@Transactional

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

	void setRegisteringUser(String id, String registeredby);

	@Modifying

	@Transactional

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

	void setPlatform(String id, String platform);

}