feature: restoredb from backup script - Githubissues

cisagov / cset

Cybersecurity Evaluation Tool

MIT License

1.36k stars 240 forks source link

feature: restoredb from backup script #3945

Closed itsmostafa closed 3 weeks ago

itsmostafa commented 3 weeks ago

fix sql script for restoring database

🗣 Description

The sql script will drop any active connections and then restore CSETWeb database from the latest backup dropped in the backups/ directory

💭 Motivation and context

🧪 Testing

tested locally

✅ Pre-approval checklist

[x] This PR has an informative and human-readable title.
[x] Changes are limited to a single goal - eschew scope creep!
[x] I have read the CONTRIBUTING document.
[x] These code changes follow cisagov code standards.
[x] All new and existing tests pass.