rstr: Quick look at remote data

In rquery: Relational Query Generator for Data Manipulation at Scale

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
)

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.

Value

str view of data

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)
}

rquery documentation built on Aug. 20, 2023, 9:06 a.m.