migration of legacy registries

[vjcitn]

It is not too hard to move the data from a BatchJobs to a batchtools registry.
However, it is troublesome to retrieve the getJobInfo table

getJobInfo(g17, select=c("id", "time.submitted", "time.running", "time.done", "memory"))
Error in dbDoQuery(reg, query) :
Error in dbDoQuery. Error in rsqlite_send_query(conn@ptr, statement) :
no such column: error_time
(SELECT job_id,submitted,done,CASE WHEN error IS NULL THEN done - started ELSE error_time - started END AS time_running,memory FROM jklSVAD_chr17_expanded_jobs)

Probably the work can be done by manually querying the sqlite database -- but if you have
anything more elegant, it would be worth noting in the migration-oriented documentation.

sessionInfo()
R version 3.4.3 beta (2017-11-20 r73757)
Platform: x86_64-apple-darwin15.6.0 (64-bit)
Running under: macOS Sierra 10.12.6

Matrix products: default
BLAS: /Library/Frameworks/R.framework/Versions/3.4/Resources/lib/libRblas.0.dylib
LAPACK: /Library/Frameworks/R.framework/Versions/3.4/Resources/lib/libRlapack.dylib

locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8

attached base packages:
[1] parallel stats4 stats graphics grDevices utils datasets
[8] methods base

other attached packages:
[1] batchtools_0.9.7 data.table_1.10.4-3 geuvStore2_1.8.0
[4] GenomicRanges_1.30.0 GenomeInfoDb_1.14.0 IRanges_2.12.0
[7] S4Vectors_0.16.0 BiocGenerics_0.24.0 BatchJobs_1.7
[10] BBmisc_1.11 rmarkdown_1.8

loaded via a namespace (and not attached):
[1] Rcpp_0.12.14 lattice_0.20-35
[3] prettyunits_1.0.2 Rsamtools_1.30.0