retrieve_tables: Retrieve Database Tables
In CC-HIC/inspectEHR: Data Quality Reporting for CC-HIC
Description
Usage
Arguments
Value
Examples
Description
Places all tables from the database connection in a list. This makes use of the tables
in dplyr extremely easy.
Usage
1
Arguments
connection
an sql connection
Value
a list containing pointers to tables within the sql connection.
Examples
1
2
3
4
5
6
db_pth <- system.file("testdata/synthetic_db.sqlite3", package = "inspectEHR")
ctn <- connect(sqlite_file = db_pth)
core <- make_core(ctn)
tbls <- retrieve_tables(ctn)
tbls[["events"]] # the events table
DBI::dbDisconnect(ctn)
CC-HIC/inspectEHR documentation built on Jan. 16, 2020, 11:24 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value Examples
Description
Places all tables from the database connection in a list. This makes use of the tables in dplyr extremely easy.
Usage
1 |
Arguments
connection |
an sql connection |
Value
a list containing pointers to tables within the sql connection.
Examples
1 2 3 4 5 6 | db_pth <- system.file("testdata/synthetic_db.sqlite3", package = "inspectEHR")
ctn <- connect(sqlite_file = db_pth)
core <- make_core(ctn)
tbls <- retrieve_tables(ctn)
tbls[["events"]] # the events table
DBI::dbDisconnect(ctn)
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.