diff options
| author | Munyoki Kilyungi | 2022-09-02 16:50:27 +0300 |
|---|---|---|
| committer | BonfaceKilz | 2022-09-08 14:26:19 +0300 |
| commit | a12debe030b6b8c4ae30781ad20a9f4b043d5acc (patch) | |
| tree | 1bc61e7b91c509dab0282b1ae7957e0873326926 | |
| parent | ee7172977107deb1184548c8e02493008ea7ebad (diff) | |
| download | genenetwork2-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.py | 34 |
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 + \ |