Closed Bug 754465 Opened 14 years ago Closed 14 years ago

Create one-command automated update script for Dev/Stage

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: jberkus, Assigned: jberkus)

References

Details

(Whiteboard: [stageDB setup][qa-])

Create a script which can detect which database version stage and dev need to be upgraded to, and then apply those updates. Needed for automated weekly refresh. Requires network flows to be opened per bug: 753009
Blocks: 720755
Code for this has been written and tested on DevDB. Currently awaiting merge of pull request: https://github.com/mozilla/socorro/pull/660
Status update: the script has permissions issues which prevent it from working with auto-refresh. Troubleshooting is on hold due to Rapid Betas.
Script debugged. Pull request here: https://github.com/mozilla/socorro/pull/744 This is now ready to be incorporated into auto-refresh. Documentation for the script is here: https://github.com/jberkus/socorro/blob/master/docs/databasescripts.rst Note: the script need to be run as the user "postgres".
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Whiteboard: [stageDB setup] → [stageDB setup][qa-]
Target Milestone: --- → 18
You need to log in before you can comment on or make changes to this bug.