D-Net

<?xml version="1.0" encoding="UTF-8"?>

<module org.jetbrains.idea.maven.project.MavenProjectsManager.isMavenModule="true" type="JAVA_MODULE" version="4">

  <component name="FacetManager">

    <facet type="Spring" name="Spring">

      <configuration />

    </facet>

  </component>

  <component name="NewModuleRootManager" LANGUAGE_LEVEL="JDK_1_8">

    <output url="file://$MODULE_DIR$/target/classes" />

    <output-test url="file://$MODULE_DIR$/target/test-classes" />

    <content url="file://$MODULE_DIR$">

      <sourceFolder url="file://$MODULE_DIR$/src/main/java" isTestSource="false" />

      <sourceFolder url="file://$MODULE_DIR$/src/test/java" isTestSource="true" />

      <sourceFolder url="file://$MODULE_DIR$/src/test/resources" type="java-test-resource" />

      <sourceFolder url="file://$MODULE_DIR$/src/main/resources" type="java-resource" />

      <excludeFolder url="file://$MODULE_DIR$/target" />

    </content>

    <orderEntry type="inheritedJdk" />

    <orderEntry type="sourceFolder" forTests="false" />

    <orderEntry type="library" name="Maven: eu.dnetlib:dnet-pace-core:2.5.1" level="project" />

    <orderEntry type="library" name="Maven: eu.dnetlib:cnr-rmi-api:2.6.2-SNAPSHOT" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-core:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: org.apache.ws.xmlschema:xmlschema-core:2.2.1" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-frontend-jaxws:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: xml-resolver:xml-resolver:1.2" level="project" />

    <orderEntry type="library" name="Maven: org.ow2.asm:asm:5.0.4" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-bindings-soap:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-wsdl:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: wsdl4j:wsdl4j:1.6.3" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-databinding-jaxb:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: com.sun.xml.bind:jaxb-impl:2.2.11" level="project" />

    <orderEntry type="library" name="Maven: com.sun.xml.bind:jaxb-core:2.2.11" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-bindings-xml:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-frontend-simple:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-ws-addr:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-ws-policy:3.1.5" level="project" />

    <orderEntry type="library" name="Maven: org.apache.neethi:neethi:3.0.3" level="project" />

    <orderEntry type="library" name="Maven: log4j:log4j:1.2.17" level="project" />

    <orderEntry type="library" name="Maven: org.apache.cxf:cxf-rt-transports-http:3.1.5" level="project" />

    <orderEntry type="module" module-name="cnr-service-common (1)" />

    <orderEntry type="library" name="Maven: org.quartz-scheduler:quartz:2.2.2" level="project" />

    <orderEntry type="library" name="Maven: c3p0:c3p0:0.9.1.1" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-tx:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-beans:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: eu.dnetlib:cnr-misc-utils:1.0.5-SNAPSHOT" level="project" />

    <orderEntry type="library" name="Maven: commons-lang:commons-lang:2.6" level="project" />

    <orderEntry type="library" name="Maven: jaxen:jaxen:1.1.6" level="project" />

    <orderEntry type="library" name="Maven: saxonica:saxon:9.1.0.8" level="project" />

    <orderEntry type="library" name="Maven: saxonica:saxon-dom:9.1.0.8" level="project" />

    <orderEntry type="library" name="Maven: jgrapht:jgrapht:0.7.2" level="project" />

    <orderEntry type="library" name="Maven: net.sf.ehcache:ehcache:2.10.3" level="project" />

    <orderEntry type="library" name="Maven: eu.dnetlib:cnr-service-utils:1.0.3-SNAPSHOT" level="project" />

    <orderEntry type="library" name="Maven: apache:oro:2.0.8" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-context:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: eu.dnetlib:cnr-spring-utils:1.0.2-SNAPSHOT" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-aop:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: jparsec:jparsec:2.0" level="project" />

    <orderEntry type="library" name="Maven: runcc:runcc:0.7" level="project" />

    <orderEntry type="module" module-name="dnet-openaireplus-mapping-utils" />

    <orderEntry type="library" name="Maven: commons-codec:commons-codec:1.10" level="project" />

    <orderEntry type="library" name="Maven: dom4j:dom4j:1.6.1" level="project" />

    <orderEntry type="library" name="Maven: eu.dnetlib:dnet-openaire-data-protos:3.8.10" level="project" />

    <orderEntry type="library" name="Maven: com.google.protobuf:protobuf-java:2.4.1" level="project" />

    <orderEntry type="module" module-name="dnet-pace-core" />

    <orderEntry type="library" name="Maven: edu.cmu:secondstring:1.0.0" level="project" />

    <orderEntry type="library" name="Maven: commons-collections:commons-collections:3.2.2" level="project" />

    <orderEntry type="library" name="Maven: com.googlecode.protobuf-java-format:protobuf-java-format:1.2" level="project" />

    <orderEntry type="module" module-name="dnet-objectstore-rmi" />

    <orderEntry type="library" name="Maven: org.apache.solr:solr-solrj:7.1.0" level="project" />

    <orderEntry type="library" name="Maven: org.apache.commons:commons-math3:3.6.1" level="project" />

    <orderEntry type="library" name="Maven: org.apache.httpcomponents:httpclient:4.5.3" level="project" />

    <orderEntry type="library" name="Maven: org.apache.httpcomponents:httpcore:4.4.6" level="project" />

    <orderEntry type="library" name="Maven: org.apache.httpcomponents:httpmime:4.5.3" level="project" />

    <orderEntry type="library" name="Maven: org.apache.zookeeper:zookeeper:3.4.10" level="project" />

    <orderEntry type="library" name="Maven: org.codehaus.woodstox:stax2-api:3.1.4" level="project" />

    <orderEntry type="library" name="Maven: org.codehaus.woodstox:woodstox-core-asl:4.4.1" level="project" />

    <orderEntry type="library" name="Maven: org.noggit:noggit:0.8" level="project" />

    <orderEntry type="library" name="Maven: org.slf4j:jcl-over-slf4j:1.7.24" level="project" />

    <orderEntry type="library" name="Maven: org.slf4j:slf4j-api:1.7.24" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-web:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-autoconfigure:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-logging:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: ch.qos.logback:logback-classic:1.1.11" level="project" />

    <orderEntry type="library" name="Maven: ch.qos.logback:logback-core:1.1.11" level="project" />

    <orderEntry type="library" name="Maven: org.slf4j:jul-to-slf4j:1.7.24" level="project" />

    <orderEntry type="library" name="Maven: org.slf4j:log4j-over-slf4j:1.7.24" level="project" />

    <orderEntry type="library" scope="RUNTIME" name="Maven: org.yaml:snakeyaml:1.17" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-tomcat:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.apache.tomcat.embed:tomcat-embed-core:8.5.11" level="project" />

    <orderEntry type="library" name="Maven: org.apache.tomcat.embed:tomcat-embed-el:8.5.11" level="project" />

    <orderEntry type="library" name="Maven: org.apache.tomcat.embed:tomcat-embed-websocket:8.5.11" level="project" />

    <orderEntry type="library" name="Maven: org.hibernate:hibernate-validator:5.3.4.Final" level="project" />

    <orderEntry type="library" name="Maven: javax.validation:validation-api:1.1.0.Final" level="project" />

    <orderEntry type="library" name="Maven: org.jboss.logging:jboss-logging:3.3.0.Final" level="project" />

    <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-databind:2.8.7" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-web:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-webmvc:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-expression:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-jdbc:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.apache.tomcat:tomcat-jdbc:8.5.11" level="project" />

    <orderEntry type="library" name="Maven: org.apache.tomcat:tomcat-juli:8.5.11" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-jdbc:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-data-jpa:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-starter-aop:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.aspectj:aspectjweaver:1.8.9" level="project" />

    <orderEntry type="library" name="Maven: org.hibernate:hibernate-core:5.0.12.Final" level="project" />

    <orderEntry type="library" name="Maven: org.hibernate.javax.persistence:hibernate-jpa-2.1-api:1.0.0.Final" level="project" />

    <orderEntry type="library" name="Maven: org.javassist:javassist:3.21.0-GA" level="project" />

    <orderEntry type="library" name="Maven: org.jboss:jandex:2.0.0.Final" level="project" />

    <orderEntry type="library" name="Maven: org.hibernate.common:hibernate-commons-annotations:5.0.1.Final" level="project" />

    <orderEntry type="library" name="Maven: org.hibernate:hibernate-entitymanager:5.0.12.Final" level="project" />

    <orderEntry type="library" name="Maven: javax.transaction:javax.transaction-api:1.2" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.data:spring-data-jpa:1.11.1.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.data:spring-data-commons:1.13.1.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-orm:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-aspects:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.postgresql:postgresql:42.0.0" level="project" />

    <orderEntry type="library" name="Maven: org.apache.commons:commons-dbcp2:2.1" level="project" />

    <orderEntry type="library" name="Maven: org.apache.commons:commons-pool2:2.4.2" level="project" />

    <orderEntry type="library" name="Maven: commons-logging:commons-logging:1.2" level="project" />

    <orderEntry type="library" name="Maven: org.antlr:stringtemplate:3.2.1" level="project" />

    <orderEntry type="library" name="Maven: antlr:antlr:2.7.7" level="project" />

    <orderEntry type="library" name="Maven: org.apache.commons:commons-lang3:3.5" level="project" />

    <orderEntry type="library" name="Maven: commons-io:commons-io:2.5" level="project" />

    <orderEntry type="library" name="Maven: com.google.guava:guava:23.3-jre" level="project" />

    <orderEntry type="library" name="Maven: com.google.code.findbugs:jsr305:1.3.9" level="project" />

    <orderEntry type="library" name="Maven: com.google.errorprone:error_prone_annotations:2.0.18" level="project" />

    <orderEntry type="library" name="Maven: com.google.j2objc:j2objc-annotations:1.1" level="project" />

    <orderEntry type="library" name="Maven: org.codehaus.mojo:animal-sniffer-annotations:1.14" level="project" />

    <orderEntry type="library" name="Maven: net.sf.supercsv:super-csv:2.4.0" level="project" />

    <orderEntry type="library" name="Maven: com.google.code.gson:gson:2.8.0" level="project" />

    <orderEntry type="library" name="Maven: com.fasterxml.jackson.datatype:jackson-datatype-joda:2.6.6" level="project" />

    <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-annotations:2.8.0" level="project" />

    <orderEntry type="library" name="Maven: com.fasterxml.jackson.core:jackson-core:2.8.7" level="project" />

    <orderEntry type="library" name="Maven: joda-time:joda-time:2.8.2" level="project" />

    <orderEntry type="library" name="Maven: org.mongodb:mongo-java-driver:3.4.2" level="project" />

    <orderEntry type="library" name="Maven: io.springfox:springfox-swagger2:2.7.0" level="project" />

    <orderEntry type="library" name="Maven: io.swagger:swagger-annotations:1.5.13" level="project" />

    <orderEntry type="library" name="Maven: io.swagger:swagger-models:1.5.13" level="project" />

    <orderEntry type="library" name="Maven: io.springfox:springfox-spi:2.7.0" level="project" />

    <orderEntry type="library" name="Maven: io.springfox:springfox-core:2.7.0" level="project" />

    <orderEntry type="library" name="Maven: net.bytebuddy:byte-buddy:1.6.14" level="project" />

    <orderEntry type="library" name="Maven: io.springfox:springfox-schema:2.7.0" level="project" />

    <orderEntry type="library" name="Maven: io.springfox:springfox-swagger-common:2.7.0" level="project" />

    <orderEntry type="library" name="Maven: io.springfox:springfox-spring-web:2.7.0" level="project" />

    <orderEntry type="library" name="Maven: org.reflections:reflections:0.9.11" level="project" />

    <orderEntry type="library" name="Maven: com.fasterxml:classmate:1.3.3" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.plugin:spring-plugin-core:1.2.0.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.plugin:spring-plugin-metadata:1.2.0.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.mapstruct:mapstruct:1.1.0.Final" level="project" />

    <orderEntry type="library" name="Maven: io.springfox:springfox-swagger-ui:2.7.0" level="project" />

    <orderEntry type="library" name="Maven: io.prometheus:simpleclient_spring_boot:0.0.25" level="project" />

    <orderEntry type="library" name="Maven: io.prometheus:simpleclient:0.0.25" level="project" />

    <orderEntry type="library" name="Maven: io.prometheus:simpleclient_common:0.0.25" level="project" />

    <orderEntry type="library" name="Maven: io.prometheus:simpleclient_spring_web:0.0.25" level="project" />

    <orderEntry type="library" name="Maven: org.springframework.boot:spring-boot-actuator:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: io.prometheus:simpleclient_hotspot:0.0.25" level="project" />

    <orderEntry type="library" name="Maven: io.prometheus:simpleclient_servlet:0.0.25" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.springframework.boot:spring-boot-starter-test:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.springframework.boot:spring-boot-test:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.springframework.boot:spring-boot-test-autoconfigure:1.5.2.RELEASE" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: com.jayway.jsonpath:json-path:2.2.0" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: net.minidev:json-smart:2.2.1" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: net.minidev:accessors-smart:1.1" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: junit:junit:4.12" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.assertj:assertj-core:2.6.0" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.mockito:mockito-core:1.10.19" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.objenesis:objenesis:2.1" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.hamcrest:hamcrest-core:1.3" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.hamcrest:hamcrest-library:1.3" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: org.skyscreamer:jsonassert:1.4.0" level="project" />

    <orderEntry type="library" scope="TEST" name="Maven: com.vaadin.external.google:android-json:0.0.20131108.vaadin1" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-core:4.3.7.RELEASE" level="project" />

    <orderEntry type="library" name="Maven: org.springframework:spring-test:4.3.7.RELEASE" level="project" />

  </component>

