Project

General

Profile

« Previous | Next » 

Revision 60979

Added by Miriam Baglioni 9 months ago

changed the collectedfrom as the id of the datasource for the funder. Added the insertion of the datasources in the database

View differences:

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