gtoxQuery {GladiaTOX} | R Documentation

## Wrappers for sending queries and fetching results

### Description

These functions send a query to the given database, and are the access point for all gtox functions that query or update the gtox database.

### Usage

    gtoxQuery(query, db = getOption("TCPL_DB"),
      drvr = getOption("TCPL_DRVR"))

    gtoxSendQuery(query, db = getOption("TCPL_DB"),
      drvr = getOption("TCPL_DRVR"))

### Arguments

`query` | Character of length 1, the query string
`db` | Character of length 1, the name of the gtox database
`drvr` | Character of length 1, which database driver to use

### Details

Currently, the gtox package only supports the "MySQL" and "SQLite" database drivers.

`gtoxQuery` returns a data.table object with the query results. `gtoxSendQuery` sends a query, but does not fetch any results, and returns 'TRUE' or the error message given by the database.

### Value

None

### Examples

    ## Perform query
    gtoxSendQuery(paste0("SELECT * FROM assay_source"))

    ## Store the current config settings, so they can be reloaded at the end
    ## of the examples
    conf_store <- gtoxConfList()
    gtoxConfDefault()

    gtoxQuery("SELECT 'Hello World';")
    gtoxQuery("SELECT * FROM assay;")

    ## Reset configuration
    options(conf_store)

[Package GladiaTOX version 1.10.3 Index]