aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xdump.scm9
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)