D-Net

import java.time.OffsetDateTime;

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

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

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

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;

	}

}

import java.security.Principal;

import eu.dnetlib.organizations.utils.DatabaseUtils;

	private DatabaseUtils databaseUtils;

	public List<String> save(@RequestBody final OrganizationView org, final Principal principal) {

		final String user = principal != null ? principal.getName() : "anonymous";

		final String orgId = databaseUtils.insertOrUpdateOrganization(org, user, StringUtils.isNotBlank(org.getId()));

INSERT INTO other_ids    (id, otherid, type)                         (SELECT 'openorgs____::'||md5(grid_id), external_id, external_id_type                                       FROM grid_external_ids ) ON CONFLICT DO NOTHING;

INSERT INTO relationships(id1, reltype, id2)                         (SELECT 'openorgs____::'||md5(grid_id), relationship_type, 'openorgs____::'||md5(related_grid_id)           FROM grid_relationships) ON CONFLICT DO NOTHING;

INSERT INTO types        (id, type)                                  (SELECT 'openorgs____::'||md5(grid_id), type                                                                FROM grid_types        ) ON CONFLICT DO NOTHING;

DROP TABLE IF EXISTS org_types;

DROP TABLE IF EXISTS id_types;

DROP TABLE IF EXISTS rel_types;

DROP TABLE IF EXISTS simrel_types;

CREATE TABLE org_types (val text PRIMARY KEY);

INSERT INTO org_types VALUES ('Archive'), ('Company'), ('Education'), ('Facility'), ('Government'), ('Healthcare'), ('Nonprofit'), ('Other');

CREATE TABLE id_types (val text PRIMARY KEY);

INSERT INTO id_types VALUES ('CNRS'), ('FundRef'), ('HESA'), ('ISNI'), ('OrgRef'), ('UCAS'), ('UKPRN'), ('Wikidata'), ('grid.ac');

CREATE TABLE rel_types (val text PRIMARY KEY);

INSERT INTO rel_types VALUES ('Child'), ('Parent'), ('Related'), ('Other');

CREATE TABLE simrel_types (val text PRIMARY KEY);

INSERT INTO simrel_types VALUES ('suggested'), ('is_similar'), ('is_different');

	type    text REFERENCES id_types(val),

	reltype text REFERENCES rel_types(val),

	type text REFERENCES org_types(val),

	reltype          text  NOT NULL DEFAULT 'suggested' REFERENCES simrel_types(val),

					<button type="submit" class="btn btn-primary" ng-click="save()">save</button>

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

orgsModule.controller('showMetadataCtrl', function ($scope, $http, $routeParams, $route) {

			alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

	$scope.save = function() {

		$http.defaults.headers.post["Content-Type"] = "application/json;charset=UTF-8";

		$http.post('/api/organizations/save?update=true', $scope.org).then(function successCallback(res) {

			alert('Organization updated !!!');

			$route.reload();

		}, function errorCallback(res) {

			alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		});

	}

			alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

			alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');

		alert('ERROR: ' + res.data.error + ' (' + res.data.message + ')');