Project

General

Profile

« Previous | Next » 

Revision 50023

Added by Michele Artini over 6 years ago

View differences:

modules/dnet-isti/trunk/src/main/resources/eu/dnetlib/isti/sql/create_affiliations_tables.sql
15 15 
	year   int,
16 16 
	PRIMARY KEY (pid, gid, year)
17 17 
);
18 

  		




  
  19
  
    
CREATE VIEW affiliations_view AS	SELECT


  		




  
  20
  
    
	p.id       as pid,


  		




  
  21
  
    
	p.fullname as pname,


  		




  
  22
  
    
	g.id       as gid,


  		




  
  23
  
    
	g.name     as gname,


  		




  
  24
  
    
	g.type     as gtype,


  		




  
  25
  
    
	a.year     as year


  		




  
  26
  
    
FROM 


  		




  
  27
  
    
	persons p 


  		




  
  28
  
    
	LEFT OUTER JOIN affiliations a ON (p.id = a.pid)


  		




  
  29
  
    
	LEFT OUTER JOIN       groups g ON (a.gid = g.id);


  		












  

    
      modules/dnet-isti/trunk/src/main/resources/eu/dnetlib/isti/applicationContext-isti.properties
    
  





  1
  1
  
    
plugin.enrich.dataset.dli.url           = https://api-dliservice-prototype-dli.d4science.org/v1/linksFromPid?pid=%s


  		




  2
  2
  
    
plugin.enrich.labs.pimpa.url            = http://pimpa.isti.cnr.it/PERSONALE/web-services/iop/iop.webservice.php


  		




  3
  3
  
    
plugin.enrich.publications.openaire.url = http://api.openaire.eu/search/publications?doi=%s


  		




  4
  
  
    
plugin.enrich.projects.openaire.url     = http://api.openaire.eu/search/projects?funder=%s&fundingStream=%s&grantID=%s


  		




  
  4
  
    
plugin.enrich.projects.openaire.url     = http://api.openaire.eu/search/projects?funder=%s&fundingStream=%s&grantID=%s


  		




  
  5
  
    

  		




  
  6
  
    
db.affiliations.url                     = jdbc:postgresql://localhost:5432/isti_affiliations


  		




  
  7
  
    
db.affiliations.username                = dnet


  		




  
  8
  
    
db.affiliations.password                = 


  		












  

    
      modules/dnet-isti/trunk/src/main/resources/eu/dnetlib/isti/applicationContext-isti.xml
    
  





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


  		




  2
  2
  
    
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"


  		




  3
  3
  
    
	xmlns="http://www.springframework.org/schema/beans"


  		




  
  4
  
    
	xmlns:p="http://www.springframework.org/schema/p"


  		




  4
  5
  
    
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">


  		




  5
  6
  
    

  		




  6
  7
  
    
	<!-- Wf Nodes -->


  		




  ......




  23
  24
  
    

  		




  24
  25
  
    
	<bean id="freezeMDStorePlugin" class="eu.dnetlib.data.mdstore.plugins.FreezeMDStorePlugin" />


  		




  25
  26
  
    

  		




  
  27
  
    
	<!-- Affiliations DAO -->


  		




  
  28
  
    
	<bean id="affiliationsDao" class="eu.dnetlib.data.db.AffiliationsDao">


  		




  
  29
  
    
		<property name="jdbcTemplate">


  		




  
  30
  
    
			<bean  id="affiliationsjdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">


  		




  
  31
  
    
				<property name="dataSource">


  		




  
  32
  
    
					<bean class="org.springframework.jdbc.datasource.DriverManagerDataSource"


  		




  
  33
  
    
						p:driverClassName="org.postgresql.Driver" 


  		




  
  34
  
    
						p:url="${db.affiliations.url}"


  		




  
  35
  
    
						p:username="${db.affiliations.username}"


  		




  
  36
  
    
						p:password="${db.affiliations.password}"/>


  		




  
  37
  
    
				</property>


  		




  
  38
  
    
			</bean>	


  		




  
  39
  
    
		</property>


  		




  
  40
  
    
	</bean>


  		




  26
  41
  
    

  		




  27
  
  
    

  		




  28
  42
  
    
