search

dondi / GRNsight

Web app and service for modeling and visualizing gene regulatory networks.
http://dondi.github.io/GRNsight
BSD 3-Clause "New" or "Revised" License
17 stars 8 forks source link

Data refresh for network database #1022

Closed kdahlquist closed 1 year ago

kdahlquist commented 1 year ago

Let's do a data refresh on the network database since the database was created 2023-03-07.

We are going to preserve the old data for reproducibility. This will be done once the database names are changed and when everyone has to load the data again.

Onariaginosa commented 1 year ago

I tested this on my local database and it worked. Will do so on the production database, once create copies of the database with the appropriate naming scheme as mentioned in #1020

Onariaginosa commented 1 year ago

I dumped the existing database from production and changed the schema names in the dump file. I then loaded them into my local database to test whether it would work properly without altering the existing schemas. Once that worked I loaded the dumped data with the proper schema names into the production database. I then tested the updating scripts on the dumped data in my local database. It worked as expected. I then updated the production database with the new network and it appears to have worked. I updated the documentation for these scripts and a pr is incoming.

kdahlquist commented 1 year ago

confirmed on beta 6.0.7