ndev

#!/usr/bin/env bash

STAGE_ONE="jraph_build"
STAGE_TWO="jraph"
IMAGE_NAME="$STAGE_TWO:latest"
LOCAL_URL="localhost:5000"

TEST_DATABASE="testdb"
JRAPH_DATABASE="jraph"
JRAPH_SERVICE_UNIT="jraph-app.service"

DROPLET_URL="jraph.nathanielhtaylor.com"
DROPLET_ID="444418486"

_check_pass () {
	if [[ ! -v JRAPH_SA_PASSWORD ]]; then
		echo "\$JRAPH_SA_PASSWORD required!"
		exit 1
	fi
}

build.stage_one () {
	echo "creating $STAGE_ONE"
	podman create \
		--env-file=".env" \
		--memory="2g" \
		--name="$STAGE_ONE" \
		--workdir="/root" \
		--interactive \
		--tty \
		--publish-all \
		--replace \
		--volume="./:/root/jraph:Z" \
		"fedora:latest" \
		"jraph/install-sqlserver.sh"

	echo "starting $STAGE_ONE"
	podman start --attach --interactive $STAGE_ONE
	# TODO make it so sqlserver doesn't try to start at the end of 
	# the msql configuration process
	
	echo "committing $STAGE_ONE to $IMAGE_NAME"
	podman commit \
		--change CMD=/opt/mssql/bin/sqlservr \
		$STAGE_ONE \
		$IMAGE_NAME
}

build.stage_two () {
	echo "creating local jraph container $STAGE_TWO"
	podman create \
		--env-file=".env" \
		--interactive \
		--tty \
		--publish 127.0.0.1:5000:5000 \
		--volume="./:/root/jraph:Z" \
		--name="$STAGE_TWO" \
		--replace \
		"$IMAGE_NAME"
}

build () {
	# TODO REDO using CONTAINERFILE
	# TODO mssql-server and jraph service on startup 
	# TODO configgify msql setup options
	build.stage_one
	build.stage_two
}

# start a shell inside the local running jraph service container
# $ ./ndev loc
loc () {
	podman exec --interactive --tty \
		$STAGE_TWO /bin/bash
}

loc.ipy () {
	podman exec --interactive --tty \
		$STAGE_TWO /bin/sh /root/jraph/devops/start-ipy-term.sh
}

loc.start.server () {
	podman start "$@" $STAGE_TWO
}

loc.start () {
	podman exec --interactive --tty $STAGE_TWO \
		jraph/devops/run-dev.sh
}

loc.test.sqlserver () {
	_check_pass
	podman exec --interactive --tty \
		$STAGE_TWO \
		/opt/mssql-tools18/bin/sqlcmd \
			-C -U sa -P $JRAPH_SA_PASSWORD \
			-i /root/jraph/lib/sql/testdb-init.sql 
}

# start a shell in the running jraph droplet
# $ ./ndev doc
doc () {
	ssh root@$DROPLET_URL
}

# turn power for droplet on or off
# $ ./ndev doc.power on|off
doc.power () {
	doctl compute da power-$1 $DROPLET_ID
}

# push all run files to digital ocean 
# $ ./ndev doc.sync
doc.sync () {
	rsync -av --delete \
		--exclude=__pycache__/ \
		--exclude=.git/ \
		--exclude=.gitignore \
		--exclude=*.EXAMPLE \
		--exclude=ndev \
		--exclude=README.md \
		./ root@$DROPLET_URL:/root/jraph
}

doc.start () {
	ssh root@$DROPLET_URL "systemctl start $JRAPH_SERVICE_UNIT"
}

doc.stop () {
	ssh root@$DROPLET_URL "systemctl stop $JRAPH_SERVICE_UNIT"
}

doc.logs () {
	ssh root@$DROPLET_URL "journalctl --follow --unit $JRAPH_SERVICE_UNIT"
}

doc.kill () {
	ssh root@$DROPLET_URL "pkill flask"
}

doc.compare () {
	echo "COMPARE"
	LOCAL_DIST=$PWD
	REMOTE_DIST=scp://root@jraph.nathanielhtaylor.com/jraph
	CACHED_REMOTE_DIST=/tmp/jraph.remote

	if [[ -d $CACHED_REMOTE_DIST ]]; then
		echo "clearing cache..."
		rm -rf $CACHED_REMOTE_DIST
	fi

	echo "copying $REMOTE_URI to $CACHED_REMOTE_DIST to compare..."
	scp -r $REMOTE_DIST $CACHED_REMOTE_DIST
	echo "diffing folders"
	diff --color=always -r $LOCAL_DIST $CACHED_REMOTE_DIST
}

doc.sqlcmd () {
	_check_pass
	podman exec --interactive --tty \
		$STAGE_TWO \
		/opt/mssql-tools18/bin/sqlcmd \
			-C -U sa -P $JRAPH_SA_PASSWORD \
			-S $DROPLET_URL \
			-d $JRAPH_DATABASE 
			# -q "select * from node where node_id=1"
}

# TODO create help function which lists functions and their docstrings
# Has ability to limit to one docstring e.g.
# $ ndev --help **prints all docstrings**
# $ ndev build --help **prints build docstring**
if [[ $# -eq 0 ]]; then
	echo "available ndev functions..."
	grep -oP '^[^_][\w\.]+ \(\)' $0 | sort 
	exit 0
fi

"$@"