db_read_table: Read a table from RRD database and return as an...

In LEEF-UZH/LEEF.analysis: Access Functions, Tests and Basic Analysis of the RRD Data from the LEEF Project

Read a table from RRD database and return as an tbl_SQLiteConnection.

Description

This function does not actually fetch the data, but returns an tbl_SQLiteConnection object which can be further processed / filtered using dplyr. See https://db.rstudio.com/r-packages/dplyr/ for details. To fetch the actual data, execute collect().

Usage

db_read_table(
  db = getOption("RRDdb", "LEEF.RRD.sqlite"),
  table = NULL,
  quiet = FALSE
)

Arguments

db	fully qualified path to the sqlite database. Default, read from option RRDdb. If not set, defaults to option RRDdb; if this is not set, defaults to LEEF.RRD.sqlite
table	the name of the table. If 'NULL', a list of tables in the database 'db' will be returned.
quiet	if TRUE a warning will be issued whe the table name is NULL.

Value

Link to the table density in the RRD to be used with dplyr and friends

LEEF-UZH/LEEF.analysis documentation built on Feb. 8, 2025, 11:18 a.m.