raw.txt
No One
Actions

Authored By

	Kormat
	May 22 2020, 9:00 AM

Size

777 B

Referenced Files

None

Subscribers

None

raw.txt
View Options

	#!/bin/bash

	if [ $# -eq 0 ]; then
	echo "Usage:"
	echo " ${0##*/} FQDN PORT RACK SECTION [SECTION ..]"
	exit 0
	fi

	fqdn=${1:?}; shift
	port=${1:?}; shift
	rack=${1:?}; shift
	sections="$@"

	hostname=${fqdn%%.*}
	name=$hostname
	[ $port -eq 3306 ] \|\| name=$hostname:$port
	dc=$(echo $fqdn \| cut -f2 -d.)

	set -exu
	{
	echo "START TRANSACTION;"
	echo "INSERT INTO instances (name, server, port) VALUES ('$name', '$fqdn', $port);"
	echo "INSERT INTO servers (fqdn, hostname, dc, rack) VALUES ('$fqdn', '$hostname', '$dc', '$rack');"
	for i in $sections; do
	echo "INSERT INTO section_instances (instance, section) VALUES ('$name', '$i');"
	done
	echo "COMMIT;"
	} \| sudo -i mysql.py -BE -h db2093 zarcillo