Push to production site with versioned tables and views

Description

I opened a PR to point the staging site to table/view versions. https://github.com/Sage-Bionetworks/portals/pull/438/files

Once this is merged, we can push the site to production. Hooray!

Environment

None

Activity

Show:
Kelsey Montgomery
September 18, 2020, 4:47 PM

Re-opening as the production site is currently pointing to the synId and not the version 1 of the synId.

Requires further testing as the addition of a version was causing a failure:

{"reason":"Unknown column 'syn21754060.1' in 'where clause' Note: If a column name contains spaces, punctuation, or SQL key words, then the name must be enclosed in double quotes. See https://rest-docs.synapse.org/rest/org/sagebionetworks/repo/web/controller/TableExamples.html"}

Jay Hodgson
September 18, 2020, 11:04 PM

Updated the parser to insert the where clause in the correct location when are selecting from a versioned entity.
https://github.com/Sage-Bionetworks/Synapse-React-Client/pull/701

Jay Hodgson
September 18, 2020, 11:04 PM

Reintroduced the table/view versions in the PsychENCODE config: https://github.com/Sage-Bionetworks/portals/pull/442/files

Kelsey Montgomery
October 5, 2020, 8:22 PM

Incremented versions to latest in .

Jay Hodgson
October 5, 2020, 9:03 PM

Merged.

Assignee

Jay Hodgson

Reporter

Kelsey Montgomery

Labels

Validator

Kelsey Montgomery

Development Area

Portals

Release Version History

None

Sprint

None

Priority

Major
Configure