aboutsummaryrefslogtreecommitdiff
path: root/wqflask
diff options
context:
space:
mode:
authorBonfaceKilz2021-05-04 23:27:34 +0300
committerBonfaceKilz2021-05-05 12:26:04 +0300
commit7e6886d7f65307519b8d26ec43a04f8d674fc4b6 (patch)
tree609328c5675f56ca0199fbc6d1a3b1afbafe8a52 /wqflask
parentb2b81942c6dda717ec8e7beeac61477f0e67a387 (diff)
downloadgenenetwork2-7e6886d7f65307519b8d26ec43a04f8d674fc4b6.tar.gz
base: species: Format SQL queries
Diffstat (limited to 'wqflask')
-rw-r--r--wqflask/base/species.py31
1 files changed, 13 insertions, 18 deletions
diff --git a/wqflask/base/species.py b/wqflask/base/species.py
index e3c29916..c3f4a9ab 100644
--- a/wqflask/base/species.py
+++ b/wqflask/base/species.py
@@ -32,28 +32,23 @@ class Chromosomes:
def __init__(self, dataset=None, species=None):
self.chromosomes = collections.OrderedDict()
if species != None:
- query = """
- Select
- Chr_Length.Name, Chr_Length.OrderId, Length from Chr_Length, Species
- where
- Chr_Length.SpeciesId = Species.SpeciesId AND
- Species.Name = '%s'
- Order by OrderId
- """ % species.capitalize()
+ query = (
+ "SELECT Chr_Length.Name, Chr_Length.OrderId, Length "
+ "FROM Chr_Length, Species WHERE "
+ "Chr_Length.SpeciesId = Species.SpeciesId AND "
+ "Species.Name = "
+ "'%s' ORDER BY OrderId" % species.capitalize()
+ )
else:
self.dataset = dataset
-
- query = """
- Select
- Chr_Length.Name, Chr_Length.OrderId, Length from Chr_Length, InbredSet
- where
- Chr_Length.SpeciesId = InbredSet.SpeciesId AND
- InbredSet.Name = '%s'
- Order by OrderId
- """ % self.dataset.group.name
+ query = (
+ "SELECT Chr_Length.Name, Chr_Length.OrderId, "
+ "Length FROM Chr_Length, InbredSet WHERE "
+ "Chr_Length.SpeciesId = InbredSet.SpeciesId AND "
+ "InbredSet.Name = "
+ "'%s' ORDER BY OrderId" % self.dataset.group.name)
logger.sql(query)
results = g.db.execute(query).fetchall()
-
for item in results:
self.chromosomes[item.OrderId] = IndChromosome(
item.Name, item.Length)