cessda-bitbucket-importer
commented
1 year ago Original comment by Stefan Dlugolinsky (GitHub: Stifo).
The following mysql code generates uri, uri_sl and canonical_uri for all the published versions that have either value null. For each such version it takes uri, uri_sl and canonical uri of its previous version and replaces the version number in them in order to generate new values. The code should be executed at MySQL server:
SET @SQL_SAFE_UPDATES=@@SQL_SAFE_UPDATES;
SET SQL_SAFE_UPDATES = 0;
update version as dst
left join version as src on
dst.previous_version = src.id
set
dst.canonical_uri = case
when dst.canonical_uri is null then regexp_replace(src.canonical_uri, regexp_replace(src.number, '([0-9]+)\.([0-9]+)(\.[0-9]+)?', '$1\\\\.$2(\\\\.[0-9]+)?'), dst.number)
else dst.canonical_uri
end,
dst.uri = case
when dst.uri is null then regexp_replace(src.uri, regexp_replace(src.number, '([0-9]+)\.([0-9]+)(\.[0-9]+)?', '$1\\\\.$2(\\\\.[0-9]+)?'), dst.number)
else dst.uri
end,
dst.uri_sl = case
when dst.uri_sl is null then regexp_replace(src.uri_sl, regexp_replace(src.number, '([0-9]+)\.([0-9]+)(\.[0-9]+)?', '$1\\\\.$2(\\\\.[0-9]+)?'), dst.number)
else dst.uri_sl
end
where
dst.status = 'PUBLISHED'
and (
dst.canonical_uri is null
or
dst.uri is null
or
dst.uri_sl is null
)
;
SET SQL_SAFE_UPDATES = @SQL_SAFE_UPDATES;There are some other issues, probably in the frontend, which alter the version number before displaying it:
Stifo
MajaDolinar
Original report on BitBucket by Maja Dolinar.
If you go to the CV “CDC Publisher Names” at https://vocabularies.cessda.eu/vocabulary/CdcPublisherNames?lang=en and open the tab ‘License and Citation” there is a mistake in 'Available from’ section. See the picture below:
In tab ‘Identity and general’ Canonical URIs are missing everywhere.
The issue was reported from EOSC Helpdesk: https://eosc-helpdesk.eosc-portal.eu/#ticket/zoom/2197