epcim
10/22/2015 - 8:56 AM

drone-ci-sqlite-build-status.sh

drone-ci-sqlite-build-status.sh

#!/bin/sh

clear

while true; do
        sqlite3 /var/lib/drone/drone.sqlite "select build_id, build_author, build_status, ' --- ' ,'https://drone.myorg.com/' || b.repo_full_name||'/'||build_number  from builds a join repos b on a.build_repo_id = b.repo_id where build_status IN ('pending', 'running');"
        sleep 10
        clear
done