diff options
| author | zsloan | 2024-08-30 22:12:20 +0000 |
|---|---|---|
| committer | zsloan | 2024-08-30 22:12:59 +0000 |
| commit | 7c2d18143f608b98be577e41257db8954a0c3c7f (patch) | |
| tree | 4556cb28208b64a8416880f1c57c701becc4d212 | |
| parent | 39cb5deed5f33122ea2cc8502945f171367db5df (diff) | |
| download | genenetwork2-7c2d18143f608b98be577e41257db8954a0c3c7f.tar.gz | |
Fix bug that caused genotype trait case attributes to be offset by 1
| -rw-r--r-- | gn2/base/data_set/genotypedataset.py | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/gn2/base/data_set/genotypedataset.py b/gn2/base/data_set/genotypedataset.py index 77af1dad..a5b65772 100644 --- a/gn2/base/data_set/genotypedataset.py +++ b/gn2/base/data_set/genotypedataset.py @@ -50,7 +50,7 @@ GenoFreeze.Name = %s""" with database_connection(get_setting("SQL_URI")) as conn, conn.cursor() as cursor: cursor.execute( "SELECT Strain.Name, GenoData.value, " - "GenoSE.error, 'N/A', Strain.Name2 " + "GenoSE.error, NULL, Strain.Name2 " "FROM (GenoData, GenoFreeze, Strain, Geno, " "GenoXRef) LEFT JOIN GenoSE ON " "(GenoSE.DataId = GenoData.Id AND " @@ -68,9 +68,9 @@ GenoFreeze.Name = %s""" if self.group.name in webqtlUtil.ParInfo: f1_1, f1_2, ref, nonref = webqtlUtil.ParInfo[self.group.name] - results.append([f1_1, 0, None, "N/A", f1_1]) - results.append([f1_2, 0, None, "N/A", f1_2]) - results.append([ref, -1, None, "N/A", ref]) - results.append([nonref, 1, None, "N/A", nonref]) + results.append([f1_1, 0, None, None, f1_1]) + results.append([f1_2, 0, None, None, f1_2]) + results.append([ref, -1, None, None, ref]) + results.append([nonref, 1, None, None, nonref]) return results |