#    This file is part of fk, a method for using UNIX 'make' to help
#    create schema which have foreign key constraints.
#
#    Copyright (C) 2009 Toby Thain, toby@telegraphics.com.au
#
#    This program is free software; you can redistribute it and/or modify
#    it under the terms of the GNU General Public License as published by  
#    the Free Software Foundation; either version 2 of the License, or
#    (at your option) any later version.
#
#    This program is distributed in the hope that it will be useful,
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#    GNU General Public License for more details.
#
#    You should have received a copy of the GNU General Public License  
#    along with this program; if not, write to the Free Software
#    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA


# MySQL credentials with power to CREATE DATABASE.
ROOT ?= -u root

# MySQL database name
DB ?= fk_test

MYSQL = mysql -B $(ROOT) $(DB)


## Targets.

.PHONY : all clean create

all : create all-tables

clean :
	rm -fr tables.mk *.t

create :
	mysqladmin $(ROOT) create $(DB)


## Handle foreign key dependencies.

ifneq ($(MAKECMDGOALS),clean)
-include tables.mk
endif

vpath %.sql sql

# we don't physically create the .t file
%.t : %.sql
	$(MYSQL) < $<

# Extract dependencies into a Makefile.
tables.mk : sql/*.sql
	perl fk.pl $^ > $@