##############################################################################
##############################################################################
###
### Running command:
###
###   /Library/Frameworks/R.framework/Resources/bin/R CMD check --install=check:CompoundDb.install-out.txt --library=/Library/Frameworks/R.framework/Resources/library --no-vignettes --timings CompoundDb_1.4.0.tar.gz
###
##############################################################################
##############################################################################


* using log directory ‘/Users/biocbuild/bbs-3.17-bioc/meat/CompoundDb.Rcheck’
* using R version 4.3.1 (2023-06-16)
* using platform: x86_64-apple-darwin20 (64-bit)
* R was compiled by
    Apple clang version 14.0.3 (clang-1403.0.22.14.1)
    GNU Fortran (GCC) 12.2.0
* running under: macOS Monterey 12.6.4
* 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.4.0’
* 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 for sufficient/correct file permissions ... 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:
###
###   /Library/Frameworks/R.framework/Resources/bin/R CMD INSTALL CompoundDb
###
##############################################################################
##############################################################################


* installing to library ‘/Library/Frameworks/R.framework/Versions/4.3-x86_64/Resources/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 version 4.3.1 (2023-06-16) -- "Beagle Scouts"
Copyright (C) 2023 The R Foundation for Statistical Computing
Platform: x86_64-apple-darwin20 (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 object is masked from 'package:utils':

    findMatches

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 /tmp/Rtmp1rlDfJ/CompDb.Hsapiens.ChEBI.unknown 
[ FAIL 0 | WARN 11 | SKIP 1 | PASS 660 ]

══ Skipped tests (1) ═══════════════════════════════════════════════════════════
• empty test (1): 'test_MsBackendCompDb.R:165:1'

[ FAIL 0 | WARN 11 | SKIP 1 | PASS 660 ]
Warning message:
call dbDisconnect() when finished working with a connection 
> 
> library(Spectra)
Loading required package: BiocParallel
Loading required package: ProtGenerics

Attaching package: 'ProtGenerics'

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

    smooth

> be <- backendInitialize(MsBackendCompDb(), cmp_spctra_db)
> test_suite <- system.file("test_backends", "test_MsBackend",
+                           package = "Spectra")
> test_dir(test_suite, stop_on_failure = TRUE)
✔ | F W  S  OK | Context

⠏ |          0 | spectra_subsetting                                             
⠋ |          1 | spectra_subsetting                                             
⠋ |         11 | spectra_subsetting                                             
⠦ |         17 | spectra_subsetting                                             
⠧ |         18 | spectra_subsetting                                             
⠇ |         19 | spectra_subsetting                                             
⠏ |         20 | spectra_subsetting                                             
⠹ |         23 | spectra_subsetting                                             
⠸ |         24 | spectra_subsetting                                             
⠼ |         25 | spectra_subsetting                                             
⠏ |         30 | spectra_subsetting                                             
⠸ |         34 | spectra_subsetting                                             
⠦ |      1  36 | spectra_subsetting                                             
✔ |      1  36 | spectra_subsetting [3.2s]

⠏ |          0 | spectra_variables                                              
⠸ |          4 | spectra_variables                                              
⠇ |          9 | spectra_variables                                              
⠸ |         14 | spectra_variables                                              
⠇ |         19 | spectra_variables                                              
⠼ |         25 | spectra_variables                                              
⠇ |         29 | spectra_variables                                              
⠸ |         34 | spectra_variables                                              
⠇ |         39 | spectra_variables                                              
⠧ |         48 | spectra_variables                                              
⠹ |         53 | spectra_variables                                              
⠸ |         54 | spectra_variables                                              
⠙ |         62 | spectra_variables                                              
✔ |         64 | spectra_variables [1.5s]

══ Results ═════════════════════════════════════════════════════════════════════
Duration: 4.7 s

── Skipped tests (1) ───────────────────────────────────────────────────────────
• empty test (1): 'test_spectra_subsetting.R:90:1'

[ FAIL 0 | WARN 0 | SKIP 1 | PASS 100 ]
> 
> proc.time()
   user  system elapsed 
 39.807   1.781  54.498