Download database table and sync it to user interface

Download database table and sync it to user interface

Usage

cdr_DB2RT_primary(conn_pool, db_tbl_name, key_col)

Arguments

conn_pool

pool connection object from package 'pool'

db_tbl_name

string: name of the specific table to update or cdr_id() object

key_col

string: the field that contains your unique ID key for each row

Value

a DT object to present the primary table

Examples

if (FALSE) {
con <- pool::dbPool(DBI::dbConnect(RSQLite::SQLite(), 'iris.db'))
cdr_make_db_tbls(con, iris)
cdr_DB2RT_primary(con, 'iris')
pool::dbRemoveTable(con,'iris')
pool::dbRemoveTable(con,'iris_DELTAS')
pool::poolClose(con)
}