D-Net

package eu.dnetlib.organizations.utils;

import java.time.OffsetDateTime;

import java.util.List;

import javax.transaction.Transactional;

import org.apache.commons.lang3.StringUtils;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.cache.annotation.Cacheable;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.stereotype.Component;

import eu.dnetlib.organizations.model.Acronym;

import eu.dnetlib.organizations.model.Organization;

import eu.dnetlib.organizations.model.OtherIdentifier;

import eu.dnetlib.organizations.model.OtherName;

import eu.dnetlib.organizations.model.Relationship;

import eu.dnetlib.organizations.model.Url;

import eu.dnetlib.organizations.model.view.OrganizationView;

import eu.dnetlib.organizations.repository.AcronymRepository;

import eu.dnetlib.organizations.repository.OrganizationRepository;

import eu.dnetlib.organizations.repository.OtherIdentifierRepository;

import eu.dnetlib.organizations.repository.OtherNameRepository;

import eu.dnetlib.organizations.repository.RelationshipRepository;

import eu.dnetlib.organizations.repository.UrlRepository;

@Component

public class DatabaseUtils {

	@Autowired

	private AcronymRepository acronymRepository;

	@Autowired

	private OrganizationRepository organizationRepository;

	@Autowired

	private OtherIdentifierRepository otherIdentifierRepository;

	@Autowired

	private OtherNameRepository otherNameRepository;

	@Autowired

	private UrlRepository urlRepository;

	@Autowired

	private RelationshipRepository relationshipRepository;

	@Autowired

	private JdbcTemplate jdbcTemplate;

	public enum VocabularyTable {

		languages, countries, org_types, id_types, rel_types, simrel_types

	}

	@Transactional

	public String insertOrUpdateOrganization(final OrganizationView orgView, final String user, final boolean update) {

		if (update) {

			cleanOldRelations(orgView.getId());

		}

		final Organization org = new Organization(update ? orgView.getId() : null,

				orgView.getName(),

				StringUtils.isNotBlank(orgView.getType()) ? orgView.getType() : "UNKNOWN",

				orgView.getLat(), orgView.getLng(),

				orgView.getCity(), orgView.getCountry());

		final String orgId = organizationRepository.save(org).getId();

		makeNewRelations(orgView, orgId);

		updateHistoryFields(orgId, user, update);

		return orgId;

	}

	private void updateHistoryFields(final String id, final String user, final boolean update) {

		final OffsetDateTime now = OffsetDateTime.now();

		if (update) {

			organizationRepository.updateModificationDate(id, user, now);

		} else {

			organizationRepository.updateCreationDate(id, user, now);

			organizationRepository.updateModificationDate(id, user, now);

		}

	}

	private void makeNewRelations(final OrganizationView orgView, final String orgId) {

		orgView.getAcronyms().forEach(s -> acronymRepository.save(new Acronym(orgId, s)));

		orgView.getOtherNames().forEach(n -> otherNameRepository.save(new OtherName(orgId, n.getName(), n.getLang())));

		orgView.getOtherIdentifiers().forEach(id -> otherIdentifierRepository.save(new OtherIdentifier(orgId, id.getId(), id.getType())));

		orgView.getUrls().forEach(u -> urlRepository.save(new Url(orgId, u)));

	}

	private void cleanOldRelations(final String id) {

		acronymRepository.deleteByOrgId(id);

		otherNameRepository.deleteByOrgId(id);

		otherIdentifierRepository.deleteByOrgId(id);

		urlRepository.deleteByOrgId(id);

	}

	@Cacheable("vocs")

	public List<String> listValuesOfVocabularyTable(final VocabularyTable table) {

		return jdbcTemplate.queryForList("select val from " + table, String.class);

	}

	@Transactional

	public void addRelation(final String from, final String to, final RelationType type) {

		final Relationship r1 = new Relationship(from, to, type.toString());

		final Relationship r2 = new Relationship(to, from, type.getInverse().toString());

		relationshipRepository.save(r1);

		relationshipRepository.save(r2);

	}

	@Transactional

	public void deleteRelation(final String from, final String to, final RelationType type) {

		final Relationship r1 = new Relationship(from, to, type.toString());

		final Relationship r2 = new Relationship(to, from, type.getInverse().toString());

		relationshipRepository.delete(r1);

		relationshipRepository.delete(r2);

	}

}