}
db_date_format <- '%Y-%m-%d'
-db_time_format <- '%H:%M:%OS %Z'
+db_time_format <- '%H:%M:%OS'
db_record_build <- function(package, deb_version, log, success=F) {
# if the log is more than 1kB, only keep the last 1kB.
log <- paste(log,collapse='\n')
end <- nchar(log)
- max_log_len <- 1024
+ max_log_len <- 10240
if (end > max_log_len) {
log <- db_quote(substr(log,end-max_log_len,end))
} else {
,',',db_quote(scm_revision)
,',',log
,')')
- print(sqlcmd)
+ ##print(sqlcmd)
try(dbGetQuery(con,sqlcmd))
options(o)
db_stop(con)
db_blacklist_reasons <- function () {
con <- db_start()
- packages <- dbGetQuery(con,'SELECT package,explanation from blacklist_packages')
+ packages <- dbGetQuery(con,'SELECT package,explanation from blacklist_packages group by explanation')
db_stop(con)
return(packages)
}