diff options
| -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 + \ |