Changes between Version 19 and Version 21 of Ticket #1591


Ignore:
Timestamp:
Sep 13, 2011, 11:50:35 AM (13 years ago)
Author:
Nicklas Nordborg
Comment:

The update script seems to be working on our test database and also on the demo server database. It has only been tested with MySQL so far but I think it doesn't work on a PostgreSQL database. Unless something really big comes up, any remaining issues will be fixed after the alfa release.

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #1591 – Description

    v19 v21  
    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  * '''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.
     13 * '''Done [5703], [5730], [5734]'''. 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 * '''Done [5733]'''. 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.
    1515 * '''Done [5730]'''. Drop unique contraint on `FileSetMember` table for `fileset_id` and `datafiletype_id` columns.
    1616 * '''Done [5733]'''. Set `allow_multiple=false` for all existing platform file types.
    1717 * '''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.
     18 * '''Done [5734]'''. Deprecate and disable batch importers: `LabeledExtractImporter`, `HybridizationImporter`, `ScanImporter`.