#!/usr/bin/perl
#    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

use strict;
use warnings;

my @TABLES;

print "# This file is automatically generated (by fk.pl). DO NOT EDIT.\n";

while(<>) {
	# start a new rule for each table
	if(m/\bCREATE\s+TABLE\s+(IF NOT EXISTS )?`?(\w+)/i) {
		print "\n$2.t : $2.sql";
		push @TABLES, "$2.t";
	}
	# handle foreign key reference specifications
	elsif(m/\bREFERENCES\s+`?(\w+)/i) {
		print " $1.t";
	}
}

# add a final rule collecting all tables
print "\n\n.PHONY : all-tables\n\nall-tables : @TABLES\n";