#!/bin/sh

apk add mqtt-exec sqlite lighttpd haserl lua lua-cjson lua-sqlite lua5.3 lua5.3-sql-sqlite3
	# mini_httpd can be used instead of lighttpd
adduser -H -D www
chown lighttpd:lighttpd -R /var/lib/build-errors
chmod +x /var/lib/build-errors/*.lua
ln -s mqtt-exec /etc/init.d/mqtt-exec.build-errors

# testings
vi /etc/conf.d/mqtt-exec.build-errors
	# mqtt_broker="broker.hivemq.com"
echo 'build/build-edge-armhf/errors {"hostname":"build-edge-armhf","pkgname":"package1","reponame":"repo1","logurl":"http:\/\/build.alpinelinux.org\/buildlogs\/build-edge-armhf\/main\/package1\/package1-5.5.1-r0.log"}' | /bin/sh /var/lib/build-errors/scripts/save-build-error.sh
mosquitto_pub -h broker.hivemq.com -t 'build/build-edge-armhf/errors' -m '{"hostname":"build-edge-armhf","pkgname":"package1","reponame":"repo1","logurl":"http:\/\/build.alpinelinux.org\/buildlogs\/build-edge-armhf\/main\/package1\/package1-5.5.1-r0.log"}'
	# if worked:
	#  sqlite3 /var/lib/build-errors/sqlite/build-errors.db "delete from build_errors where id = xxxx"
	#   (id nr can be found in webpage source in that row <!-- id: xxxx -->)
# testing cron-job script:
sqlite3 /var/lib/build-errors/sqlite/build-errors.db "insert into build_errors(hostname,pkgname,reponame,logurl,comment,datetime) values ('test1','test1','test1','#','test1','2001-01-01')"
sqlite3 /var/lib/build-errors/sqlite/build-errors.db "insert into build_errors(hostname,pkgname,reponame,logurl,comment,datetime) values ('test2','test2','test2','#','test2','2002-02-02')"
sudo --user=lighttpd sh /etc/periodic/weekly/clear-old-build-errors.sh