Turn the library_id back into the primary key for samples_library (SCHEMA CHANGE!)
authorDiane Trout <diane@caltech.edu>
Tue, 27 Oct 2009 22:07:44 +0000 (22:07 +0000)
committerDiane Trout <diane@caltech.edu>
Tue, 27 Oct 2009 22:07:44 +0000 (22:07 +0000)
commit80978a451d08921d67f0aed8b916c6228f36c818
tree4685dbe0039655cd54b1861cf171510ef2246741
parentf8e6277627aa511b72ecfcc8e8a4545b1c5b51bf
Turn the library_id back into the primary key for samples_library (SCHEMA CHANGE!)
Trying to make it possible to enter the 'library_id' instead of the
arbitrary auto-incrementing key when creating a flowcell was turning out
to be far too time consuming.

It was vastly easier to decide that the 'library id' was a sufficiently
unique short value that it could be used directly as the primary key.
Its now a char 10 field, unlike the integer primary key to support
stanford style library IDs like SL123.

Its possible to convert the previous database version to one compatible with
this code by running docs/conv_library_id_to_pk_v0.3.1.py
18 files changed:
docs/conv_library_id_to_pk_v0.3.1.py [new file with mode: 0644]
htsworkflow/frontend/analysis/admin.py
htsworkflow/frontend/analysis/main.py
htsworkflow/frontend/analysis/models.py
htsworkflow/frontend/eland_config/views.py
htsworkflow/frontend/experiments/admin.py
htsworkflow/frontend/experiments/experiments.py
htsworkflow/frontend/experiments/fixtures/test_flowcells.json
htsworkflow/frontend/experiments/tests.py
htsworkflow/frontend/samples/admin.py
htsworkflow/frontend/samples/fixtures/test_samples.json
htsworkflow/frontend/samples/models.py
htsworkflow/frontend/samples/tests.py
htsworkflow/frontend/samples/views.py
htsworkflow/frontend/templates/experiments/flowcellSheet.html
htsworkflow/frontend/templates/experiments/started_email.html
htsworkflow/frontend/templates/experiments/started_email.txt
htsworkflow/frontend/templates/samples/library_detail.html