Initial add of bats tests

trnubo · trnubo · commit c24194b0993c · 2021-07-19T16:14:00.000+10:00
diff --git a/.github/workflows/release.yml b/.github/workflows/release.yml
@@ -0,0 +1,45 @@
+# Source: https://github.com/panubo/reference-github-actions/blob/master/github-release.yml
+
+on:
+  push:
+    tags:
+      - '*'
+
+name: GitHub Release
+
+jobs:
+  build:
+    name: Create GitHub Release
+    runs-on: ubuntu-latest
+    steps:
+
+      - name: Checkout code
+        uses: actions/checkout@v2
+        with:
+          fetch-depth: 0
+
+      - name: Get Release Notes
+        id: get_release_notes
+        run: |
+          NOTES=$(git log --pretty=format:%s $(git tag --sort=-refname | head -1)...$(git tag --sort=-refname | head -2 | tail -1) | awk '{ print "-", $0  }')
+          NOTES="${NOTES//'%'/'%25'}"
+          NOTES="${NOTES//$'\n'/'%0A'}"
+          NOTES="${NOTES//$'\r'/'%0D'}"
+          echo "NOTES: ${NOTES}"
+          echo "::set-output name=notes::${NOTES}"
+
+      - name: Create Release
+        id: create_release
+        uses: actions/create-release@v1
+        env:
+          GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} # This token is provided by Actions, you do not need to create your own token
+        with:
+          tag_name: ${{ github.ref }}
+          release_name: ${{ github.ref }}
+          body: |
+            Changes since last release:
+
+            ${{ steps.get_release_notes.outputs.notes }}
+
+          draft: true
+          prerelease: false
diff --git a/.github/workflows/test.yml b/.github/workflows/test.yml
@@ -0,0 +1,28 @@
+on:
+  push:
+
+name: Run Tests
+
+jobs:
+  build:
+    name: Tests
+    runs-on: ubuntu-latest
+    steps:
+
+      - name: Setup BATS
+        uses: mig4/setup-bats@v1
+        with:
+          bats-version: 1.3.0
+
+      - name: Checkout code
+        uses: actions/checkout@v2
+        with:
+          fetch-depth: 0
+
+      - name: Build image
+        run: |
+          make build
+
+      - name: Tests
+        run: |
+          make test
diff --git a/Makefile b/Makefile
@@ -11,7 +11,7 @@ build-quick:
 	docker build -t $(IMAGE_NAME):$(TAG) .
 
 test:
-	./tests/dind-runner.sh
+	bats -r tests/
 
 push:
 	docker push $(IMAGE_NAME):$(TAG)
