Description Usage Arguments Details Examples
These functions send a query to the given database, and are the access point for all tcpl functions that query or update the tcpl database.
1 2 3 4 |
query |
Character of length 1, the query string |
db |
Character of length 1, the name of the tcpl database |
drvr |
Character of length 1, which database driver to use |
Currently, the tcpl package only supports the "MySQL" and "SQLite" database drivers.
tcplQuery
returns a data.table object with the query results.
tcplSendQuery
sends a query, but does not fetch any results, and
returns 'TRUE' or the error message given by the database.
1 2 3 4 5 6 7 8 9 10 | ## Store the current config settings, so they can be reloaded at the end
## of the examples
conf_store <- tcplConfList()
tcplConfDefault()
tcplQuery("SELECT 'Hello World';")
tcplQuery("SELECT * FROM assay;")
## Reset configuration
options(conf_store)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.