Project

General

Profile

« Previous | Next » 

Revision 52325

Added by Claudio Atzori almost 6 years ago

using dsm_datasources in sql expressions

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/dataRepositoryByJournal/sql/pangaea_preparetable.sql
3 3 
	_dnet_resource_identifier_ CHARACTER VARYING(2048) DEFAULT 'temp_' || md5(clock_timestamp() :: TEXT) || '_' || md5(random() :: TEXT),
4 4 
	id                         CHARACTER VARYING(255) PRIMARY KEY,
5 5 
	issn                       CHARACTER VARYING(255),
6 
	oa_source_id               CHARACTER VARYING(255) REFERENCES datasources (id)
6 
	oa_source_id               CHARACTER VARYING(255) REFERENCES dsm_datasources (id)
7 7 
);
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/dataRepositoryByJournal/sql/pangaea_journal_findmatches.sql
4 4 
		p.oa_source_id,
5 5 
		p.issn || '__' || p.id,
6 6 
		d.id
7 
	FROM datasources d, pangaea_temp_journals p
7 
	FROM dsm_datasources d, pangaea_temp_journals p
8 8 
	WHERE
9 9 
		d.collectedfrom = 'driver______::1790119e-d281-4b7a-aedf-866d1d853a07' AND d.issn IS NOT NULL AND d.id LIKE 'doajarticles::%' AND p.issn = d.issn
10 10 
		AND
......
12 12 
		(SELECT
13 13 
			 oa_source_id,
14 14 
			 entry
15 
		 FROM hostedby_map)
15 
		 FROM hostedby_map)
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/dataRepositoryByJournal/sql/find_journal_intersection.sql
4 4 
	d.officialname AS name,
5 5 
	p.value        AS issn
6 6 

  		




  7
  
  
    
FROM hostedby_map h, datasources d, hostedby_props p


  		




  
  7
  
    
FROM hostedby_map h, dsm_datasources d, hostedby_props p


  		




  8
  8
  
    
WHERE


  		




  9
  9
  
    
	h.oa_source_id = 're3data_____::r3d100010134' AND


  		




  10
  
  
    
	h.datasourceid = d.id AND p._dnet_resource_identifier_ = h._dnet_resource_identifier_ AND p.key = 'issn'


  		




  
  10
  
    
	h.datasourceid = d.id AND p._dnet_resource_identifier_ = h._dnet_resource_identifier_ AND p.key = 'issn'


  		












  

    
      modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/sql-datacite/dataciteSets_prepareTables.sql
    
  





  5
  5
  
    
	setname                    CHARACTER VARYING(255),


  		




  6
  6
  
    
	setname_cleaned            CHARACTER VARYING(255),


  		




  7
  7
  
    
	setspec                    CHARACTER VARYING(255),


  		




  8
  
  
    
	oa_source_id               CHARACTER VARYING(255) REFERENCES datasources (id)


  		




  
  8
  
    
	oa_source_id               CHARACTER VARYING(255) REFERENCES dsm_datasources (id)


  		




  9
  9
  
    
);


  		




  10
  10
  
    

  		




  11
  11
  
    
DROP TABLE IF EXISTS datacite_temp_datarepos;


  		












  

    
      modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/materialised_views.sql
    
  





  240
  240
  
    
		LEFT OUTER JOIN projectpids pp ON (pp.project = p.id)


  		




  241
  241
  
    
		LEFT OUTER JOIN identities i ON (i.pid = pp.pid)


  		




  242
  242
  
    

  		




  243
  
  
    
		LEFT OUTER JOIN datasources dc ON (dc.id = p.collectedfrom)


  		




  
  243
  
    
		LEFT OUTER JOIN dsm_datasources dc ON (dc.id = p.collectedfrom)


  		




  244
  244
  
    

  		




  245
  245
  
    
		LEFT OUTER JOIN project_fundingpath pf ON (pf.project = p.id)


  		




  246
  246
  
    
		LEFT OUTER JOIN fundingpaths fp ON (fp.id = pf.funding)


  		












Also available in:  Unified diff