Revision 60979
Added by Miriam Baglioni almost 3 years ago
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch_canadian_funder.sql | ||
---|---|---|
1 |
INSERT INTO dsm_datasources (id, officialname, namespaceprefix, typology) |
|
2 |
VALUES |
|
3 |
('openaire____::nserc', 'Natural Sciences and Engineering Research Council of Canada', 'nserc_______', 'entityregistry::projects'), |
|
4 |
('openaire____::sshrc', 'Social Sciences and Humanities Research Council', 'sshrc_______', 'entityregistry::projects'), |
|
5 |
('openaire____::cihr', 'Canadian Institutes of Health Research', 'cihr________','entityregistry::projects'); |
|
6 |
|
|
1 | 7 |
INSERT INTO dsm_organizations (id, legalshortname,legalname) |
2 | 8 |
VALUES |
3 | 9 |
('nserc_______::NSERC','NSERC','Natural Sciences and Engineering Research Council of Canada'), |
... | ... | |
36 | 42 |
|
37 | 43 |
INSERT INTO projects (id, code, title, collectedfrom, provenanceactionclass) |
38 | 44 |
VALUES |
39 |
('nserc_______::unidentified', 'unidentified', 'unidentified', 'infrastruct_::openaire', 'sysimport:crosswalk:entityregistry'),
|
|
40 |
('sshrc_______::unidentified', 'unidentified', 'unidentified', 'infrastruct_::openaire', 'sysimport:crosswalk:entityregistry'),
|
|
41 |
('cihr________::unidentified', 'unidentified', 'unidentified', 'infrastruct_::openaire', 'sysimport:crosswalk:entityregistry');
|
|
45 |
('nserc_______::unidentified', 'unidentified', 'unidentified', 'openaire__::nserc', 'sysimport:crosswalk:entityregistry'),
|
|
46 |
('sshrc_______::unidentified', 'unidentified', 'unidentified', 'openaire__::sshrc', 'sysimport:crosswalk:entityregistry'),
|
|
47 |
('cihr________::unidentified', 'unidentified', 'unidentified', 'openaire__::cihr', 'sysimport:crosswalk:entityregistry');
|
|
42 | 48 |
|
43 | 49 |
INSERT INTO project_fundingpath (funding, project) |
44 | 50 |
VALUES |
Also available in: Unified diff
changed the collectedfrom as the id of the datasource for the funder. Added the insertion of the datasources in the database