Quick look at remote data

Source: R/rlook.R

Quick look at remote data

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

#> table `d` SQLiteConnection 
#>  nrow: 1 
#> 'data.frame':	1 obs. of  2 variables:
#>  $ AUC: num 0.6
#>  $ R2 : num 0.2