aboutsummaryrefslogtreecommitdiff
path: root/flyway+.sh
blob: 255c79932236b14d9abcadfcd91a4342c84e9e61 (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
#!/bin/sh

directory=$(search V*.sql | grep -Eo ".*/common/" | head -1)
last_version=$(search V*.sql | grep src/main | sed 's|.*/||g' | grep -E '^V' | sed 's/__.*//' | sort -V -u -r | head -1)

v1=`echo $last_version | sed 's/V//' | sed -E 's/\..*//'`
v2=`echo $last_version | sed 's/V//' | sed -E 's/[^\.]+\.(.*)\..*/\1/'`
v3=`echo $last_version | sed 's/V//' | sed -E 's/.*\.(.*)$/\1/'`

if [ -z $1 ]; then
    v3=`expr $v3 + 1`
else
    case $1 in
        M)
            v1=`expr $v1 + 1`
            v2=0
            v3=0
        ;;
        m)
            v2=`expr $v2 + 1`
            v3=0
        ;;
    esac
fi

new_version="V$v1.$v2.$v3"
echo $last_version" -> "$new_version
name=$directory$new_version"__New_migration.sql"

echo -n "" | 9p write acme/new/body
last=$(9p ls acme | sort -g | tail -n 1)
echo "name $name" | 9p write acme/$last/ctl