##############################################################################
##############################################################################
###
### Running command:
###
###   F:\biocbuild\bbs-3.17-bioc\R\bin\R.exe CMD check --no-multiarch --install=check:CompoundDb.install-out.txt --library=F:\biocbuild\bbs-3.17-bioc\R\library --no-vignettes --timings CompoundDb_1.3.1.tar.gz
###
##############################################################################
##############################################################################


* using log directory 'F:/biocbuild/bbs-3.17-bioc-rtools43/meat/CompoundDb.Rcheck'
* using R Under development (unstable) (2022-12-25 r83502 ucrt)
* using platform: x86_64-w64-mingw32 (64-bit)
* R was compiled by
    gcc.exe (GCC) 10.4.0
    GNU Fortran (GCC) 10.4.0
* running under: Windows Server x64 (build 20348)
* using session charset: UTF-8
* using option '--no-vignettes'
* checking for file 'CompoundDb/DESCRIPTION' ... OK
* checking extension type ... Package
* this is package 'CompoundDb' version '1.3.1'
* checking package namespace information ... OK
* checking package dependencies ... OK
* checking if this is a source package ... OK
* checking if there is a namespace ... OK
* checking for hidden files and directories ... OK
* checking for portable file names ... OK
* checking whether package 'CompoundDb' can be installed ... OK
* checking installed package size ... OK
* checking package directory ... OK
* checking 'build' directory ... OK
* checking DESCRIPTION meta-information ... OK
* checking top-level files ... OK
* checking for left-over files ... OK
* checking index information ... OK
* checking package subdirectories ... OK
* checking R files for non-ASCII characters ... OK
* checking R files for syntax errors ... OK
* checking whether the package can be loaded ... OK
* checking whether the package can be loaded with stated dependencies ... OK
* checking whether the package can be unloaded cleanly ... OK
* checking whether the namespace can be loaded with stated dependencies ... OK
* checking whether the namespace can be unloaded cleanly ... OK
* checking dependencies in R code ... OK
* checking S3 generic/method consistency ... OK
* checking replacement functions ... OK
* checking foreign function calls ... OK
* checking R code for possible problems ... OK
* checking Rd files ... OK
* checking Rd metadata ... OK
* checking Rd cross-references ... OK
* checking for missing documentation entries ... OK
* checking for code/documentation mismatches ... OK
* checking Rd \usage sections ... OK
* checking Rd contents ... OK
* checking for unstated dependencies in examples ... OK
* checking files in 'vignettes' ... OK
* checking examples ... OK
* checking for unstated dependencies in 'tests' ... OK
* checking tests ...
  Running 'testthat.R'
 OK
* checking for unstated dependencies in vignettes ... OK
* checking package vignettes in 'inst/doc' ... OK
* checking running R code from vignettes ... SKIPPED
* checking re-building of vignette outputs ... SKIPPED
* checking PDF version of manual ... OK
* DONE

Status: OK

##############################################################################
##############################################################################
###
### Running command:
###
###   F:\biocbuild\bbs-3.17-bioc\R\bin\R.exe CMD INSTALL CompoundDb
###
##############################################################################
##############################################################################


* installing to library 'F:/biocbuild/bbs-3.17-bioc/R/library'
* installing *source* package 'CompoundDb' ...
** using staged installation
** R
** inst
** byte-compile and prepare package for lazy loading
Creating a new generic function for 'mass2mz' in package 'CompoundDb'
** help
*** installing help indices
*** copying figures
** building package indices
** installing vignettes
** testing if installed package can be loaded from temporary location
** testing if installed package can be loaded from final location
** testing if installed package keeps a record of temporary installation path
* DONE (CompoundDb)

