aboutsummaryrefslogtreecommitdiff
path: root/wqflask
diff options
context:
space:
mode:
authorMunyoki Kilyungi2022-09-02 16:50:27 +0300
committerBonfaceKilz2022-09-08 14:26:19 +0300
commita12debe030b6b8c4ae30781ad20a9f4b043d5acc (patch)
tree1bc61e7b91c509dab0282b1ae7957e0873326926 /wqflask
parentee7172977107deb1184548c8e02493008ea7ebad (diff)
downloadgenenetwork2-a12debe030b6b8c4ae30781ad20a9f4b043d5acc.tar.gz
Remove '+' when concatenating strings inside brackets
* wqflask/wqflask/db_info.py (InfoPage.get_info): Delete "+".
Diffstat (limited to 'wqflask')
-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 + \