search

dataquest-dev / dspace-import

Blackbox tests for dspace repository
Other
0 stars 2 forks source link

UFAL/PY-license_label_extended_mapping old 136 != new 211 #87

Closed milanmajchrak closed 1 year ago

milanmajchrak commented 1 year ago

It is because in the CLARIN-DSpace5 the license_definition is connected with the non-extended license label directly and not by joining the license_label table thru the license_label_extended_mapping. Id of the non-extended license label is stored in the license_definition.label_id column. But in the CLARIN-DSpace7 all the license labels are connected with the license_definition table thru the license_label_extended_mapping. That is the reason why the license_label_extended_mapping has more records.

You can select all the data where the license_label.is_extended = false and count of the records will be 136.

select count(*) from license_definition
    join license_label_extended_mapping llem using(license_id)
    join license_label ll on (llem.label_id = ll.label_id)
    where ll.is_extended = true;