diff options
| author | Arun Isaac | 2021-12-01 18:02:12 +0530 |
|---|---|---|
| committer | Arun Isaac | 2021-12-01 18:02:12 +0530 |
| commit | 1bfca2fc212239d01831bfad336bc44e4cc9056d (patch) | |
| tree | 9f3fa21cab56870b2d6b57044b5afff0f9683949 | |
| parent | 37306a9895b836ecdea2881a12423659e7c10b54 (diff) | |
| download | gn-transform-databases-1bfca2fc212239d01831bfad336bc44e4cc9056d.tar.gz | |
Deal with AvgMethodId = 0.
* dump.scm (dump-info-files): Deal with AvgMethodId.
| -rwxr-xr-x | dump.scm | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/dump.scm b/dump.scm index 4538e3f..587cdbf 100755 --- a/dump.scm +++ b/dump.scm @@ -388,6 +388,13 @@ GROUP BY Email")) (('gn:email . email) (cons 'gn:datasetOfInvestigator (investigator-email->id email))) + (('gn:avgMethodId . avg-method-id) + ;; If avg-method-id is 0, a + ;; non-existent method, assume + ;; N/A. + (and (zero? avg-method-id) + (cons 'gn:normalization + (avg-method-name->id "N/A")))) (('gn:avgMethodName . avg-method-name) (cons 'gn:normalization (avg-method-name->id avg-method-name))) @@ -425,7 +432,7 @@ Species.FullName AS BinomialName, InbredSet.Name AS InbredSetName, Tissue.Short_Name, Investigators.Email, -AvgMethod.Name AS AvgMethodName, +AvgMethodId, AvgMethod.Name AS AvgMethodName, GeneChip.Name AS GeneChip FROM InfoFiles LEFT JOIN Datasets USING (DatasetId) |