summaryrefslogtreecommitdiff
path: root/contrib/docker/piwik/mysql-ctl.sh
blob: 49e48089c7b84fb8d53710368025656b1c6aacbb (plain) (blame)
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
#!/bin/sh

set -e

NAME="sfive-mysql"
IMG="mysql"
ROOT_PWD="NyDg7Eoa1gNJUMwhVqmA"
PERSIST_D="/srv/build/sfive/mysql"

create() {
  mkdir -p "$PERSIST_D/data"
  sudo docker run --detach --rm --name "$NAME" -e MYSQL_ROOT_PASSWORD="$ROOT_PWD" -v "$PERSIST_D/data:/var/lib/mysql" "$IMG:$1"
}

stop() {
  sudo docker stop "$NAME"
}

logs() {
  sudo docker logs "$NAME" $@
}

client() {
  sudo docker exec -it "$NAME" mysql -p"$ROOT_PWD"
}

case "$1" in
  create)
    if [ -z "$2" ]; then
       echo "Please specify a version"
       exit 1
    fi
    create "$2"
    ;;
  stop)
    stop
    ;;
  upgrade)
    if [ -z "$2" ]; then
       echo "Please specify a version"
       exit 1
    fi
    tag="$2"
    sudo docker pull "$IMG:$tag"
    stop
    create "$tag"
    ;;
  logs)
    shift
    logs $@
    ;;
  client)
    shift
    client $@
    ;;
  *)
    echo "Usage $0 (create|stop|upgrade|logs|client)"
    exit 1
    ;;
esac

exit 0