R Under development (unstable) (2022-12-25 r83502 ucrt) -- "Unsuffered Consequences"
Copyright (C) 2022 The R Foundation for Statistical Computing
Platform: x86_64-w64-mingw32/x64 (64-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> library("testthat")
> library("CompoundDb")
Loading required package: AnnotationFilter

Attaching package: 'AnnotationFilter'

The following object is masked from 'package:testthat':

    not

Loading required package: S4Vectors
Loading required package: stats4
Loading required package: BiocGenerics

Attaching package: 'BiocGenerics'

The following objects are masked from 'package:stats':

    IQR, mad, sd, var, xtabs

The following objects are masked from 'package:base':

    Filter, Find, Map, Position, Reduce, anyDuplicated, aperm, append,
    as.data.frame, basename, cbind, colnames, dirname, do.call,
    duplicated, eval, evalq, get, grep, grepl, intersect, is.unsorted,
    lapply, mapply, match, mget, order, paste, pmax, pmax.int, pmin,
    pmin.int, rank, rbind, rownames, sapply, setdiff, sort, table,
    tapply, union, unique, unsplit, which.max, which.min


Attaching package: 'S4Vectors'

The following objects are masked from 'package:base':

    I, expand.grid, unname

> library(RSQLite)
> 
> hmdb <- system.file("sdf/HMDB_sub.sdf.gz", package = "CompoundDb")
> cmps <- compound_tbl_sdf(hmdb)
> metad <- data.frame(name = c("source", "url", "source_version",
+                              "source_date", "organism"),
+                     value = c("HMDB_test", "http://www.hmdb.ca",
+                               "v4", "2017-08-27", "Hsapiens"))
> db_file <- createCompDb(cmps, metadata = metad, path = tempdir())
> cmp_db <- CompDb(db_file)
> 
> dr <- system.file("xml/", package = "CompoundDb")
> msms_spctra <- msms_spectra_hmdb(dr)
Going to process 4 xml files.
Postprocessing data ... OK
> ## spl_ <- as(msms_spctra, "Spectra")
> 
> metad2 <- data.frame(name = c("source", "url", "source_version",
+                               "source_date", "organism"),
+                      value = c("HMDB_spctra", "http://www.hmdb.ca",
+                                "v4", "2017-08-27", "Hsapiens"))
> db_spctra_file <- createCompDb(cmps, metadata = metad2, path = tempdir(),
+                                msms_spectra = msms_spctra)
> cmp_spctra_db <- CompDb(db_spctra_file)
> 
> cdb <- CompDb(system.file("sql/CompDb.MassBank.sql", package = "CompoundDb"))
> 
> ions <- data.frame(compound_id = paste0("HMDB000000",
+                                         c("1", "1", "2", "2", "5")),
+                    ion_adduct = c("A", "B", "B", "C", "D"),
+                    ion_mz = c(100, 110, 150, 170, 200),
+                    ion_rt = c(50, 60, 100, 110, 90))
> ion_db <- IonDb(paste0(tempdir(), "/ion_db.db"), cmp_db, ions)
> 
> ion_spctra_db <- IonDb(paste0(tempdir(), "/ion_spctra_db.db"),
+                        cmp_spctra_db, ions)
> 
> test_check("CompoundDb")
MsBackendCompDb with 0 spectra
MsBackendCompDb with 4 spectra
    msLevel precursorMz  polarity
  <integer>   <numeric> <integer>
1        NA          NA         1
2        NA          NA         1
3        NA          NA         1
4        NA          NA         0
 ... 32 more variables/columns.
 Use  'spectraVariables' to list all of them.
 data source: HMDB_spctra 
 version: v4 
 organism: Hsapiens 
Creating package in F:\biocbuild\bbs-3.17-bioc-rtools43\tmpdir\Rtmpqm9rgT/CompDb.Hsapiens.ChEBI.unknown 
[ FAIL 0 | WARN 11 | SKIP 1 | PASS 655 ]

══ Skipped tests ═══════════════════════════════════════════════════════════════
• empty test (1)

[ FAIL 0 | WARN 11 | SKIP 1 | PASS 655 ]
Warning message:
call dbDisconnect() when finished working with a connection 
> 
> proc.time()
   user  system elapsed 
  11.78    1.17   13.67