Makefile

BUILD_DIR=builds
VERSION=0.2.2
GIT_SHA=$(shell git rev-parse --short HEAD)
PASSWORD=root
MSPASS=zebra-IT-32

DOCKER_MYSQL=mysql/mysql-server:5.7
DOCKER_POSTGRES=postgres:9.6
DOCKER_MSSQL=microsoft/mssql-server-linux
DB_NAME=testdb

build:
	mkdir -p $(BUILD_DIR) 
	docker pull karalabe/xgo-latest
	go get github.com/karalabe/xgo
	xgo -dest=$(BUILD_DIR) \
	-ldflags="-X main.version=$(VERSION) -X main.gitSHA=$(GIT_SHA)" \
	-targets="darwin-10.10/* windows-8.0/amd64 windows-8.0/386 linux/amd64 linux/386" .

pull-docker-images:
	docker pull ${DOCKER_MYSQL}
	docker pull ${DOCKER_POSTGRES}
	docker pull ${DOCKER_MSSQL}

run-containers:
	docker rm -f sd-mysql sd-postgres sd-mssql || true
	docker run --name sd-mysql -e MYSQL_ROOT_PASSWORD=${PASSWORD} -p 3307:3306 -d ${DOCKER_MYSQL} || true
	docker run --name sd-postgres -e POSTGRES_PASSWORD=${PASSWORD} -p 5433:5432 -d ${DOCKER_POSTGRES} || true
	docker run --name sd-mssql -e ACCEPT_EULA=Y -e SA_PASSWORD=${MSPASS} -p 1433:1433 -d ${DOCKER_MSSQL} || true

setup-db:
	# Mysql ensure root can access from anywhere
	docker exec -it sd-mysql mysql -uroot -proot -e "CREATE USER 'root'@'%' IDENTIFIED BY '${PASSWORD}'" || true
	docker exec -it sd-mysql mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'" || true
	docker exec -it sd-mysql mysql -uroot -proot -e "CREATE DATABASE ${DB_NAME};" || true
	# Postgres db creation
	docker exec --user postgres -it sd-postgres psql -c "CREATE DATABASE ${DB_NAME}" || true
	# MSSQL db creation
	docker exec -it sd-mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P ${MSPASS} -Q "CREATE DATABASE testdb" || true

test:
	MYSQL_URL="root:${PASSWORD}@tcp(localhost:3307)/testdb?parseTime=true" \
	POSTGRES_URL=postgres://postgres:${PASSWORD}@localhost:5433/testdb?sslmode=disable \
	MSSQL_URL="odbc:server=localhost;port=1433;user id=sa;password=${MSPASS};database=${DB_NAME}" \
	go test ./... -v | grep -v 'vendor'