# Copyright 2017, pEp Foundation

 # This file is part of pEpEngine

 # This file may be used under the terms of the GNU General Public License version 3

 # see LICENSE.txt

 include ../Makefile.conf

 .PHONY: db

 db: system.db

 DICOS = $(wildcard *.csv)

 # The 'mv' keeps a backup db around

 system.db: create_system_db.sql $(DICOS)

 	-mv -f $@ $@~ 

 	sqlite3 -batch $@ < $<

 	for c in $(DICOS) ; do echo "$$c" ; echo .import "$$c" wordlist | sqlite3 -batch -csv $@ ; done

 .PHONY: install

 install: system.db

 	mkdir -p `dirname $(SYSTEM_DB)`

 	cp system.db $(SYSTEM_DB)

 .PHONY: clean

 clean:

 	rm -f system.db system.db~