aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance/gen_select_dataset.py
AgeCommit message (Collapse)Author
2022-03-10Use context manager with database connectionFrederick Muriuki Muriithi
Use the `with` context manager with database connections and cursors to ensure that they are closed once they are no longer needed. Where it was not feasible to use the `with` context manager without a huge refactor/rewrite, the cursors and connections are closed manually.
2021-04-30autopep8: Fix E121,E122,E123,EI24,E125,E126,E127,E128,E129,E131,E133BonfaceKilz
2021-04-30autopep8: Fix E501BonfaceKilz
2021-04-30autopep8: Fix E301,E302,E303,E304,E305,E306BonfaceKilz
2021-04-30autopep8: Fix E20-E27BonfaceKilz
Run: python -m autopep8 --in-place --recrusive ./ --select\ E20,E211,E22,E224,E224,E225,E226,E227,E228,E231,E241,\ E242,E251,E252,E26,E265,E266,E27 -p 3
2020-08-26Remove "from __future__ import new_feature" statementsBonfaceKilz
See: <https://docs.python.org/2/library/2to3.html#2to3fixer-future>
2020-08-20Handle module renames in the standard libraryBonfaceKilz
Run: ``` 2to3-3.8 -f imports -w . && \ 2to3-3.8 -f imports2 -w . ``` See: <https://docs.python.org/2/library/2to3.html#2to3fixer-imports> and <https://docs.python.org/2/library/2to3.html#2to3fixer-imports2>
2020-08-19Remove extra whitespace(or add it) from comma separated itemsBonfaceKilz
See: <https://docs.python.org/2/library/2to3.html#2to3fixer-urllib>
2020-08-19Fix dictionary iteration methodsBonfaceKilz
Run `2to3-3.8 -f dict -w .` See: <https://docs.python.org/2/library/2to3.html#2to3fixer-dict> and <https://stackoverflow.com/questions/17695456/why-does-python-3-need-dict-items-to-be-wrapped-with-list>
2020-03-10Added back macaque monkey to dropdown generation, not sure why it was ↵zsloan
removed; need to ask Rob
2019-10-18Added UniProt link and fixed issue that caused sample lists to not be formed ↵zsloan
correctly in certain situations
2019-05-14Added all of the third party links from GN1zsloan
Fixed issue with the script that generates the drop-down menus where phenotype/genotype datasets wouldn't show up for species without any mRNA assay datasets Added icon for smartphones/tablets Made error more informative for main search Added gene symbol column to collections (need to add something that removes the column if it's all empty)
2019-04-04Fixed issue where dataset_menu_structure.json included some groups with no ↵zsloan
visible datasets
2019-04-03Fixed an issue that caused global phenotype search to often not work and ↵zsloan
certain phenotype datasets to not show up in drop-downs
2019-03-27Changed gen_select_dataset.py to be able to show multiple datasets under the ↵zsloan
Phenotype type (for example the GI Tract Metabolome data) Fixed issue where full description was given for some unpublished traits Fixed code related to editing certain pages (like news) with CKEditor, but it still won't work until the CKEditor library is included in GUIX or something
2018-12-05Fixed issue where SNP track for mapping did not appear correctlyzsloan
Updated style for a variety of tables Moved transform/blocking tools for trait sample table into its own tab Added some new customization options to network graph Started work on implementing third party link-outs Updated drop-down generation script to order datasets according to CreateTime
2018-10-01- Can now remove cofactors from correlation scatterplot and select them by ↵zsloan
just clicking their row in collection - Cofactor color picker now works in Safari/Macs - Displays N for relevant samples in trait page sample table - Don't show bar chart when N>256 - Mapping loading page contents better centered - Anonymous collections timeout correctly listed as 30 days now - Minor allele frequency can actually be changed for GEMMA now (previously didn't work) - Fixed transcript position marker location for mapping results - Notifies user if their e-mail isn't associated with an account when they attempt to request forgotten password - Users can now map with submitted traits - Histogram width changes depending upon number of bins (need to improve this still) - Improved Q-q plot (previously called "probability plot")
2018-05-25Fixed issue causing anonymous collections to not work on my branch and ↵zsloan
staging, though still not sure why it's working on production without that change Added script to convert the dryad format genotype files to BIMBAM removed db_uri from parameters of parse_db_uri in gen_select_dataset.py, since it can now just pull it from settings as a global variable
2018-04-16Resolved conflicts after pulling changeszsloan
2018-04-12README and docsPjotr Prins
2018-04-09Removed unused code from get_select_dataset.py and get_group_samplelists.py ↵zsloan
scripts
2017-12-06Fixed drop-down group orderzsloan
2017-12-04Fixed drop-down scripts to more appropriately deal with BXD300 groups ↵zsloan
(though there's still a minor issue with a few datasets) Added some header data to mapping output file Fixed links in Network Group nodes/edges
2017-11-06Replaced Histogram and Bar Chart with Plotly version and added new Box Plot ↵zsloan
with Plotly GEMMA now has option to select genotypes Updated dataset select dropdowns to be ordered correctly Fixed dataset select dropdowns for correlations to not show confidential datasets Added Skewness and Kurtosis to Basic Statistics table Fixed Verify and RNA-seq buttons on trait page Temporarily hardcoded Reference page until we get it to link with database
2017-05-21Merge from the diet branch.Pjotr Prins
* refactored ./bin/genenetwork2 and /etc/default_settings - better detection of Guix - removed unused parameters, such as GEMMA_RESULT_PATH and TEMP_TRAITS - removing some default settings, such as PYLMM_COMMAND - rename some settings, such as SQL_URI and LOG_SQL_ALCHEMY - added GUIX_JS_PATH for JS modules * Added documentation on installing binary GN2 * Updated Twitter board to latest version in Guix - it had broken * Updated many tools in the latest Guix profile
2016-12-12Moved a bunch of functions out of the GeneralTrait class that didn't need to ↵zsloan
be there and changed the code that calls them accordingly Improved loadings plot on the correlation matrix page to look like GN1's figure (though it's vector and GN1's was static) Removed some unused code from show_trait.py changed appearance of table headers some, though needs a little more work Updated dataset_menu_structure.json
2016-09-13Fixed the path for the json file in gen_select_dataset.py since it was wrong ↵zsloan
and uncommented simplejson import Added "Reset" option to network graph that returns all the nodes/edges Made the visualization options area in the network graph a little wider
2016-09-13Run scripts from ./wqflask - just like the webserverPjotr Prins
2016-09-10CommentPjotr Prins
2016-09-10Support for running maintenance scripts so they can pick up all webserver ↵Pjotr Prins
settings Run with ./bin/genenetwork2 ~/my_settings.py -c ./wqflask/maintenance/gen_select_dataset.py
2016-06-19Renamed settings so they are grouped togetherPjotr Prins
2016-06-18Changed file permssions to non-executablePjotr Prins
2016-06-17ConflictPjotr Prins
2016-06-17Removed trailing spaces in .py and .js filesPjotr Prins
2016-06-16Generating the menu is now obsoletePjotr Prins
2016-04-20More hard-codedpjotrp
2016-02-18Edited gen_select_dataset to remove confidential datasetszsloan
Also hard-coded the removal of Macaque Monkey since I couldn't think of a good way to retroactively check if every dataset in a species is confidential
2016-01-29Info button should now work for phenotype and genotype datasetszsloan
2016-01-27Added info button to Dataset dropdown on index pagezsloan
Fixed script that generates dataset dropdown json file to include accession id Fixed dataset link on search results page
2015-05-11Fixed gen_select_dataset so that it does not include Phenotype andzsloan
Genotype groups when the corresponding data sets do not exist Interval Mapping no longer shows up for human traits Fixed the appearance of the mirror links on the main page
2014-06-25Added Karl's correlation matrix codeZachary Sloan
Improved the "scatterplot matrix" feature on the trait page so that it matches the chosen trait against every selected trait
2014-05-05Committing a bunch of changes related to integrating GEMMA andZachary Sloan
adding the correlation matrix page
2013-08-07Fixed things with the dataset dropdowns and mRNA datasetsZachary Sloan
Improved the templates for a couple pages related to changing user password, etc
2013-07-19Created file gen_group_samplelists that iterates through all genofilesZachary Sloan
and builds each groups' samplelist
2013-07-18Added Amelie's rat data genotypesZachary Sloan
Got human mapping mostly working Fixed dataset dropdown menus
2013-07-18Merge branch 'master' of https://github.com/zsloan/genenetworkZachary Sloan
Conflicts: wqflask/base/webqtlConfigLocal.py wqflask/maintenance/gen_select_dataset.py wqflask/wqflask/static/new/javascript/dataset_menu_structure.json
2013-07-18Added to installation notesZachary Sloan
Removed webqtlConfigLocal file containing passwords Updated main page dropdown menus (dataset_menu_structure.json)
2013-07-17Fixed gen_select_dataset.pyZachary Sloan
Appended redis installation info to notes
2012-10-25Got the Make Default option working on the home pageZachary Sloan
2012-10-24Now builds json datastructure for menus correctlyZachary Sloan