RESDIR=/usr/local/share/pshbspool
XSLS= 120329_chihoumikeiho.xsl 120329_chihoumiyoho.xsl 120329_choui1.xsl \
  120329_dosya.xsl 120329_env_uvindex.xsl 120329_fukenkaihyou.xsl \
  120329_ippanho.xsl 120329_kei_all_line_div.xsl 120329_kfxc80.xsl \
  120329_kiroame.xsl 120329_kisetsu.xsl 120329_KisetuYohoHtmlPlain.xsl \
  120329_kozui.xsl 120329_Sbt.xsl 120329_shukan.xsl \
  120329_SoukeiHtmlPlain.xsl 120329_tatsumaki.xsl \
  120329_TenkoJohoHtmlPlain.xsl 120329_tokusyu.xsl 120329_umikeiho1.xsl \
  120329_yoho.xsl 120510_tenkizu.xsl \
  120615_jishin_tsunami_tokai_decode_all.xsl 120615_kazan.xsl \
130201_kozui.xsl \
130412_kei_all_line_div.xsl \
130523_tenkizu.xsl \
130621_SoukeiHtmlPlain.xsl \
140425_tatsumaki.xsl \
150514_kazan.xsl \
150916_kei_h27.xsl \
150916_keihoukyuu_asatte.xsl \
150916_keihoukyuu_asu.xsl \
161121_chiho_kaijo_keiho.xsl \
161121_chiho_kaijo_yoho.xsl \
tab.css

install:
	test -d $(RESDIR) || mkdir -p $(RESDIR)
	for f in $(XSLS); do install $$f $(RESDIR)/ ; done

dbload:
	mysql pshbspool -e 'LOAD DATA LOCAL INFILE "'`pwd`'/jmxxsl.tsv" INTO TABLE jmxxsl(title,abr,xsl)' 

dbsave:
	mysql pshbspool -e 'SELECT title,abr,xsl FROM jmxxsl INTO OUTFILE "'`pwd`'/jmxxsl.tsv"'

dbdiff:
	mysql pshbspool -e 'SELECT DISTINCT title FROM jmxmsgs WHERE title NOT IN (SELECT title FROM jmxxsl)' > z.txt