Commitbd24cbd

committed

Add script to update Mapit database

1 parent812ecaf commitbd24cbdCopy full SHA for bd24cbd

File tree

+25

-0

lines changed

+25

-0

lines changed

Lines changed: 1 addition & 0 deletions

Lines changed: 24 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,24 @@`
	`1`	`+fromfabric.apiimporttask,settings,sudo,env`
	`2`	`+fromfabric.tasksimportexecute`
	`3`	`+`
	`4`	`+importapp`
	`5`	`+importnginx`
	`6`	`+importpuppet`
	`7`	`+`
	`8`	`+@task`
	`9`	`+defupdate_database():`
	`10`	`+"""Update a Mapit database using a new database dump"""`
	`11`	`+`
	`12`	`+iflen(env.hosts)>1:`
	`13`	`+exit('This command should only be run on one Mapit machine at a time')`
	`14`	`+`
	`15`	`+execute(nginx.gracefulstop)`
	`16`	`+execute(app.stop,'mapit')`
	`17`	`+sudo('service collectd stop')`
	`18`	`+`
	`19`	`+sudo('rm /data/vhost/mapit/data/mapit.sql.gz')`
	`20`	`+`
	`21`	`+withsettings(sudo_user='postgres'):`
	`22`	`+sudo("psql -c 'DROP DATABASE mapit;'")`
	`23`	`+`
	`24`	`+execute(puppet.agent,'--test')`

Comments

(0)