diff options
author | zsloan | 2016-11-02 20:00:04 +0000 |
---|---|---|
committer | zsloan | 2016-11-02 20:00:04 +0000 |
commit | 717677b0c09f6ba08268db12d4889503cc2606d9 (patch) | |
tree | e362121714dcffec39c68b22e1780fd0a4125aba /wqflask/base/data_set.py | |
parent | 684f461b815e3920419874fccb036c359cae35d8 (diff) | |
download | genenetwork2-717677b0c09f6ba08268db12d4889503cc2606d9.tar.gz |
Added Scroller functionality to regular (but not global) search, which increases table load speed
In order to implement Scroller (and make table look nicer), all rows are the same height and excess description/authors text is shown in a tooltip
Increased table width for non-Geno DBs
Fixed issue where Genotype traits did not fetch their location_repr (text for displaying location), causing that column to be blank in searches
Fixed issue causing Correlation Matrix cells to not be colored corresponding with their correlation and also increased cell font a little
Fixed issue where dataset link in the Correlation Page did not correctly point to corresponding GN1 page
Diffstat (limited to 'wqflask/base/data_set.py')
-rw-r--r-- | wqflask/base/data_set.py | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/wqflask/base/data_set.py b/wqflask/base/data_set.py index fddfce58..04436a2e 100644 --- a/wqflask/base/data_set.py +++ b/wqflask/base/data_set.py @@ -271,7 +271,8 @@ class DatasetGroup(object): self.f1list = None self.parlist = None self.get_f1_parent_strains() - #logger.debug("parents/f1s: {}:{}".format(self.parlist, self.f1list)) + + self.accession_id = self.get_accession_id() self.species = webqtlDatabaseFunction.retrieve_species(self.name) @@ -279,6 +280,20 @@ class DatasetGroup(object): self.allsamples = None self._datasets = None + def get_accession_id(self): + results = g.db.execute("""select InfoFiles.GN_AccesionId from InfoFiles, PublishFreeze, InbredSet where + InbredSet.Name = %s and + PublishFreeze.InbredSetId = InbredSet.Id and + InfoFiles.InfoPageName = PublishFreeze.Name and + PublishFreeze.public > 0 and + PublishFreeze.confidentiality < 1 order by + PublishFreeze.CreateTime desc""", (self.name)).fetchone() + + if results != None: + return str(results[0]) + else: + return "None" + def get_specified_markers(self, markers = []): self.markers = HumanMarkers(self.name, markers) |