aboutsummaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2022-04-14Provide db port when presentFrederick Muriuki Muriithi
Sometimes the system uses a port to connect to the database, rather than a socket, so if the port is present, provide it as part of the connection arguments.
2022-04-14Trigger the CI after mariadb restartFrederick Muriuki Muriithi
2022-04-14Use `MySQLdb.connect` rather than `MySQLdb.Connect`Frederick Muriuki Muriithi
2022-04-14Debug: Add logging to track db connection creation and stoppingdebug-too-many-connections-errorFrederick Muriuki Muriithi
As part of debugging the "Too many connections" error to the database, this commit adds logging to track the creation of connections to the database, and their eventual closing.
2022-04-12Replace get_allowable_sampledata_headers with get_case_attributesBonfaceKilz
* wqflask/wqflask/metadata_edits.py: Remove "get_allowable_sampledata_headers" import. (display_phenotype_metadata): Use "get_case_attributes" to fetch all the allowable case attributes.
2022-04-12List out case-attrs from database; and add link to case-attr pageBonfaceKilz
2022-04-12Don't create db engine for static filesFrederick Muriuki Muriithi
There is no need to create a database engine for requests for static files like CSS files and javascript files. This commit checks for and skips the creation of the engine for such requests.
2022-04-12Remove unused database codeFrederick Muriuki Muriithi
Remove code for connecting to the database that is not actually used in the application in any sensible form.
2022-04-07Add submit buttons to the top of the edit pageBonfaceKilz
2022-04-07Fix "Pubmed" spelling to "PubMed"BonfaceKilz
2022-04-07Add left space to content by making the "form" a containerBonfaceKilz
2022-04-07Remove ":" after a headerBonfaceKilz
2022-04-07Make case-attribute table a "data table"BonfaceKilz
2022-04-07Pass missing "conn" when getting case attributesBonfaceKilz
* wqflask/wqflask/metadata_edits.py (show_case_attribute_columns): Create a connection and pass it to "get_case_attributes".
2022-04-07Run python-black on fileBonfaceKilz
* wqflask/wqflask/metadata_edits.py: Run "black -l 79 wqflask/wqflask/metadata_edits.py"
2022-04-07Create a new page to display case-attributes and their descriptionsBonfaceKilz
* wqflask/wqflask/metadata_edits.py: Import "gn3.db.sample_data.get_case_attributes". (show_case_attribute_columns): New function/ end-point to show case-attributes. * wqflask/tests/integration/wqflask/test_metadata_edits.py: New integration tests for the above. * wqflask/tests/integration/wqflask/__init__.py: New file. * wqflask/wqflask/templates/case_attributes.html: New template file to display the above.
2022-04-06Changed some styling for the edit_phenotype templatezsloan
2022-04-05Fix combined searches involving aliaseszsloan
The logic for building the SQL query wasn't working correctly when aliases were involved. The query also checks for a gene symbol's aliases in the DB, but this wasn't properly handling the AND/OR logic, leading to no results being shown when doing a "Get Combined" search involving a gene symbol. This also removed some unused code related to aliases.
2022-04-04Return None in load_json_from_redis when the item doesn't existzsloan
For some reason that isn't clear to me yet, a logged-in user session ID was set even when a user wasn't logged in, causing the user session code to attempt to fetch user information for a non-existent user ID
2022-04-04Change UserSession to properly remove user session ID when not logged inzsloan
It's not entirely clear to me exactly why the previous logic wasn't working correctly, but this change (that removes the user cookie when there's no user_session after the request and returns None if there aren't any user_details) appears to fix the issue. The main confusing part is why the user_cookie still exists even when not logged in
2022-04-01Fix the way database_connection was being called in 2 places inzsloan
metadata_edits.py For some reason there were two places where it wasn't being called as a function. Fixing this appears to have fixed the error
2022-03-31Add another check for >1 markers on a chromosome for interval mappingzsloan
There were two places this needed to be checked and I previously missed this one
2022-03-31Replace 'User Account Settings' with user's e-mail and add user_emailzsloan
property to user_session Also changed the order of the dropdowns to have Sign Out after the user drop-down, to more closely match NCBI's style
2022-03-31Fix the way database_connector is calledzsloan
The function returns a call to mdb.connect, which only returns the connection object. It was throwing an error due to trying to unpack multiple items. One thing I noticed while looking at this is that we should probably decide on a single way to create these connections. In some other files, we instead use database_connection from wqflask.database (instead of the gn3 database_connector from gn3.db_utils)
2022-03-30Merge pull request #690 from Alexanderlacuna/chore/ctl-wgcna-enhancementsAlexander Kabui
Chore/ctl wgcna enhancements
2022-03-30Remove double-encoding to jsonFrederick Muriuki Muriithi
Passing the data into `requests.post` as a `json=...` argument will automatically encode the data to JSON and set up the correct Content-Type header. The call `json.dumps(post_data)` was pre-encoding the data to a JSON string, that was the re-encoded to JSON yet again, which is not what we want. This commit fixes that.X
2022-03-25Fix Spearman Rank correlation appearing as 'r' instead of 'rho'zsloan
2022-03-25Fix issues that prevented genotype traits from being added to collectionszsloan
Some of this was caused by heatmaps supporting code; that code should probably pass the traits differently than the way it does in the "trait_info_str" function
2022-03-24Merge pull request #691 from zsloan/bug/fix_qtlreaper_snp_orderzsloan
Bug/fix qtlreaper snp order
2022-03-24Check if there's only one coordinate for interval mappingzsloan
This is meant to deal with edge cases where there's only a single coordinate for a chromosome when doing interval mapping (which causes an error, since interval mapping requires that markers be linked within each chromosome)
2022-03-24Fix qtlreaper results sorting to deal with M as chromosome (should be at the ↵zsloan
end) Not sure how best to do this; I just had the sort algorithm change "M" to "z" (which will always be sorted last, behind X and Y)
2022-03-24code refactoringAlexander Kabui
2022-03-24display parametric values usedAlexander Kabui
2022-03-24rename template to gn3_wgcna_resultsAlexander Kabui
2022-03-22Merge pull request #608 from zsloan/feature/add_rqtl_pairscanzsloan
Feature/add rqtl pairscan
2022-03-22Fix logic for setting interval parameterzsloan
The parameter should never be interval if pair_scan is being run; not checking for this causes the --interval tag to pointlessly be included when running pair-scan, which also interferes with caching
2022-03-22Fix way pair_scan is checkedzsloan
Previously it would always register as True, due to being in the start_vars
2022-03-22Set pair_scan to false when using regular R/qtl mappingzsloan
2022-03-22Change d3panels CSS/JS to min fileszsloan
2022-03-22Merge remote-tracking branch 'origin/testing' into feature/add_rqtl_pairscanzsloan
2022-03-21Fix command in documentationFrederick Muriuki Muriithi
Add missing argument to the command in the documentation
2022-03-18README: Update CI badge subdomain.Arun Isaac
The CI has been migrated from penguin2.genenetwork.org to ci.genenetwork.org. * README.md: Update CI badge subdomain.
2022-03-18Merge pull request #689 from Alexanderlacuna/chore/gn2-enhancementsAlexander Kabui
Chore/gn2 enhancements
2022-03-18add uniform font for titleAlexander Kabui
2022-03-18remove correlation test buttonAlexander Kabui
2022-03-18fixes for ImageButtonOptionsAlexander Kabui
2022-03-18code to fetch scree data from gn3Alexander Kabui
2022-03-18integrate scree plotAlexander Kabui
2022-03-18Merge pull request #671 from Alexanderlacuna/feature/gn3-pcaAlexander Kabui
Replace pca rpy2 code
2022-03-18Apply "python-black" on fileBonfaceKilz
* test/requests/test-website.py: Run "black test/requests/test test-website.py".