Gaofei Zhao

Results 25 issues of Gaofei Zhao

When testing v6 on a saml authenticated portal, we noticed that the [studies/tags](https://github.com/cBioPortal/cbioportal/blob/master/src/main/java/org/cbioportal/web/StudyController.java#L197) endpoint is very slow for portal with a large study set. I tested different queries and found...

Fix cBioPortal/icebox#469 cBioPortal/cbioportal#10411 This pr fixes two things: 1. The scheme is out of sync between `cgds.sql` and `migration.sql`, sync it again 2. Put a limit on `VALUE` field in...

Partial Fix cBioPortal/icebox#570 Describe changes proposed in this pull request: - Adding a new repository function: `getGenericAssayAdditionalpropertiesByMolecularProfileId`, this function will reduce the ids in the SQL query and in some...

performance

- [x] Test MySQL connection (also test MySQL 8 database) - [x] EKS cluster creation - [x] Documentation and deployment files updates - [x] Deploy certificate apps - [x] Move...

Improve data validation tests on the DataHub repository. The current data validation process might exceed the one-hour circle ci limit easily (e.g. https://app.circleci.com/pipelines/github/cBioPortal/datahub/4379/workflows/6569d7ea-fc77-4b2c-9e89-7337ac6158d3/jobs/11131). Converting validation test from circle ci to...

Prepare HLA and LOH-HLA data for 40k study: LOH-HLA data: make script to generate LOH-HLA data - For patients with multiple normals, keep the one has TRUE in `use_for_patient_level_genotype` column....

Fix # (see https://help.github.com/en/articles/closing-issues-using-keywords) Describe changes proposed in this pull request: - a - b # Checks - [ ] The commit log is comprehensible. It follows [7 rules of...

this is an issue for some comparison tabs (e.g. Generic Assay Categorical/Binary tab, mRNA, Protein) Some tabs look good, eg Clinical, Genomic alterations & Mutations: Some tabs need update: