gtoxQuery {GladiaTOX} | R Documentation |
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.
gtoxQuery(query, db = getOption("TCPL_DB"), drvr = getOption("TCPL_DRVR")) gtoxSendQuery(query, db = getOption("TCPL_DB"), drvr = getOption("TCPL_DRVR"))
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 |
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.
None
## 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)