D-Net

-- Migrate the managed status

update dsm_datasources d set d.managed = true where d.id in (

	SELECT d.id

	FROM dsm_datasources d

	LEFT OUTER JOIN dsm_api a ON (d.id = a.datasource)

	LEFT OUTER JOIN apicollections ap ON (ap.api = a.id)

	WHERE a.active = TRUE

	  OR a.removable = TRUE

	  OR ap.edited IS NOT NULL

	GROUP BY d.id );

-- !!!!! data insert complete !!!!!

delete from organizations where id like 'opendoar%' ;

delete from organizations where id like 're3data%' ;

delete from organizations where collectedfrom is null ;

delete from dsm_organizations where collectedfrom = 'openaire____::corda'  ;

delete from dsm_organizations where collectedfrom = 'openaire____::snsf'  ;

delete from dsm_organizations where collectedfrom = 'openaire____::conicytf'  ;

delete from dsm_organizations where collectedfrom = 'openaire____::irb_hr' ;

delete from dsm_organizations where collectedfrom = 'openaire____::fwf'  ;

delete from dsm_organizations where collectedfrom = 'openaire____::sfi'  ;

delete from dsm_organizations where collectedfrom = 'openaire____::wellcometrust'  ;

delete from dsm_organizations where collectedfrom = 'openaire____::nsf'  ;

delete from dsm_organizations where collectedfrom = 'openaire____::corda_h2020'  ;

		<version>1.0.0</version>