Project

General

Profile

« Previous | Next » 

Revision 57097

Added by Michele Artini over 4 years ago

View differences:

import_grid_ac.sql
92 92 

  		




  93
  93
  
    
INSERT INTO organizations(id, name, lat, lng, city, country, created_by, modified_by) (SELECT 'openorgs____::'||md5(o.grid_id), o.name, a.lat, a.lng, a.city, a.country_code, 'import:grid.ac', 'import:grid.ac'  FROM grid_institutes o LEFT OUTER JOIN grid_addresses a ON (o.grid_id=a.grid_id)) ON CONFLICT DO NOTHING;


  		




  94
  94
  
    
INSERT INTO other_ids    (id, otherid, type)                         (SELECT 'openorgs____::'||md5(grid_id), grid_id,     'grid.ac'                                              FROM grid_institutes   ) ON CONFLICT DO NOTHING;


  		




  95
  
  
    
INSERT INTO other_ids    (id, otherid, type)                         (SELECT 'openorgs____::'||md5(grid_id), external_id, external_id_type::id_type                              FROM grid_external_ids ) ON CONFLICT DO NOTHING;


  		




  
  95
  
    
INSERT INTO other_ids    (id, otherid, type)                         (SELECT 'openorgs____::'||md5(grid_id), external_id, external_id_type                                       FROM grid_external_ids ) ON CONFLICT DO NOTHING;


  		




  96
  96
  
    
INSERT INTO other_names  (id, lang, name)                            (SELECT 'openorgs____::'||md5(grid_id), 'en',   name                                                        FROM grid_institutes   ) ON CONFLICT DO NOTHING;


  		




  97
  97
  
    
INSERT INTO other_names  (id, lang, name)                            (SELECT 'openorgs____::'||md5(grid_id), iso639, label                                                       FROM grid_labels       ) ON CONFLICT DO NOTHING;


  		




  98
  98
  
    
INSERT INTO other_names  (id, lang, name)                            (SELECT 'openorgs____::'||md5(grid_id), '',     alias                                                       FROM grid_aliases      ) ON CONFLICT DO NOTHING;


  		




  99
  99
  
    
INSERT INTO acronyms     (id, acronym)                               (SELECT 'openorgs____::'||md5(grid_id), acronym                                                             FROM grid_acronyms     ) ON CONFLICT DO NOTHING;


  		




  100
  
  
    
INSERT INTO relationships(id1, reltype, id2)                         (SELECT 'openorgs____::'||md5(grid_id), relationship_type::rel_type, 'openorgs____::'||md5(related_grid_id) FROM grid_relationships) ON CONFLICT DO NOTHING;


  		




  101
  
  
    
INSERT INTO types        (id, type)                                  (SELECT 'openorgs____::'||md5(grid_id), type::org_type                                                      FROM grid_types        ) ON CONFLICT DO NOTHING;


  		




  
  100
  
    
INSERT INTO relationships(id1, reltype, id2)                         (SELECT 'openorgs____::'||md5(grid_id), relationship_type, 'openorgs____::'||md5(related_grid_id)           FROM grid_relationships) ON CONFLICT DO NOTHING;


  		




  
  101
  
    
INSERT INTO types        (id, type)                                  (SELECT 'openorgs____::'||md5(grid_id), type                                                                FROM grid_types        ) ON CONFLICT DO NOTHING;


  		




  102
  102
  
    
INSERT INTO urls         (id, url)                                   (SELECT 'openorgs____::'||md5(grid_id), link                                                                FROM grid_links        ) ON CONFLICT DO NOTHING;


  		




  103
  103
  
    

  		












Also available in:  Unified diff