# this Makefile creates sql scripts for different databases
# at the moment it requires the sablotron XSLT processor
xsltcmd = sabcmd
xslpath = ../../common/utils/xml2sql/
src = sample.gsd


all:  mysql pgsql mssql sybase interbase html


mysql:
	${xsltcmd} ${xslpath}mysql.xsl ${src} mysql.xml
	${xsltcmd} ${xslpath}strip.command.xsl mysql.xml mysql.sql

pgsql:
	${xsltcmd} ${xslpath}pgsql.xsl ${src} pgsql.xml
	${xsltcmd} ${xslpath}strip.command.xsl pgsql.xml pgsql.sql
mssql:
	${xsltcmd} ${xslpath}mssql.xsl ${src} mssql.xml
	${xsltcmd} ${xslpath}strip.command.xsl mssql.xml mssql.sql

sybase:
	${xsltcmd} ${xslpath}sybase.xsl ${src} sybase.xml
	${xsltcmd} ${xslpath}strip.command.xsl sybase.xml sybase.sql

interbase:
	${xsltcmd} ${xslpath}interbase.xsl ${src} interbase.xml
	${xsltcmd} ${xslpath}strip.command.xsl interbase.xml interbase.sql
	
html:
	${xsltcmd} ${xslpath}display.xsl ${src} sample.html

setup-pgsql: pgsql
	# createdb gnue
	psql gnue < pgsql.sql
	rm pgsql.sql pgsql.xml

clean:
	rm mssql.xml mysql.xml pgsql.xml sybase.xml *.sql sample.html
