IQSS
adding sql script to convert custom license CC0 Waiver to CC0 1.0
What this PR does / why we need it: The update from pre-v5.10 to 5.10+ adjusts the terms metadata of datasets in the installation. The datasets that have a CC0 waiver plus text in any other field in the old "Terms of Use" accordion are considered to have "custom licenses". But some datasets with CC0 waivers and no text in fields in the old "Terms of Use" accordions also appear, after the update, to have "custom licenses", such as https://doi.org/10.7910/DVN/00ROYZ and https://doi.org/10.15787/h6vv-ts37. The only text in the custom license is "CC0 waiver":
Which issue(s) this PR closes:Multiple license update turned the terms of some datasets with only CC0 licenses into "custom licenses" #9081
Closes #9081
Special notes for your reviewer:
Suggestions on how to test this: SQL Script
Does this PR introduce a user interface change? If mockups are available, please link/include them here: No
Is there a release notes update needed for this change?: Yes. Included
Additional documentation:
coverage: 20.659%. remained the same when pulling 71098cb9e54c66a2af620b74d44514e663612cd8 on 9081-CC0-waiver-turned-into-custom-license into 00020e2e14be599d49bbd7400d37454cf91717b7 on develop.
:package: Pushed preview images as
ghcr.io/gdcc/dataverse:9081-CC0-waiver-turned-into-custom-license
ghcr.io/gdcc/configbaker:9081-CC0-waiver-turned-into-custom-license
:ship: See on GHCR. Use by referencing with full name as printed above, mind the registry name.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
coverage: 20.659%. remained the same when pulling 116262c0fdad3a919ad88e76879cd0a1d253cee3 on 9081-CC0-waiver-turned-into-custom-license into 00020e2e14be599d49bbd7400d37454cf91717b7 on develop.
coverage: 20.659%. remained the same when pulling 116262c0fdad3a919ad88e76879cd0a1d253cee3 on 9081-CC0-waiver-turned-into-custom-license into 00020e2e14be599d49bbd7400d37454cf91717b7 on develop.
:package: Pushed preview images as
ghcr.io/gdcc/dataverse:9081-CC0-waiver-turned-into-custom-license
ghcr.io/gdcc/configbaker:9081-CC0-waiver-turned-into-custom-license
:ship: See on GHCR. Use by referencing with full name as printed above, mind the registry name.
coverage: 20.659%. remained the same when pulling db19451409521f5c319a0ccefecc5ae2aa28a555 on 9081-CC0-waiver-turned-into-custom-license into 00020e2e14be599d49bbd7400d37454cf91717b7 on develop.
:package: Pushed preview images as
ghcr.io/gdcc/dataverse:9081-CC0-waiver-turned-into-custom-license
ghcr.io/gdcc/configbaker:9081-CC0-waiver-turned-into-custom-license
:ship: See on GHCR. Use by referencing with full name as printed above, mind the registry name.