</module>

{"type_source": "SVN", "goal": "package -U source:jar", 

"url": "http://svn-public.driver.research-infrastructures.eu/driver/dnet45/modules/dnet-openaire-exporter/trunk/", "deploy_repository": "dnet45-snapshots", "version": "4", "mail": "sandro.labruzzo@isti.cnr.it,michele.artini@isti.cnr.it, claudio.atzori@isti.cnr.it, alessia.bardi@isti.cnr.it",

"deploy_repository_url": "http://maven.research-infrastructures.eu/nexus/content/repositories/dnet45-snapshots", "name": "dnet-openaire-exporter"}

package eu.dnetlib.openaire.exporter.model.project;

import java.io.IOException;

import org.junit.Test;

/**

 * Created by claudio on 05/07/2017.

 */

public class ProjectDetailsTest {

	@Test

	public void testCSV() throws IOException {

		final ProjectDetails p = ProjectDetails.fromCSV(

				"arc_________::ANZCCART,,ANZCCART,{},\"[\"\"\\u003cfundingtree\\u003e\\n      \\u003cfunder\\u003e\\n         \\u003cid\\u003earc_________::ARC\\u003c/id\\u003e\\n         \\u003cshortname\\u003eARC\\u003c/shortname\\u003e\\n         \\u003cname\\u003eAustralian Research Council (ARC)\\u003c/name\\u003e\\n         \\u003cjurisdiction\\u003eAU\\u003c/jurisdiction\\u003e\\n      \\u003c/funder\\u003e\\n      \\u003cfunding_level_0\\u003e\\n         \\u003cid\\u003earc_________::ARC::Special Research initiative (Australian and New Zealand Council for the Care of Animals in Research and Teaching)\\u003c/id\\u003e\\n         \\u003cname\\u003eSpecial Research initiative (Australian and New Zealand Council for the Care of Animals in Research and Teaching)\\u003c/name\\u003e\\n         \\u003cdescription\\u003eSpecial Research initiative (Australian and New Zealand Council for the Care of Animals in Research and Teaching)\\u003c/description\\u003e\\n         \\u003cparent/\\u003e\\n         \\u003cclass\\u003earc:fundingStream\\u003c/class\\u003e\\n      \\u003c/funding_level_0\\u003e\\n   \\u003c/fundingtree\\u003e\"\"]\"");

		System.out.println(p.asJson());

		System.out.println(p.asCSV());

	}

}

