1
#!/bin/bash
2
3
# live fast! die young!
4
5
set -e
6
7
source /etc/statusnet/setup.cfg || (echo "Failed to read /etc/statusnet/setup.cfg"; exit -1)
8
9
export nickname=$1
10
if [ "x" == "x$nickname" ]
11
then
12
    echo "Usage: delete_status_network.sh <site-nickname>"
13
    exit 1
14
fi
15
16
export database=$nickname$DBBASE
17
18
# Pull the status_network record so we know which DB server to drop from...
19
TARGET_DBHOST=`mysql -h $DBHOST -u $ADMIN --password=$ADMINPASS $SITEDB --batch --skip-column-names -e \
20
  "select dbhost from status_network where nickname='$nickname'"`
21
22
if [ "x" == "x$TARGET_DBHOST" ]
23
then
24
    echo "Aborting: Could not find status_network record for site $nickname"
25
    exit 1
26
fi
27
28
# Drop the database
29
echo "Dropping $database from $TARGET_DBHOST..."
30
mysqladmin -h $TARGET_DBHOST -u $ADMIN --password=$ADMINPASS -f drop $database || exit 1
31
32
# Remove the status_network entry
33
echo "Removing status_network entry for $nickname..."
34
mysql -h $DBHOST -u $ADMIN --password=$ADMINPASS $SITEDB -e \
35
    "delete from status_network where nickname = '$nickname'" || exit 1
36
37
# Remove uploaded file areas
38
for top in $AVATARBASE $FILEBASE $BACKGROUNDBASE; do
39
    if [ "x" == "x$top" ]
40
    then
41
        echo "Skipping deletion due to broken config"
42
    else
43
        echo "Deleting $top/$nickname"
44
        rm -Rf "$top/$nickname"
45
    fi
46
done
47
48
echo "Done."