</beans>


  		












  

    
      modules/dnet-isti/trunk/src/main/resources/eu/dnetlib/isti/workflows/repo-hi/pubs_aggregation_wf.xml.st
    
  





  17
  17
  
    

  		




  18
  18
  
    
        <CONFIGURATION status="WAIT_SYS_SETTINGS" start="MANUAL">


  		




  19
  19
  
    
            <PARAMETERS>


  		




  20
  
  
    
				<PARAM name="transformationRuleId"  description="Transformation Rule Identifier" required="true" managedBy="user"   category="TRANSFORMATION_RULE_ID" type="string" function="listProfiles('TransformationRuleDSResourceType', '//TITLE')"/>


  		




  21
  
  
    
            	<PARAM name="collMdstoreId"         description="Store for collected records"    required="true" managedBy="system" category="MDSTORE_ID"/>


  		




  
  20
  
    
		<PARAM name="transformationRuleId"  description="Transformation Rule Identifier" required="true" managedBy="user"   category="TRANSFORMATION_RULE_ID" type="string" function="listProfiles('TransformationRuleDSResourceType', '//TITLE')"/>


  		




  
  21
  
    
		<PARAM name="finalIndexInterpretation"  description="Final Index Interpretation" required="true" managedBy="user" type="string" />


  		




  
  22
  
    
		<PARAM name="finalMongoCollection"  description="Final Mongo Collection" required="true" managedBy="user" type="string" />


  		




  
  23
  
    
		<PARAM name="collMdstoreId"         description="Store for collected records"    required="true" managedBy="system" category="MDSTORE_ID"/>


  		




  22
  24
  
    
            	<PARAM name="cleanMdstoreId"        description="Store for transformed records"  required="true" managedBy="system" category="MDSTORE_ID"/>


  		




  23
  25
  
    
            </PARAMETERS>


  		




  24
  26
  
    
            <WORKFLOW>


  		




  ......




  128
  130
  
    
                                <ENTRY key="mdId"  ref="cleanMdstoreId" />


  		




  129
  131
  
    
                                <ENTRY key="indexFormat" value="PMF"/>


  		




  130
  132
  
    
                                <ENTRY key="indexLayout" value="index"/>


  		




  131
  
  
    
                                <ENTRY key="indexInterpretation" value="final"/>


  		




  
  133
  
    
                                <ENTRY key="indexInterpretation" ref="finalIndexInterpretation"/>


  		




  
  134
  
    
				<ENTRY key="finalMongoCollection" ref="finalMongoCollection"/>


  		




  132
  135
  
    
                            </MAP>


  		




  133
  136
  
    
                        </PARAM>


  		




  134
  137
  
    
                    </PARAMETERS>


  		












  

    
      modules/dnet-isti/trunk/src/main/resources/eu/dnetlib/bootstrap/profiles/workflows/common/index.xml
    
  





  14
  14
  
    
				<PARAM name="indexFormat" description="Index Format" required="true" type="string" />


  		




  15
  15
  
    
				<PARAM name="indexLayout" description="Index Layout" required="true" type="string" />


  		




  16
  16
  
    
				<PARAM name="indexInterpretation" description="Index Interpretation" required="true" type="string" />


  		




  
  17
  
    
				<PARAM name="finalMongoCollection" description="Final Mongo Collection" required="true" type="string"/>


  		




  17
  18
  
    
			</PARAMETERS>


  		




  18
  19
  
    
			<WORKFLOW>


  		




  19
  20
  
    
		


  		




  ......




  100
  101
  
    
						<PARAM name="parameters">


  		




  101
  102
  
    
							<MAP>


  		




  102
  103
  
    
								<ENTRY key="mdId" ref="mdId" />


  		




  103
  
  
    
								<ENTRY key="collection" value="final_isti_store" />


  		




  
  104
  
    
								<ENTRY key="collection" ref="finalMongoCollection" />


  		




  104
  105
  
    
							</MAP>


  		




  105
  106
  
    
						</PARAM>


  		




  106
  107
  
    
					</PARAMETERS>


  		












Also available in:  Unified diff