Example of task runner that set up and tear down circle_test database. I use this commands when running test in CircleCI.

Makefile

test:
	npm install --dev
	mysql -u ubuntu -e 'CREATE DATABASE IF NOT EXISTS circle_test'
	mysql -u ubuntu circle_test < test_database.sql
	node_modules/vows/bin/vows some-test/*-spec.js
	mysql -u ubuntu circle_test < test_database.sql
	node_modules/vows/bin/vows another-test/*-spec.js
	mysql -u ubuntu -e 'DROP DATABASE IF EXISTS circle_test'