Project

General

Profile

« Previous | Next » 

Revision 59186

Instructions to address the path of multiple funding paths: see also #5695

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch-fundingpaths.sql
64 64
delete from fundingpaths  where id = 'sfi_________::SFI::SFI US Ireland R&D Partnership - Planning Grant';
65 65
select count(distinct project) from project_fundingpath where project like 'sfi%';
66 66
select count(distinct id) from projects where id like 'sfi%';
67

  
68
-- WT
69
delete from project_fundingpath where project like 'wt%';
70
delete from fundingpaths where id like 'wt%';
71

  
72
-- SNSF
73
delete from project_fundingpath where project like 'snsf%';
74
delete from fundingpaths where id like 'snsf%';
75

  
76
-- ARC
77
delete from project_fundingpath where project like 'arc%';
78
delete from fundingpaths where id like 'arc%';
79

  
80
-- RCUK
81
delete from project_fundingpath where project like 'rcuk%';
82
delete from fundingpaths where id like 'rcuk%';
83

  
84

  
85

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

  
22 22
UPDATE apicollections
23 23
SET _dnet_resource_identifier_ = api || '@@' || param;
24

  
25
insert into dsm_organizations(id, legalname, legalshortname, country, dateofcollection, _dnet_resource_identifier_, lastupdate, trust) VALUES ('arc_________::ARC', 'Australian Research Council (ARC)', 'ARC', 'AU',  '2018-06-08', 'arc_________::ARC', '2020-07-18', 0.9);

Also available in: Unified diff