TABLE=waftbl
PLOT=wafpng

#XML_OPT=-l list_all
XML_OPT=-l list_wrk
#XML_OPT=-w waf_240_070720_00

DIR=wtmp

all: csv sql instab sqlplt insplt impplt

#Read all xml files in the wafer directories specified in <list_with_waferdirs>:

csv:
	rm -rf $(DIR)
	mkdir $(DIR)
	xmldumpw $(XML_OPT) -o $(DIR)/

#This program creates the .csv file. The first line is for Excel only, the second contains the mysql variable names, the third contains 
#the mysql variable types.

sql:
	csv2sql $(DIR)/xmlwtab.csv $(TABLE)

#This program creates init_table.sql and insert_values.sql.
#init_table.sql is necessary only at the beginning.

#deltab:
#	mysql trap < "DELETE FROM trap.$(TABLE);" -p

instab:
	#mysql trap < init_table.sql -papril17
	mysql trap < insert_values.sql -papril17


# The same for the plot database
sqlplt:
	csv2sql $(DIR)/xmlwplt.csv $(PLOT)

#delplt:
#	mysql trap < "DELETE FROM trap.$(PLOT);" -p

insplt:
	#mysql trap < init_table.sql -papril17
	mysql trap < insert_values.sql -papril17

impplt:
	./insert_plot_wafer.pl

.PHONY : sql sqlplt delplt insplt ompplt deltab instab csv clean