Changes between Version 20 and Version 22 of Ticket #2321


Ignore:
Timestamp:
May 23, 2024, 11:54:57 AM (6 months ago)
Author:
Nicklas Nordborg
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #2321 – Description

    v20 v22  
    6565|| version       || +1 ||
    6666|| item_type     || Change 264 (=RAWBIOASSAY) to 268 (=DERIVEDBIOASSAY) ||
     67
     68But, we also need to address the fact that the file types of the members in the file set must match the new item type. We can either change the file types to new types or we can change the item type on the existing file types. In the first case we update the !FileSetMembers table:
     69
     70|| **!FileSetMembers** || **Comment** ||
     71|| id                  || Keep ||
     72|| version             || +1 ||
     73|| fileset_id          || Keep ||
     74|| datafiletype_id     || Update to new type ||
     75|| ''other columns''   || Keep ||
     76
     77If there are any remaining file types for raw bioassays that has been migrated we need to update them to derived bioassays instead. This is in the !DataFileTypes table:
     78
     79|| **!DataFileTypes** || **Comment** ||
     80|| id                 || Keep ||
     81|| version            || +1 ||
     82|| item_type          || Change 264 (=RAWBIOASSAY) to 268 (=DERIVEDBIOASSAY) ||
     83|| ''other columns''  || Keep ||
     84
     85Note that we don't do this for all file types, but only for the types that are used by the migrated raw bioassays.
    6786
    6887== Any-to-any links ==