search

uchicago-capp-30320 / new-arrivals-chi

GNU Affero General Public License v3.0
9 stars 0 forks source link

(feat): Create test db #296

Open CaitlinCP opened 2 months ago

CaitlinCP commented 2 months ago

Describe the feature

In order to build and test db changes, it would be best if we had a test db that we utilized before deploying to prod.

Requirements

-- Set up a test db on the digital ocean instance -- Update credential files to point to test db -- Update current alembic migration workflow documentation to incorporate the process of developing against a test db

CaitlinCP commented 2 months ago

Hi @jamesturk -- I just wanted to check in. Were you able to set up a test db? No rush if not!

jamesturk commented 2 months ago

I'm sorry-- this got buried in GH notifications, thanks for re-pinging. I'm doing this today and will post by EOD.

jamesturk commented 2 months ago

OK this was actually really quick, sorry again for delay-- I've set it up so the existing user can access the staging database. (If you prefer a different user I can do that too, but this is most straightforward for now probably.) Just change the database name to newarrivals_staging and you have a fresh database. Let me know if you hit any permissions issues.

jamesturk commented 2 months ago

(feel free to close this once confirmed working)