TABLE=mcmtbl
PLOT=mcmpng

#XML_OPT=-d 060401 -n 30000 -N 79999
XML_OPT=-d 101101 -n 80000 -N 89999

#DIR=all_mcms_dly
DIR=update


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

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

all: csv sql instab sqlplt insplt impplt

#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)/xmltab.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

#mcmtab is the name of the table

# The same for the plot database
sqlplt:
	csv2sql $(DIR)/xmlplt.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_mcm.pl

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