2 ## DOC: cran2deb showbuilds [date]
3 ## DOC: list build summary for given date
4 ## DOC: default value for date is current day
6 db=/var/cache/cran2deb/cran2deb.db
7 date=`date "+%Y-%m-%d"`
12 Usage: showbuilds [-d date] [-?|-h]"
13 Show build for given dates
15 -d date use given date, else default to current date
22 while getopts "$options" i
34 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}'"
36 sqlite3 -header -column $db "$cmd"