package eu.dnetlib.openaire.exporter.project;

import eu.dnetlib.openaire.exporter.project.ProjectQueryParams;

import org.junit.Before;

import org.junit.Test;

import static org.junit.Assert.assertEquals;

public class ProjectQueryParamsTest {

	private ProjectQueryParams queryParams;

	@Before

	public void setUp() throws Exception {

		queryParams = new ProjectQueryParams();

	}

	@Test

	public void testVerifyParamWhiteSpace() {

		queryParams.verifyParam("Discovery Projects");

	}

	@Test

	public void testVerifyParamPercentage() {

		queryParams.verifyParam("Discovery%20Projects");

	}

	@Test

	public void testVerifyDateParam(){

		String correctDate = "2012-03-04";

		assertEquals(correctDate, queryParams.verifyDateParam(correctDate));

	}

	@Test(expected=IllegalArgumentException.class)

	public void testVerifyDateParamException(){

		String wrongDate = "12-12-12";

		queryParams.verifyDateParam(wrongDate);

	}

}

package eu.dnetlib.openaire.exporter.project;

import java.io.IOException;

import org.antlr.stringtemplate.StringTemplate;

import org.apache.commons.io.IOUtils;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.junit.Before;

import org.junit.Ignore;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.core.io.ClassPathResource;

import org.springframework.core.io.Resource;

import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import static org.junit.Assert.assertEquals;

@Ignore

@SpringBootTest

@RunWith(SpringJUnit4ClassRunner.class)

public class ProjectsControllerTest {

	private static final Log log = LogFactory.getLog(ProjectsControllerTest.class);

	private String queryTemplate = "/eu/dnetlib/openaire/exporter/sql/projects_fundings.sql.st";

	private Resource expectedQueryTemplate = new ClassPathResource("/eu/dnetlib/openaire/exporter/sql/expected_projects_fundings.sql.st");

	private ProjectsController controller;

	private ProjectQueryParams params;

	@Before

	public void setup() {

		controller = new ProjectsController();

		Resource template = new ClassPathResource(queryTemplate);

		//TODO reimplement bean injection for testing

		//controller.setProjectsFundingQueryTemplate(template);

		params = new ProjectQueryParams();

	}

	@Test