diff --git a/tests/00-smoke-test.bats b/tests/00-smoke-test.bats
@@ -0,0 +1,11 @@
+load test_functions.bash
+
+@test "smoke test - select 1" {
+	run docker run --rm \
+		-e DATABASE_HOST=${postgres_container_ip} \
+		-e DATABASE_USERNAME=postgres \
+		-e DATABASE_PASSWORD=password \
+		panubo/postgres-toolbox psql -- -c 'SELECT 1;'
+	diag "${output}"
+	[[ "${status}" -eq 0 ]]
+}
diff --git a/tests/config.sh b/tests/config.sh
diff --git a/tests/create-user-db.bats b/tests/create-user-db.bats
@@ -0,0 +1,25 @@
+load test_functions.bash
+
+@test "create-user-db" {
+	run docker run --rm \
+		-e DATABASE_HOST=${postgres_container_ip} \
+		-e DATABASE_USERNAME=postgres \
+		-e DATABASE_PASSWORD=password \
+		panubo/postgres-toolbox create-user-db myuser myuserpassword
+	diag "${output}"
+	[[ "${status}" -eq 0 ]]
+
+	run docker run --rm \
+		-e DATABASE_HOST=${postgres_container_ip} \
+		-e DATABASE_USERNAME=myuser \
+		-e DATABASE_PASSWORD=myuserpassword \
+		panubo/postgres-toolbox psql -- -c 'SELECT current_database();'
+	diag "${output}"
+	[[ "${status}" -eq 0 ]]
+}
+
+# echo "===> Test create-user-db command"
+# docker run -d --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=password postgres:$POSTGRES_VERSION > /dev/null
+# sleep 5
+# docker run -t -i --name $TEST_NAME --link postgres $TEST_CONTAINER create-user-db foo foopass
+# cleanup postgres $TEST_NAME
diff --git a/tests/drop-user-db.bats b/tests/drop-user-db.bats
@@ -0,0 +1,6 @@
+# echo "===> Test delete-user-db command"
+# docker run -d --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=password postgres:$POSTGRES_VERSION > /dev/null
+# sleep 5
+# docker run -t -i --name ${TEST_NAME}-create --link postgres $TEST_CONTAINER create-user-db foo
+# docker run -t -i --name ${TEST_NAME}-delete --link postgres $TEST_CONTAINER delete-user-db foo
+# cleanup postgres ${TEST_NAME}-create ${TEST_NAME}-delete
diff --git a/tests/functions.sh b/tests/functions.sh
diff --git a/tests/load.bats b/tests/load.bats
@@ -0,0 +1,9 @@
+# echo "===> Test load command"
+# docker run -d --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=password postgres:$POSTGRES_VERSION > /dev/null
+# sleep 5
+# docker run -t -i --name ${TEST_NAME}-create1 --link postgres $TEST_CONTAINER create-user-db foo
+# docker run -t -i --name ${TEST_NAME}-save --link postgres -e DUMP_DIR="/srv" -v /srv:/srv $TEST_CONTAINER save
+# docker run -t -i --name ${TEST_NAME}-delete --link postgres $TEST_CONTAINER delete-user-db foo
+# docker run -t -i --name ${TEST_NAME}-create2 --link postgres $TEST_CONTAINER create-user-db foo
+# docker run -t -i --name ${TEST_NAME}-load --link postgres -e DUMP_DIR="/srv" -v /srv:/srv $TEST_CONTAINER load foo
+# cleanup postgres ${TEST_NAME}-create1 ${TEST_NAME}-save ${TEST_NAME}-delete ${TEST_NAME}-load ${TEST_NAME}-create2
diff --git a/tests/runner.sh b/tests/runner.sh
diff --git a/tests/save.bats b/tests/save.bats
@@ -0,0 +1,6 @@
+# echo "===> Test save command"
+# docker run -d --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=password postgres:$POSTGRES_VERSION > /dev/null
+# sleep 5
+# docker run -t -i --name ${TEST_NAME}-create --link postgres $TEST_CONTAINER create-user-db foo
+# docker run -t -i --name ${TEST_NAME}-save --link postgres -e DUMP_DIR="/srv" $TEST_CONTAINER save
+# cleanup postgres ${TEST_NAME}-create ${TEST_NAME}-save
diff --git a/tests/test.sh b/tests/test.sh
diff --git a/tests/test_functions.bash b/tests/test_functions.bash
@@ -0,0 +1,22 @@
+TOOLBOX_IMAGE="panubo/postgres-toolbox:latest"
+POSTGRES_TARGET_VERSION="12.7"
+
+diag() {
+	echo "$@" | sed -e 's/^/# /' >&3 ;
+}
+
+setup() {
+	# setup runs before each test
+	# Important: we aren't exposing port etc so running tests in parallel works
+	postgres_container="$(docker run -d -e POSTGRES_PASSWORD=password postgres:${POSTGRES_TARGET_VERSION})"
+	postgres_container_ip="$(docker inspect --format '{{ .NetworkSettings.IPAddress }}' ${postgres_container})"
+	docker run --rm -e DATABASE_HOST=${postgres_container_ip} \
+		-e DATABASE_USERNAME=postgres \
+		-e DATABASE_PASSWORD=password \
+		${TOOLBOX_IMAGE} bash -c '. /panubo-functions.sh; wait_postgres ${DATABASE_HOST}'
+}
+
+teardown() {
+	# teardown runs after each test
+	docker rm -f "${postgres_container}"
+}
diff --git a/tests/vaccumdb.bats b/tests/vaccumdb.bats
@@ -0,0 +1,17 @@
+load test_functions.bash
+
+@test "vacuum" {
+	run docker run --rm \
+		-e DATABASE_HOST=${postgres_container_ip} \
+		-e DATABASE_USERNAME=postgres \
+		-e DATABASE_PASSWORD=password \
+		panubo/postgres-toolbox vacuumdb -- --maintenance-db=postgres --all
+	diag "${output}"
+	[[ "${status}" -eq 0 ]]
+}
+
+# echo "===> Test vacuum command"
+# docker run -d --name postgres -p 5432:5432 -e POSTGRES_PASSWORD=password postgres:$POSTGRES_VERSION > /dev/null
+# sleep 5
+# docker run -t -i --name $TEST_NAME --link postgres $TEST_CONTAINER vacuum
+# cleanup postgres $TEST_NAME
