PG Snapshot
Small tool to create a snapshot of an actual node-pg query in JSON format. It helps to write fixtures data for unit testing
Usage
pg-snapshot reads connection data from env
- PGUSER
- PGHOST
- PGDATABASE
- PGPASSWORD
and sql command from stdin. Enter twice to send the query.
Example
PGHOST=my_pg_server_hostname PGPASSWORD=my_password PGDATABASE=my_db_name PGUSER=dba node index.js
SELECT * FROM MY_TABLE
WHERE awesomeness >= 9000
<enter>
<enter>
QUERYING
WRITING TO DISK
DONE
closing PG connection pool on exit
after the command completes, you will have a json file at the working dir. And that's it