blob: 5e221a85b5eaa0b0e7defc3af5a0a754a44e7fc1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
#!/bin/bash
set -ae
echo "Stopping Apache."
sudo service apache2 stop
newname=freeside_test_`date +%Y%m%d`
if psql -l |grep -q '^ *freeside '; then
if psql -l |grep -q $newname; then
echo "Deleting old test database $newname."
dropdb "$newname"
fi
echo "Renaming test database to $newname."
psql postgres -c "ALTER DATABASE freeside RENAME TO $newname"
fi
if (sudo grep -q '^test:' /usr/local/etc/freeside/htpasswd); then
newhtpasswd=htpasswd_test_`date +%Y%m%d`
echo "Renaming htpasswd to $newhtpasswd."
sudo mv /usr/local/etc/freeside/htpasswd /usr/local/etc/freeside/$newhtpasswd
oldhtpasswd=$( cd /usr/local/etc/freeside; \
ls |grep -P 'htpasswd_\d{8}' | \
sort -nr |head -1 )
if [ -f $oldhtpasswd ]; then
echo "Renaming $oldhtpasswd to htpasswd."
sudo mv /usr/local/etc/freeside/$oldhtpasswd \
/usr/local/etc/freeside/htpasswd
fi
fi
oldname=$( psql -tl | \
cut -d '|' -f 1 | \
tr -d ' ' | \
grep -P 'freeside_\d{8}' | \
sort -nr | head -1 )
if [ -n "$oldname" ]; then
echo "Renaming $oldname to freeside."
psql postgres -c "ALTER DATABASE $oldname RENAME TO freeside"
fi
echo "Done."
|
