db_get_from_table: Simple generic SELECT * wrapper for extracting data from base...

In hdshea/MIMIC3db: Package for building, loading and referencing a SQLite version of the MIMIC-III v1.4 database on a local network

Description

Helper function to perform a basic SELECT * from the noted table projected down by the optional where clause. Note that some internal processing is performed to reflect general usage patterns including removing the ROW_ID column and converting DATE and TIME fields to POSIXct date-time format.

Usage

db_get_from_table(con, table, where = NULL)

Arguments

con	A DBIConnection object, as returned by dbConnect().
table	a character string representing a valit MIMIC-III table name.
where	a character string representing a SQL WHERE clause.

Value

a tibble with the results.

Examples

con <- RSQLite::dbConnect(RSQLite::SQLite(), ":memory:")
p <- tibble::tibble(SUBJECT_ID = c(10006, 10011))
a <- tibble::tibble(SUBJECT_ID = c(10006, 10011))
RSQLite::dbWriteTable(con, "PATIENTS", p)
RSQLite::dbWriteTable(con, "ADMISSIONS", a)

patients <- db_get_from_table(con, "PATIENTS")
admissions <- db_get_from_table(con, "ADMISSIONS", where = "WHERE SUBJECT_ID = 10006")

RSQLite::dbDisconnect(con)

hdshea/MIMIC3db documentation built on Dec. 20, 2021, 3:44 p.m.