DB_FILE := db.sqlite
SCRIPTS_DIR := scripts
SQL_SCRIPTS := $(wildcard $(SCRIPTS_DIR)/*.sql)

.PHONY: all clean

all: $(DB_FILE)

$(DB_FILE): $(SQL_SCRIPTS)
	@echo "Creating database: $@"
	@for script in $^; do \
		echo "Running script: $$script"; \
		sqlite3 $@ < $$script; \
	done
	@echo "Database creation completed."

clean:
	@echo "Cleaning up"
	@rm -f $(DB_FILE)
	@echo "Cleanup completed."