Changes between Version 15 and Version 17 of Ticket #1591


Ignore:
Timestamp:
Sep 12, 2011, 12:45:10 PM (13 years ago)
Author:
Nicklas Nordborg
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #1591 – Description

    v15 v17  
    77 * '''Done [5624]'''. Remove four properties for validator and metadata extractor from `DataFileType` and drop the four database columns.
    88 * '''Done [5703]'''. Copy information in `BioMaterialEventSources` to `BioMaterialEventSources2` so that parent-child linking of biomaterial is retained. Remove the `BioMaterialEventSources` table.
    9  * '''In progres [5703]'''. Set `BioMaterials.parent_type` column based on information in the `pooled` and `parent_id` column. Remove the `pooled` column.
     9 * '''Done [5703], [5730]'''. Set `BioMaterials.parent_type` and `parent_id` column based on parent/child information. Remove the `pooled` column.
    1010 * '''Done [5703]'''. Convert `LabeledExtract` to `Extract` items by updating the `BioMaterials.discriminator` column. All "soft" relations (eg. item_type+item_id pairs) need to update the item_type column (204->203). Set the subtype on all existing labeled extracts.
    1111 * '''Done [5703]'''. Convert `Label` to `Tag`. Set the subtype on all existing labels.
    1212 * '''Done [5703]'''. Convert `Hybridization` to `PhysicalBioAssay`. Copy information from the `Hybridizations` table to `PhysicalBioAssays`. Set new id on `BioMaterialEvents.physicalbioassay_id` column. Remove `BioMaterialEvents.hybridization_id` column. All "soft" relations (eg. item_type+item_id pairs) need to update the item_type column (261->267). Set the subtype on all existing hybridizations.
    13  * '''In progress [5703]'''. Convert `Scan` to `DerivedBioAssay`. Copy information from the `Scans` table to `DerivedBioAssays`. Copy information from `Images` table to `FileSetMember`. All "soft" relations (eg. item_type+item_id pairs) need to update the item_type column (262->268). Set the subtype on all existing scans.
     13 * '''Done [5703], [5730]'''. Convert `Scan` to `DerivedBioAssay`. Copy information from the `Scans` table to `DerivedBioAssays`. Copy information from `Images` table to `FileSetMember`. All "soft" relations (eg. item_type+item_id pairs) need to update the item_type column (262->268). Set the subtype on all existing scans.
    1414 * Update `RawBioAssay` to point to the derived bioassay instead of the scan. Remove `scan_id` column. Populate `extract_id` column based on information in the `array_num` and the positions of biomaterials on the linked hybridization.
    15  * Drop unique contraint on `FileSetMember` table for `fileset_id` and `datafiletype_id` columns.
    16  * '''In progress [5703]'''. Convert `ProtocolType`, `HardwareType`, `SoftwareType` and `FileType` to `ItemSubtype` and make sure all hard and soft references are updated. Drop tables and columns that are no longer used.
     15 * '''Done [5730]'''. Drop unique contraint on `FileSetMember` table for `fileset_id` and `datafiletype_id` columns.
     16 * '''Done [5703], [5730]'''. Convert `ProtocolType`, `HardwareType`, `SoftwareType` and `FileType` to `ItemSubtype` and make sure all hard and soft references are updated. Drop tables and columns that are no longer used.