rquery (version 1.4.99)

rstr: Quick look at remote data

Description

Quick look at remote data

Usage

rstr(
  my_db,
  tableName,
  ...,
  displayRows = 10,
  countRows = TRUE,
  qualifiers = NULL
)
rlook(
  my_db,
  tableName,
  ...,
  displayRows = 10,
  countRows = TRUE,
  qualifiers = NULL
)

Value

str view of data

Arguments

my_db

database handle

tableName

name of table to look at

...

not used, force later arguments to bind by name

displayRows

number of rows to sample

countRows

logical, if TRUE return row count.

qualifiers

optional named ordered vector of strings carrying additional db hierarchy terms, such as schema.

Examples

if ( requireNamespace("DBI", quietly = TRUE) &&
  requireNamespace("RSQLite", quietly = TRUE)) {
  my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
  DBI::dbWriteTable(my_db,
                    'd',
                    data.frame(AUC = 0.6, R2 = 0.2),
                    overwrite = TRUE,
                    temporary = TRUE)
  rlook(my_db, 'd')
  DBI::dbDisconnect(my_db)
}