OWASP / OpenCRE

https://opencre.org
Creative Commons Zero v1.0 Universal
77 stars 33 forks source link

Auto data health checks #149

Open northdpole opened 2 years ago

northdpole commented 2 years ago

once the auto-backups are in place create an action that downloads the latest database from heroku and compares it to the latest known good state. If the known good state data isn't equivalent to the heroku ones, fail.

This might be possible by just dumping dbs, filtering out heroku custom things and checking for string equivalence

northdpole commented 2 years ago

problem: known good state needs to be a heroku backup, it cannot be a local sqlite situation. ideally local dev would also be a postgresql container, this would make data migration pretty trivial.