D-Net

package eu.dnetlib.organizations.repository;

import java.time.OffsetDateTime;

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

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

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

import eu.dnetlib.organizations.model.Organization;

public interface OrganizationRepository extends JpaRepository<Organization, String> {

	@Modifying

	@Query("update Organization set created_by = ?2, creation_date = ?3 where id = ?1")

	void updateCreationDate(String id, String user, OffsetDateTime now);

	@Modifying

	@Query("update Organization set modified_by = ?2, modification_date = ?3 where id = ?1")

	void updateModificationDate(String id, String user, OffsetDateTime now);

	@Query(value = "select count(o.country) > 0 from organizations o left outer join user_countries uc on (o.country = uc.country) where o.id = ?1 and uc.email = ?2", nativeQuery = true)

	boolean verifyAuthorizationForId(String id, String user);

	@Query(value = "select count(country) > 0 from user_countries  where country = ?1 and email = ?2", nativeQuery = true)

	boolean verifyAuthorizationForCountry(String country, String user);

}