diff options
| author | BonfaceKilz | 2021-05-04 23:27:34 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2021-05-05 12:26:04 +0300 |
| commit | 7e6886d7f65307519b8d26ec43a04f8d674fc4b6 (patch) | |
| tree | 609328c5675f56ca0199fbc6d1a3b1afbafe8a52 /wqflask | |
| parent | b2b81942c6dda717ec8e7beeac61477f0e67a387 (diff) | |
| download | genenetwork2-7e6886d7f65307519b8d26ec43a04f8d674fc4b6.tar.gz | |
base: species: Format SQL queries
Diffstat (limited to 'wqflask')
| -rw-r--r-- | wqflask/base/species.py | 31 |
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) |