	public void testObtainFP7Query() throws IllegalArgumentException, IOException {

		params.setFundingProgramme("FP7");

		params.setFundingPath(null);

		String res = controller.obtainQuery(params);

		final StringTemplate st = new StringTemplate(IOUtils.toString(expectedQueryTemplate.getInputStream(),  ProjectsController.UTF8));

		st.setAttribute("fundingprefix", "ec__________::EC::FP7");

		log.debug(res);

		log.debug(st);

		assertEquals(st.toString(), res);

	}

	@Test

	public void testObtainFP7QuerySP1() throws IllegalArgumentException, IOException {

		params.setFundingProgramme("FP7");

		params.setFundingPath("SP1");

		String res = controller.obtainQuery(params);

		final StringTemplate st = new StringTemplate(IOUtils.toString(expectedQueryTemplate.getInputStream(),  ProjectsController.UTF8));

		st.setAttribute("fundingprefix", "ec__________::EC::FP7::SP1");

		log.debug(res);

		assertEquals(st.toString(), res);

	}

	@Test

	public void testObtainFP7QueryHealth() throws IllegalArgumentException, IOException {

		params.setFundingProgramme("FP7");

		params.setFundingPath("SP1::HEALTH");

		String res = controller.obtainQuery(params);

		final StringTemplate st = new StringTemplate(IOUtils.toString(expectedQueryTemplate.getInputStream(),  ProjectsController.UTF8));

		st.setAttribute("fundingprefix", "ec__________::EC::FP7::SP1::HEALTH");

		log.debug(res);

		assertEquals(st.toString(), res);

	}

	@Test

	public void testObtainFP7QueryHealth2() throws IllegalArgumentException, IOException {

		params.setFundingProgramme("FP7");

		params.setFundingPath("%::HEALTH");

		String res = controller.obtainQuery(params);

		final StringTemplate st = new StringTemplate(IOUtils.toString(expectedQueryTemplate.getInputStream(),  ProjectsController.UTF8));

		st.setAttribute("fundingprefix", "ec__________::EC::FP7::%::HEALTH");

		log.debug(res);

		assertEquals(st.toString(), res);

	}

	@Test

	public void testObtainWellcomeTrustQuery() throws IllegalArgumentException, IOException {

		params.setFundingProgramme("WT");

		params.setFundingPath(null);

		String res = controller.obtainQuery(params);

		final StringTemplate st = new StringTemplate(IOUtils.toString(expectedQueryTemplate.getInputStream(),  ProjectsController.UTF8));

		st.setAttribute("fundingprefix", "wt__________::WT");

		log.debug(res);

		assertEquals(st.toString(), res);

	}

	@Test

	public void testObtainFCTQuery() throws IllegalArgumentException, IOException {

		params.setFundingProgramme("FCT");

		params.setFundingPath(null);

		String res = controller.obtainQuery(params);

		final StringTemplate st = new StringTemplate(IOUtils.toString(expectedQueryTemplate.getInputStream(),  ProjectsController.UTF8));

		st.setAttribute("fundingprefix", "fct_________::FCT");

		log.debug(res);

		assertEquals(st.toString(), res);

	}

	@Test

	public void testQueryWithDateParams() throws IllegalArgumentException, IOException {

		params.setFundingProgramme("WT");

		params.setFundingPath(null);

		params.setStartFrom("2015-05-04");

		String res = controller.obtainQuery(params);

		log.debug(res);

		final StringTemplate st = new StringTemplate(IOUtils.toString(expectedQueryTemplate.getInputStream(),  ProjectsController.UTF8));

		st.setAttribute("fundingprefix", "wt__________::WT");

		String q = st.toString() + " AND startdate >= '2015-05-04'";

		assertEquals(q, res);

	}

	@Test

	public void testObtainSNSFQuery() throws IllegalArgumentException, IOException {

		params.setFundingProgramme("SNSF");

		params.setFundingPath(null);

		String res = controller.obtainQuery(params);

		final StringTemplate st = new StringTemplate(IOUtils.toString(expectedQueryTemplate.getInputStream(),  ProjectsController.UTF8));

		st.setAttribute("fundingprefix", "snsf________::SNSF");

		log.debug(res);

		assertEquals(st.toString(), res);

	}

}

<?xml version="1.0" encoding="UTF-8"?>

<ROW>

	<FIELD name="funder">FCT</FIELD>

	<FIELD name="jurisdiction">PT</FIELD>

	<FIELD name="end_date">2003-10-31</FIELD>

	<FIELD name="grant_agreement_number">32639</FIELD>

	<FIELD name="title">Social Classes and «lifestyles» in the city of Oporto</FIELD>

	<FIELD name="fundingpathid">fct_________::FCT::Orçamento de Funcionamento/POSC</FIELD>

	<FIELD name="acronym">PTDC/FIL-FIL/109889/2009</FIELD>

	<FIELD name="start_date">2000-11-01</FIELD>

	<FIELD name="description">description of the funding path</FIELD>

</ROW> 

<?xml version="1.0" encoding="UTF-8"?>

<ROW>

	<FIELD name="funder">EC</FIELD>

	<FIELD name="jurisdiction">EU</FIELD>

	<FIELD name="end_date">2012-07-31</FIELD>

	<FIELD name="grant_agreement_number">255646</FIELD>

	<FIELD name="title">Semiconductor lasers for generation of non-diffracting (Bessel) beams.</FIELD>

	<FIELD name="fundingpathid">ec__________::EC::FP7::SP3::PEOPLE</FIELD>

	<FIELD name="acronym">SENDBEAMS</FIELD>

	<FIELD name="start_date">2010-08-01</FIELD>

	<FIELD name="description">description of the funding path</FIELD>

</ROW> 

SELECT

	funder,

	jurisdiction,

	fundingpathid,

	acronym,

	title,

	code,

	startdate,

	enddate

FROM projects_api

WHERE fundingpathid like '$fundingprefix$%'

<?xml version="1.0" encoding="UTF-8"?>

<ROW>

	<FIELD name="funder">SFI</FIELD>

	<FIELD name="end_date">2016-08-31</FIELD>

	<FIELD name="grant_agreement_number">14/ADV/RC3022</FIELD>

	<FIELD name="title">Dr. Vesna Jaksic</FIELD>

	<FIELD name="acronym" isNull="true"/>

	<FIELD name="fundingpathid">sfi_________::SFI::Advance Award Programme</FIELD>

	<FIELD name="jurisdiction" isNull="true"/>

	<FIELD name="start_date">2014-09-01</FIELD>

