R/tcplLoadAcid.R

In USEPA/CompTox-ToxCast-tcpl: ToxCast Data Analysis Pipeline

#-------------------------------------------------------------------------------
# tcplLoadAcid: Load assay component id and name for the given fields
#-------------------------------------------------------------------------------

#' @rdname assay_funcs
#' @import data.table
#' @export

tcplLoadAcid <- function(fld = NULL, val = NULL, add.fld = NULL) {
  tbl = c("assay_component", "assay_component_map", "assay")
  out <- c("assay_component.acid", 
           "assay_component.assay_component_name")
  
  qstring <- .buildAssayQ(out = out, 
                          tblo = c(1, 2, 4, 6, 3), 
                          fld = fld, 
                          val = val, 
                          add.fld = add.fld)
  
  dat <- tcplQuery(query = qstring, db = getOption("TCPL_DB"), tbl=tbl)
  
  dat[]
  
}

#-------------------------------------------------------------------------------