D-Net

package eu.dnetlib.organizations.utils;

import java.time.OffsetDateTime;

import java.util.Arrays;

import java.util.List;

import java.util.stream.Collectors;

import javax.transaction.Transactional;

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 org.springframework.web.bind.annotation.RequestBody;

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

import eu.dnetlib.organizations.model.UserCountry;

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

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

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;

import eu.dnetlib.organizations.repository.UserCountryRepository;

import eu.dnetlib.organizations.repository.UserRepository;

@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 UserRepository userRepository;

	@Autowired

	private UserCountryRepository userCountryRepository;

	@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(),

				orgView.getType(),

				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);

	}

	@Cacheable("countries_for_user")

	public List<String> listCountriesForUser(final String name) {

		return jdbcTemplate.queryForList("select country from user_countries where email = ?", String.class, name);

	}

	@Transactional

	public void saveUser(@RequestBody final UserView userView) {

		final User user = userRepository.findById(userView.getEmail()).orElseThrow(() -> new RuntimeException("User not found"));

		user.setRole(userView.getRole());

		user.setValid(userView.isValid());

		userRepository.save(user);

		userCountryRepository.deleteByEmail(userView.getEmail());

		if (userView.getCountries() != null) {

			userCountryRepository

					.saveAll(Arrays.stream(userView.getCountries()).map(c -> new UserCountry(userView.getEmail(), c)).collect(Collectors.toList()));

		}

	}

	@Transactional

	public void deleteUser(final String email) {

		userCountryRepository.deleteByEmail(email);

		userRepository.deleteById(email);

	}

	@Transactional

	public void newUser(final String email, final List<String> countries) {

		final User user = new User();

		user.setEmail(email);

		user.setRole(OpenOrgsConstants.pendingRole);

		user.setValid(false);

		userRepository.save(user);

		if (countries != null) {

			userCountryRepository.saveAll(countries.stream().map(c -> new UserCountry(email, c)).collect(Collectors.toList()));

		}

	}

}