D-Net

package eu.dnetlib.organizations.utils;

import java.time.OffsetDateTime;

import java.util.UUID;

import javax.transaction.Transactional;

import org.apache.commons.codec.digest.DigestUtils;

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

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.Type;

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.TypeRepository;

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 TypeRepository typeRepository;

	@Autowired

	private UrlRepository urlRepository;

	@Transactional

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

		final String orgId = update ? org.getId() : "openorgs____::" + DigestUtils.md5Hex(UUID.randomUUID().toString());

		final OffsetDateTime now = OffsetDateTime.now();

		if (update) {

			acronymRepository.deleteByOrgId(orgId);

			otherNameRepository.deleteByOrgId(orgId);

			otherIdentifierRepository.deleteByOrgId(orgId);

			typeRepository.deleteByOrgId(orgId);

			urlRepository.deleteByOrgId(orgId);

		}

		organizationRepository.save(new Organization(orgId, org.getName(), org.getLat(), org.getLng(), org.getCity(), org.getCountry()));

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

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

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

		org.getTypes().forEach(t -> typeRepository.save(new Type(orgId, t)));

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

		if (update) {

			organizationRepository.updateModificationDate(orgId, user, now);

		} else {

			organizationRepository.updateCreationDate(orgId, user, now);

			organizationRepository.updateModificationDate(orgId, user, now);

		}

		return orgId;

	}

}