# PgSQL
SQLCMD=/usr/bin/psql
DBDUMP=/usr/bin/pg_dump
SCHEMA=db/schema-pgsql.sql

# MySQL
# SQLCMD=/usr/bin/mysql
# DBDUMP=/usr/bin/mysqldump
# SCHEMA=db/schema-mysql.sql

HOST=localhost
USER=nsrc_loc
DB=nsrc_loc
DATA=db/basic-data.sql
DATA_TBL=kind

default:
	@echo "targets:"
	@echo
	@echo "  dbinit  - nuke and recreate the DB"
	@echo "  dbload    - reload basic data"
	@echo "  dbdump  - take a dump of the DB"

dbinit:
	@echo 'drop database $(DB)' | $(SQLCMD) -h $(HOST) -U $(USER) template1
	@echo 'create database $(DB)' | $(SQLCMD) -h $(HOST) -U $(USER) template1
	@$(SQLCMD) -h $(HOST) -U $(USER) $(DB) < $(SQLSCHEMA)
	
dbload:
	@echo 'truncate table $(DATA_TBL) ' | $(SQLCMD) -h $(HOST) -U $(USER) $(DB)
	@$(SQLCMD) -h $(HOST) -U $(USER) $(DB) < $(DATA)

dbdump:
	@$(PGDUMP) -i -h $(HOST) -U $(USER) $(DB) >db/dump.sql