</ROW>

<?xml version="1.0" encoding="UTF-8"?>

<ROW>

	<FIELD name="funder">MSES</FIELD>

	<FIELD name="end_date">2009-12-31</FIELD>

	<FIELD name="grant_agreement_number">001-0000000-3177</FIELD>

	<FIELD name="title">Residence time of bacteria Escherichia coli in seawater and marine organisms</FIELD>

	<FIELD name="acronym" isNull="true"/>

	<FIELD name="fundingpathid">irb_hr______::MSES::fundingStream</FIELD>

	<FIELD name="jurisdiction">HR</FIELD>

	<FIELD name="start_date">2007-01-01</FIELD>

</ROW>

<ROW>

	<FIELD name="funder">WT</FIELD>

	<FIELD name="end_date">2013-07-29</FIELD>

	<FIELD name="grant_agreement_number">098241</FIELD>

	<FIELD name="title">EYEDIO DIGI - DEVELOPMENT OF AN INNOVATIVE, AFFORDABLE, EASY TO USE, HANDHELD RETINAL IMAGING PRODUCT FOR THE DIAGNOSIS OF DIABETIC RETINOPATHY.</FIELD>

	<FIELD name="acronym"></FIELD>

	<FIELD name="fundingpathid">wt__________::WT::Immunology and Infectious Disease</FIELD>

	<FIELD name="start_date">2012-01-30</FIELD>

	<FIELD name="jurisdiction"/>

	<FIELD name="description">description of the funding path</FIELD>

</ROW> 

<?xml version="1.0" encoding="UTF-8"?>

<configuration>

	<include resource="org/springframework/boot/logging/logback/base.xml"/>

	<logger name="org.springframework" level="OFF">

		<appender-ref ref="CONSOLE" />

	</logger>

	<logger name="root" level="OFF">

		<appender-ref ref="CONSOLE" />

	</logger>

	<logger name="eu.dnetlib" level="INFO">

		<appender-ref ref="CONSOLE" />

	</logger>

	<logger name="eu.dnetlib.openaire.exporter" level="INFO">

		<appender-ref ref="CONSOLE" />

	</logger>

</configuration>

package eu.dnetlib.swagger.configuration;

import eu.dnetlib.OpenaireExporterConfig;

import eu.dnetlib.OpenaireExporterConfig.Swagger;

import eu.dnetlib.common.rmi.DNetRestDocumentation;

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

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import springfox.documentation.builders.ApiInfoBuilder;

import springfox.documentation.builders.RequestHandlerSelectors;

import springfox.documentation.service.ApiInfo;

import springfox.documentation.service.Contact;

import springfox.documentation.spi.DocumentationType;

import springfox.documentation.spring.web.plugins.Docket;

import springfox.documentation.swagger2.annotations.EnableSwagger2;

@Configuration

@EnableSwagger2

public class SwaggerDocumentationConfig {

	@Autowired

	private OpenaireExporterConfig config;

    @Bean

    public Docket customImplementation() {

        return new Docket(DocumentationType.SWAGGER_2)

                .select()

		            .apis(RequestHandlerSelectors.withClassAnnotation(DNetRestDocumentation.class))

                    .build()

                .directModelSubstitute(org.joda.time.LocalDate.class, java.sql.Date.class)

                .directModelSubstitute(org.joda.time.DateTime.class, java.util.Date.class)

                .apiInfo(apiInfo());

    }

	private ApiInfo apiInfo() {

		final Swagger swag = config.getSwagger();

		return new ApiInfoBuilder()

				.title(swag.getApiTitle())

				.description(swag.getApiDescription())

				.license(swag.getApiLicense())

				.licenseUrl(swag.getApiLicenseUrl())

				.termsOfServiceUrl("")

				.version("1.0.0")

				.contact(new Contact(

						swag.getApiContactName(),

						swag.getApiContactUrl(),

						swag.getApiContactEmail()))

				.build();

	}

}

package eu.dnetlib.swagger.configuration;

import java.text.FieldPosition;

import java.util.Date;

import com.fasterxml.jackson.databind.util.ISO8601DateFormat;

import com.fasterxml.jackson.databind.util.ISO8601Utils;

public class RFC3339DateFormat extends ISO8601DateFormat {

  // Same as ISO8601DateFormat but serializing milliseconds.

  @Override

  public StringBuffer format(Date date, StringBuffer toAppendTo, FieldPosition fieldPosition) {

    String value = ISO8601Utils.format(date, true);

    toAppendTo.append(value);

    return toAppendTo;

  }

}

package eu.dnetlib;

import java.util.Iterator;

import java.util.Spliterator;

import java.util.Spliterators;

import java.util.stream.Stream;

import java.util.stream.StreamSupport;

/**

 * Created by claudio on 13/04/2017.

 */

public class Utils {

	public static <T> Stream<T> stream(Iterator<T> iterator) {

		return StreamSupport.stream(Spliterators.spliteratorUnknownSize(iterator, Spliterator.ORDERED), false);

	}

}

package eu.dnetlib;

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

import org.springframework.boot.context.properties.ConfigurationProperties;

import org.springframework.core.io.ClassPathResource;

import org.springframework.core.io.Resource;

import org.springframework.stereotype.Component;

/**

 * Created by Alessia Bardi on 31/03/17.

 *

 * @author Alessia Bardi, Claudio Atzori

 */

@Component

@ConfigurationProperties(prefix = "openaire.exporter")

public class OpenaireExporterConfig {

	// ISLOOKUP

	private ClassPathResource findSolrIndexUrl;

	private ClassPathResource findIndexDsInfo;

	private ClassPathResource findObjectStore;

	private String isLookupUrl;

	private String objectStoreServiceUrl;

	private int requestWorkers = 100;

	private int requestTimeout = 10;

	private Datasource datasource;

	private Project project;

	private Jdbc jdbc;

	private Swagger swagger;

	private Vocabularies vocabularies;

	public static class Datasource {

		// MONGODB

		private String mongoHost;

		private int mongoPort;

		private String mongoCollectionName;

		private String mongoDbName;

