about summary refs log tree commit diff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2022-09-02 16:50:27 +0300
committerBonfaceKilz2022-09-08 14:26:19 +0300
commita12debe030b6b8c4ae30781ad20a9f4b043d5acc (patch)
tree1bc61e7b91c509dab0282b1ae7957e0873326926
parentee7172977107deb1184548c8e02493008ea7ebad (diff)
downloadgenenetwork2-a12debe030b6b8c4ae30781ad20a9f4b043d5acc.tar.gz
Remove '+' when concatenating strings inside brackets
* wqflask/wqflask/db_info.py (InfoPage.get_info): Delete "+".
-rw-r--r--wqflask/wqflask/db_info.py34
1 files changed, 17 insertions, 17 deletions
diff --git a/wqflask/wqflask/db_info.py b/wqflask/wqflask/db_info.py
index f52c30e4..09cd614b 100644
--- a/wqflask/wqflask/db_info.py
+++ b/wqflask/wqflask/db_info.py
@@ -19,24 +19,24 @@ class InfoPage:
         self.get_datasets_list()
 
     def get_info(self, create=False):
-        query_base = ("SELECT InfoPageName, GN_AccesionId, Species.MenuName, Species.TaxonomyId, Tissue.Name, InbredSet.Name, " +
+        query_base = ("SELECT InfoPageName, GN_AccesionId, Species.MenuName, Species.TaxonomyId, Tissue.Name, InbredSet.Name, "
                       "GeneChip.GeneChipName, GeneChip.GeoPlatform, AvgMethod.Name, Datasets.DatasetName, Datasets.GeoSeries, "
-                      + "Datasets.PublicationTitle, DatasetStatus.DatasetStatusName, Datasets.Summary, Datasets.AboutCases, "
-                      + "Datasets.AboutTissue, Datasets.AboutDataProcessing, Datasets.Acknowledgment, Datasets.ExperimentDesign, "
-                      + "Datasets.Contributors, Datasets.Citation, Datasets.Notes, Investigators.FirstName, Investigators.LastName, "
-                      + "Investigators.Address, Investigators.City, Investigators.State, Investigators.ZipCode, Investigators.Country, "
-                      + "Investigators.Phone, Investigators.Email, Investigators.Url, Organizations.OrganizationName, "
-                      + "InvestigatorId, DatasetId, DatasetStatusId, Datasets.AboutPlatform, InfoFileTitle, Specifics "
-                      + "FROM InfoFiles "
-                      + "LEFT JOIN Species USING (SpeciesId) "
-                      + "LEFT JOIN Tissue USING (TissueId) "
-                      + "LEFT JOIN InbredSet USING (InbredSetId) "
-                      + "LEFT JOIN GeneChip USING (GeneChipId) "
-                      + "LEFT JOIN AvgMethod USING (AvgMethodId) "
-                      + "LEFT JOIN Datasets USING (DatasetId) "
-                      + "LEFT JOIN Investigators USING (InvestigatorId) "
-                      + "LEFT JOIN Organizations USING (OrganizationId) "
-                      + "LEFT JOIN DatasetStatus USING (DatasetStatusId) WHERE ")
+                      "Datasets.PublicationTitle, DatasetStatus.DatasetStatusName, Datasets.Summary, Datasets.AboutCases, "
+                      "Datasets.AboutTissue, Datasets.AboutDataProcessing, Datasets.Acknowledgment, Datasets.ExperimentDesign, "
+                      "Datasets.Contributors, Datasets.Citation, Datasets.Notes, Investigators.FirstName, Investigators.LastName, "
+                      "Investigators.Address, Investigators.City, Investigators.State, Investigators.ZipCode, Investigators.Country, "
+                      "Investigators.Phone, Investigators.Email, Investigators.Url, Organizations.OrganizationName, "
+                      "InvestigatorId, DatasetId, DatasetStatusId, Datasets.AboutPlatform, InfoFileTitle, Specifics "
+                      "FROM InfoFiles "
+                      "LEFT JOIN Species USING (SpeciesId) "
+                      "LEFT JOIN Tissue USING (TissueId) "
+                      "LEFT JOIN InbredSet USING (InbredSetId) "
+                      "LEFT JOIN GeneChip USING (GeneChipId) "
+                      "LEFT JOIN AvgMethod USING (AvgMethodId) "
+                      "LEFT JOIN Datasets USING (DatasetId) "
+                      "LEFT JOIN Investigators USING (InvestigatorId) "
+                      "LEFT JOIN Organizations USING (OrganizationId) "
+                      "LEFT JOIN DatasetStatus USING (DatasetStatusId) WHERE ")
 
         if self.gn_accession_id:
             final_query = query_base + \