X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=branch%2Fdouble_build%2Fexec%2Fshowbuilds;fp=branch%2Fdouble_build%2Fexec%2Fshowbuilds;h=c35e558e2dca10fcdd1090f52e3845592d760951;hb=bbe8a759637a74b5036c8c7345de55a96cb7bbd6;hp=0000000000000000000000000000000000000000;hpb=449efd24870d395eb1edfd4d3a59e239c8cc5547;p=cran2deb.git

diff --git a/branch/double_build/exec/showbuilds b/branch/double_build/exec/showbuilds
new file mode 100755
index 0000000..c35e558
--- /dev/null
+++ b/branch/double_build/exec/showbuilds
@@ -0,0 +1,37 @@
+#!/bin/sh
+## DOC: cran2deb showbuilds [date]
+## DOC:     list build summary for given date
+## DOC:     default value for date is current day
+## DOC:
+db=/var/cache/cran2deb/cran2deb.db
+date=`date "+%Y-%m-%d"`
+
+usage_and_exit()
+{
+    cat <<EOF
+Usage: showbuilds [-d date] [-?|-h]"
+  Show build for given dates
+Options:
+  -d date       use given date, else default to current date
+  -h            show this help
+EOF
+    exit 0
+}
+
+options=':d:h?'
+while getopts "$options" i
+do
+    case "$i" in
+        d)
+            date=$OPTARG
+            ;;
+        h|?)
+            usage_and_exit
+            ;;
+    esac
+done
+
+cmd="select id,success,system,package,r_version,deb_epoch,deb_revision,scm_revision,db_version,date_stamp,time_stamp from builds where date_stamp = '${date}'"
+
+sqlite3 -header -column $db "$cmd"
+