		private int mongoConnectionsPerHost;

		private int mongoQueryLimit;

		public String getMongoHost() {

			return mongoHost;

		}

		public void setMongoHost(final String mongoHost) {

			this.mongoHost = mongoHost;

		}

		public int getMongoPort() {

			return mongoPort;

		}

		public void setMongoPort(final int mongoPort) {

			this.mongoPort = mongoPort;

		}

		public String getMongoCollectionName() {

			return mongoCollectionName;

		}

		public void setMongoCollectionName(final String mongoCollectionName) {

			this.mongoCollectionName = mongoCollectionName;

		}

		public String getMongoDbName() {

			return mongoDbName;

		}

		public void setMongoDbName(final String mongoDbName) {

			this.mongoDbName = mongoDbName;

		}

		public int getMongoConnectionsPerHost() {

			return mongoConnectionsPerHost;

		}

		public void setMongoConnectionsPerHost(final int mongoConnectionsPerHost) {

			this.mongoConnectionsPerHost = mongoConnectionsPerHost;

		}

		public int getMongoQueryLimit() {

			return mongoQueryLimit;

		}

		public void setMongoQueryLimit(final int mongoQueryLimit) {

			this.mongoQueryLimit = mongoQueryLimit;

		}

	}

	public static class Project {

		private int flushSize;

		private String tsvFields;

		private Resource projectsFundingQueryTemplate;

		private Resource dspaceTemplate;

		private Resource dspaceHeadTemplate;

		private Resource dspaceTailTemplate;

		private Resource eprintsTemplate;

		public int getFlushSize() {

			return flushSize;

		}

		public void setFlushSize(final int flushSize) {

			this.flushSize = flushSize;

		}

		public String getTsvFields() {

			return tsvFields;

		}

		public void setTsvFields(final String tsvFields) {

			this.tsvFields = tsvFields;

		}

		public Resource getProjectsFundingQueryTemplate() {

			return projectsFundingQueryTemplate;

		}

		public void setProjectsFundingQueryTemplate(final Resource projectsFundingQueryTemplate) {

			this.projectsFundingQueryTemplate = projectsFundingQueryTemplate;

		}

		public Resource getDspaceTemplate() {

			return dspaceTemplate;

		}

		public void setDspaceTemplate(final Resource dspaceTemplate) {

			this.dspaceTemplate = dspaceTemplate;

		}

		public Resource getDspaceHeadTemplate() {

			return dspaceHeadTemplate;

		}

		public void setDspaceHeadTemplate(final Resource dspaceHeadTemplate) {

			this.dspaceHeadTemplate = dspaceHeadTemplate;

		}

		public Resource getDspaceTailTemplate() {

			return dspaceTailTemplate;

		}

		public void setDspaceTailTemplate(final Resource dspaceTailTemplate) {

			this.dspaceTailTemplate = dspaceTailTemplate;

		}

		public Resource getEprintsTemplate() {

			return eprintsTemplate;

		}

		public void setEprintsTemplate(final Resource eprintsTemplate) {

			this.eprintsTemplate = eprintsTemplate;

		}

	}

	public static class Jdbc {

		// JDBC

		@Value("${spring.datasource.driverClassName}")

		private String driverClassName;

		private String url;

		private String user;

		private String pwd;

		private int minIdle;

		private int maxidle;

		private int maxRows;

		public String getDriverClassName() {

			return driverClassName;

		}

		public String getUrl() {

			return url;

		}

		public void setUrl(final String url) {

			this.url = url;

		}

		public String getUser() {

			return user;

		}

		public void setUser(final String user) {

			this.user = user;

		}

		public String getPwd() {

			return pwd;

		}

		public void setPwd(final String pwd) {

			this.pwd = pwd;

		}

		public int getMinIdle() {

			return minIdle;

		}

		public void setMinIdle(final int minIdle) {

			this.minIdle = minIdle;

		}

		public int getMaxidle() {

			return maxidle;

		}

		public void setMaxidle(final int maxidle) {

			this.maxidle = maxidle;

		}

		public int getMaxRows() {

			return maxRows;

		}

		public void setMaxRows(final int maxRows) {

			this.maxRows = maxRows;

		}

	}

	public static class Swagger {

		private String apiTitle;

		private String apiDescription;

		private String apiLicense;

		private String apiLicenseUrl;

		private String apiContactName;

		private String apiContactUrl;

		private String apiContactEmail;

		public String getApiTitle() {

			return apiTitle;

		}

		public void setApiTitle(final String apiTitle) {

			this.apiTitle = apiTitle;

		}

		public String getApiDescription() {

			return apiDescription;

		}

		public void setApiDescription(final String apiDescription) {

			this.apiDescription = apiDescription;

		}

		public String getApiLicense() {

			return apiLicense;

		}

		public void setApiLicense(final String apiLicense) {

			this.apiLicense = apiLicense;

		}

		public String getApiLicenseUrl() {

			return apiLicenseUrl;

		}

		public void setApiLicenseUrl(final String apiLicenseUrl) {

			this.apiLicenseUrl = apiLicenseUrl;

		}

		public String getApiContactName() {

			return apiContactName;

		}

		public void setApiContactName(final String apiContactName) {

			this.apiContactName = apiContactName;

		}

		public String getApiContactUrl() {

			return apiContactUrl;

		}

		public void setApiContactUrl(final String apiContactUrl) {

			this.apiContactUrl = apiContactUrl;

		}

		public String getApiContactEmail() {

			return apiContactEmail;

		}

		public void setApiContactEmail(final String apiContactEmail) {

			this.apiContactEmail = apiContactEmail;

		}

	}

	public static class Vocabularies {

		private String baseUrl;

		private String countriesEndpoint;

		private String datasourceTypologiesEndpoint;

		public String getCountriesEndpoint() {

			return countriesEndpoint;

		}

		public void setCountriesEndpoint(final String countriesEndpoint) {

			this.countriesEndpoint = countriesEndpoint;

		}

		public String getBaseUrl() {

			return baseUrl;

		}

		public void setBaseUrl(final String baseUrl) {

			this.baseUrl = baseUrl;

		}

		public String getDatasourceTypologiesEndpoint() {

			return datasourceTypologiesEndpoint;

		}

