Happy New Year everyone!
I think I have overheard some different techniques for DB diffing to the IHP fixtures on Slack, so hope someone has some input.
Does anyone know of a good way to import the database in production and hydrate the local dev environment with this data?
The usecase is more specifically that I have some items from a table that I need to have synced locally to test certain things locally without having to manually consolidating the data all the time.
Cool, thanks for sharing!
I have a script named
And inside the script:
#!/usr/bin/env bash DATABASE_URL="" pg_dump "$DATABASE_URL" -a --inserts --column-inserts --disable-triggers | sed -e '/^--/d' >Application/Fixtures.sql # Import Fixtures make db # Dump Fixtures make dump_db
Notice that the
DATABASE_URL variable should have your database URL with user and password.
Nice! That's perfect!
I found a half-decent way
Just opened the IHP Cloud database via the Beekeeper Studio client, exported a SQL dump of that table, inserted into
Fixtures.sqlfile and ran
make dbin nix-shell.
Works well enough for my usecase 👍