diff options
| author | Munyoki Kilyungi | 2022-09-07 11:03:32 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2022-09-08 14:26:19 +0300 |
| commit | a0aa7bbf473506ff513c7a5557654f2bf05b0df9 (patch) | |
| tree | cbc832857a7dad6c3214920f0628deb50dbb327c | |
| parent | 09cc368920182681cad74a908414e59632db6bbd (diff) | |
| download | genenetwork2-a0aa7bbf473506ff513c7a5557654f2bf05b0df9.tar.gz | |
Use "%s" instead of "%2.6f" or "%d" in query.
* wqflask/wqflask/interval_analyst/GeneUtil.py (loadGenes): Use "%s".
| -rw-r--r-- | wqflask/wqflask/interval_analyst/GeneUtil.py | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/wqflask/wqflask/interval_analyst/GeneUtil.py b/wqflask/wqflask/interval_analyst/GeneUtil.py index 9e56f66b..780a4db1 100644 --- a/wqflask/wqflask/interval_analyst/GeneUtil.py +++ b/wqflask/wqflask/interval_analyst/GeneUtil.py @@ -82,12 +82,12 @@ def loadGenes(chrName, diffCol, startMb, endMb, species='mouse'): if diffCol and othSpec == 'mouse': cursor.execute( "SELECT count(*) FROM BXDSnpPosition " - "WHERE Chr = %s AND Mb >= %2.6f AND " - "Mb < %2.6f AND StrainId1 = %d " - "AND StrainId2 = %d", - (chrName, f"{newdict['TxStart']:2.6f}", - f"{newdict['TxEnd']:2.6f}", - diffCol[0], diffCol[1])) + "WHERE Chr = %s AND Mb >= %s AND " + "Mb < %s AND StrainId1 = %s " + "AND StrainId2 = %s", + (chrName, f"{newdict['TxStart']:2.6f}", + f"{newdict['TxEnd']:2.6f}", + diffCol[0], diffCol[1])) if snp_count := cursor.fetchone(): newdict2["snpCount"] = snp_count[0] |