		public void setDatasourceTypologiesEndpoint(final String datasourceTypologiesEndpoint) {

			this.datasourceTypologiesEndpoint = datasourceTypologiesEndpoint;

		}

	}

	public ClassPathResource getFindSolrIndexUrl() {

		return findSolrIndexUrl;

	}

	public void setFindSolrIndexUrl(final ClassPathResource findSolrIndexUrl) {

		this.findSolrIndexUrl = findSolrIndexUrl;

	}

	public ClassPathResource getFindIndexDsInfo() {

		return findIndexDsInfo;

	}

	public ClassPathResource getFindObjectStore() {

		return findObjectStore;

	}

	public void setFindObjectStore(final ClassPathResource findObjectStore) {

		this.findObjectStore = findObjectStore;

	}

	public void setFindIndexDsInfo(final ClassPathResource findIndexDsInfo) {

		this.findIndexDsInfo = findIndexDsInfo;

	}

	public String getIsLookupUrl() {

		return isLookupUrl;

	}

	public void setIsLookupUrl(final String isLookupUrl) {

		this.isLookupUrl = isLookupUrl;

	}

	public String getObjectStoreServiceUrl() {

		return objectStoreServiceUrl;

	}

	public void setObjectStoreServiceUrl(final String objectStoreServiceUrl) {

		this.objectStoreServiceUrl = objectStoreServiceUrl;

	}

	public int getRequestWorkers() {

		return requestWorkers;

	}

	public void setRequestWorkers(final int requestWorkers) {

		this.requestWorkers = requestWorkers;

	}

	public int getRequestTimeout() {

		return requestTimeout;

	}

	public void setRequestTimeout(final int requestTimeout) {

		this.requestTimeout = requestTimeout;

	}

	public Datasource getDatasource() {

		return datasource;

	}

	public void setDatasource(final Datasource datasource) {

		this.datasource = datasource;

	}

	public Project getProject() {

		return project;

	}

	public void setProject(final Project project) {

		this.project = project;

	}

	public Jdbc getJdbc() {

		return jdbc;

	}

	public void setJdbc(final Jdbc jdbc) {

		this.jdbc = jdbc;

	}

	public Swagger getSwagger() {

		return swagger;

	}

	public void setSwagger(final Swagger swagger) {

		this.swagger = swagger;

	}

	public Vocabularies getVocabularies() {

		return vocabularies;

	}

	public void setVocabularies(final Vocabularies vocabularies) {

		this.vocabularies = vocabularies;

	}

}

package eu.dnetlib.openaire.exporter.aop;

import io.prometheus.client.Gauge;

import org.aspectj.lang.ProceedingJoinPoint;

import org.aspectj.lang.annotation.Around;

import org.aspectj.lang.annotation.Aspect;

import org.springframework.stereotype.Component;

/**

 * Created by claudio on 25/07/2017.

 */

@Aspect

@Component

public class DatasourceApiProfiler {

	private static final Gauge datasourceByIdGauge = Gauge.build()

			.name("DSM_getDsById_requests_latency_seconds")

			.help("Request latency in seconds for invocations of the method eu.dnetlib.openaire.exporter.datasource.DatasourcesApiController.getDs()")

			.register();

	@Around("execution(* eu.dnetlib.openaire.exporter.datasource.DatasourcesApiController.getDs(..))")

	public Object logTimeGetDsById(final ProceedingJoinPoint joinPoint) throws Throwable {

		final Gauge.Timer requestTimer = datasourceByIdGauge.startTimer();

		try {

			return joinPoint.proceed();

		} finally {

			requestTimer.setDuration();

		}

	}

	private static final Gauge datasourceByName = Gauge.build()

			.name("DSM_searchDsByName_requests_latency_seconds")

			.help("Request latency in seconds for invocations of the method eu.dnetlib.openaire.exporter.datasource.DatasourcesApiController.searchByName()")

			.register();

	@Around("execution(* eu.dnetlib.openaire.exporter.datasource.DatasourcesApiController.searchByName(..))")

	public Object logTimeSearchDsByName(final ProceedingJoinPoint joinPoint) throws Throwable {

		final Gauge.Timer requestTimer = datasourceByName.startTimer();

		try {

			return joinPoint.proceed();

		} finally {

			requestTimer.setDuration();

		}

	}

}

package eu.dnetlib.openaire.exporter.vocabularies;

/**

 * Created by claudio on 15/09/2017.

 */

public class Country {

	private String code;

	private String name;

	public Country() {

	}

	public Country(final String code, final String name) {

		this.code = code;

		this.name = name;

	}

	public String getCode() {

		return code;

	}

	public void setCode(final String code) {

		this.code = code;

	}

	public String getName() {

		return name;

	}

	public void setName(final String name) {

		this.name = name;

	}

}

package eu.dnetlib.openaire.exporter.vocabularies;

/**

 * Created by claudio on 15/09/2017.

 */

public class Term {

	private String englishName;

	private String code;

	public Term() {

	}

	public String getEnglishName() {

		return englishName;

	}

	public void setEnglishName(final String englishName) {

		this.englishName = englishName;

	}

	public String getCode() {

		return code;

	}

	public void setCode(final String code) {

		this.code = code;

	}

}

package eu.dnetlib.openaire.exporter.vocabularies;

import java.util.List;

import java.util.Map;

import com.google.common.collect.Maps;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

/**

 * Created by claudio on 15/09/2017.

 */

public class Vocabulary {

	private static final Log log = LogFactory.getLog(Vocabulary.class);

	private List<Term> terms;

	public Vocabulary() {

	}

	private static Map<String, Term> byCode = Maps.newConcurrentMap();

	public String getEnglishName(final String code) {

		if (byCode.isEmpty()) {

			hashByCode();

		}

		final Term term = byCode.get(code);

		return term != null ? term.getEnglishName() : null;

	}

	public boolean hasCode(final String code) {

		return getEnglishName(code) != null;

	}

	private void hashByCode() {

		log.info("hashing vocabulary by code ...");

		getTerms().forEach(term -> byCode.put(term.getCode(), term));

		log.info("hashing vocabulary by code ... done!");

	}

	public List<Term> getTerms() {

		return terms;

	}

	public void setTerms(final List<Term> terms) {

		this.terms = terms;

	}

}

