diff options
| author | Frederick Muriuki Muriithi | 2024-03-13 04:30:23 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2024-03-13 04:30:23 +0300 |
| commit | b0f137449b7b9e33f97871ec0aeb519952c87080 (patch) | |
| tree | 2005c5b576e66801d213f235d984c5c96f9500a6 /topics | |
| parent | d2fcd0582882c200679105b6df99f62f56ea75d6 (diff) | |
| download | gn-gemtext-b0f137449b7b9e33f97871ec0aeb519952c87080.tar.gz | |
Add link to script to migrate `CaseAttribute*` tables' schemas.
Diffstat (limited to 'topics')
| -rw-r--r-- | topics/editing/case_attributes.gmi | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/topics/editing/case_attributes.gmi b/topics/editing/case_attributes.gmi index 541c689..5a11026 100644 --- a/topics/editing/case_attributes.gmi +++ b/topics/editing/case_attributes.gmi @@ -93,6 +93,10 @@ while the `CaseAttributeXRefNew` table ends up with the following columns: There will not be any `NULL` values allowed for any of the columns in both tables. If a strain has no value, we simply delete the corresponding record from the `CaseAttributeXRefNew` table. +To that end, the following script has been added to ease the migration of the table schemas: +=> https://github.com/genenetwork/genenetwork3/blob/dd0b29c07017ec398c447ca683dd4b4be18d73b7/scripts/update-case-attribute-tables-20230818 +The script is meant to be run only once, and makes the changes mentioned above for both tables. + ## Data Types > ... (and exist separately from "normal" traits mainly because they're non-numeric) |