package eu.dnetlib.openaire.exporter;

import org.apache.commons.lang3.StringUtils;

import org.apache.commons.lang3.exception.ExceptionUtils;

import org.apache.commons.logging.Log;

import org.apache.commons.logging.LogFactory;

import org.springframework.http.HttpStatus;

import org.springframework.web.bind.annotation.ExceptionHandler;

import org.springframework.web.bind.annotation.ResponseBody;

import org.springframework.web.bind.annotation.ResponseStatus;

/**

 * Created by claudio on 18/07/2017.

 */

public abstract class AbstractExporterController {

	private static final Log log = LogFactory.getLog(AbstractExporterController.class); // NOPMD by marko on 11/24/08 5:02 PM

	@ResponseBody

	@ExceptionHandler({Exception.class, Throwable.class})

	@ResponseStatus(value = HttpStatus.INTERNAL_SERVER_ERROR)

	public ErrorMessage handleSqlException(final Exception e) {

		log.debug(e.getMessage(), e);

		if (StringUtils.containsIgnoreCase(ExceptionUtils.getRootCauseMessage(e), "Broken pipe")) {

			return null;        //socket is closed, cannot return any response

		} else {

			return new ErrorMessage(e);

		}

	}

	public class ErrorMessage {

		private final String message;

		private final String stacktrace;

		public ErrorMessage(final Exception e) {

			this(e.getMessage(), ExceptionUtils.getStackTrace(e));

		}

		public ErrorMessage(final String message, final String stacktrace) {

			this.message = message;

			this.stacktrace = stacktrace;

		}

		public String getMessage() {

			return this.message;

		}

		public String getStacktrace() {

			return this.stacktrace;

		}

	}

}

package eu.dnetlib.openaire.exporter.model.project;

import java.sql.Date;

import java.util.ArrayList;

import javax.persistence.Entity;

import javax.persistence.Id;

import javax.persistence.Table;

import com.fasterxml.jackson.annotation.JsonIgnore;

import com.google.common.base.Splitter;

import com.google.common.collect.Lists;

import io.swagger.annotations.ApiModel;

import org.apache.commons.lang3.StringUtils;

/**

 * Created by claudio on 20/09/16.

 */

@Entity

@Table(name = "projects_api")

@ApiModel(value = "Project api model", description = "Project api model used by DSpace and Eprints exporter")

public class ProjectApi {

	public static final String INFO_EU_REPO_GRANT_AGREEMENT = "info:eu-repo/grantAgreement/";

	@Id

	@JsonIgnore

	private String id;

	private String code;

	private String acronym;

	private String title;

	private String funder;

	private String jurisdiction;

	private Date startdate;

	private Date enddate;

	private String fundingpathid;

	public ProjectApi() { }

	public String getIdnamespace() {

		String res = INFO_EU_REPO_GRANT_AGREEMENT + getFunder()+"/";

		final String fundingProgram = asFundingProgram(getFundingpathid());

		if (StringUtils.isNotBlank(fundingProgram)) {

			res += fundingProgram;

		}

		res += "/" + escapeCode(getCode());

		if (StringUtils.isNotBlank(getJurisdiction())) {

			res += "/" + getJurisdiction();

		}

		return res;

	}

	public String getListLabel() {

		return String.format("for:value:component:_%s_project_id", asFunder(getFunder()));

	}

	private String asFunder(final String legalshortname) {

		switch (legalshortname.toLowerCase()) {

		case "ec":

			return asFundingProgram(getFundingpathid()).toLowerCase();

		default:

			return legalshortname.toLowerCase();

		}

	}

	private String escapeCode(final String code) {

		return replaceSlash(code);

	}

	private String asFundingProgram(final String fundingpathid) {

		final ArrayList<String> strings = Lists.newArrayList(Splitter.on("::").split(fundingpathid));

		if(strings.size() <= 1) throw new IllegalStateException("Unexpected funding id: "+fundingpathid);

		if(strings.size() == 2) return "";

		else return replaceSlash(strings.get(2));

	}

	private String replaceSlash(final String s) {

		return s.replaceAll("/", "%2F");

	}

	public String getId() {

		return id;

	}

	public void setId(final String id) {

		this.id = id;

	}

	public String getCode() {

		return code;

	}

	public void setCode(final String code) {

		this.code = code;

	}

	public String getAcronym() {

		return acronym;

	}

	public void setAcronym(final String acronym) {

		this.acronym = acronym;

	}

	public String getTitle() {

		return title;

	}

	public void setTitle(final String title) {

		this.title = title;

	}

	public String getFunder() {

		return funder;

	}

	public void setFunder(final String funder) {

		this.funder = funder;

	}

	public String getJurisdiction() {

		return jurisdiction;

	}

	public void setJurisdiction(final String jurisdiction) {

		this.jurisdiction = jurisdiction;

	}

	public Date getStartdate() {

		return startdate;

	}

	public void setStartdate(final Date startdate) {

		this.startdate = startdate;

	}

	public Date getEnddate() {

		return enddate;

	}

	public void setEnddate(final Date enddate) {

		this.enddate = enddate;

	}

	public String getFundingpathid() {

		return fundingpathid;

	}

	public void setFundingpathid(final String fundingpathid) {

		this.fundingpathid = fundingpathid;

	}

}

package eu.dnetlib.openaire.exporter.model.project;

import java.sql.Date;

import java.util.List;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.Id;

import javax.persistence.Table;

import com.fasterxml.jackson.annotation.JsonIgnore;

import com.google.common.collect.Lists;

import io.swagger.annotations.ApiModel;

import org.apache.commons.lang3.StringUtils;

/**

 * Created by claudio on 05/07/2017.

 */

@Entity

@Table(name = "projects_tsv")

@ApiModel(value = "Project TSV model", description = "project TSV model description")

public class ProjectTsv {

	@Id

	@JsonIgnore

	private long rowid;

	private String code;

	private String acronym;

	private String title;

	@Column(name = "call_identifier")

	private String callIdentifier;

	private Date startdate;

	private Date enddate;

	@Column(name = "ec_sc39")

	private Boolean ecSc39;

	@Column(name = "oa_mandate_for_publications")

	private Boolean oaMandateForPublications;

	@Column(name = "oa_mandate_for_datasets")