db_select_data: Basic SELECT statement wrapper returning results in a tibble

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

Description

Wrapper around DBI and formatting functions to execute a SELECT statement and return the results in a tibble.

Usage

db_select_data(con, select_statement)

Arguments

con	A DBIConnection object, as returned by DBI::dbConnect().
select_statement	a character string representing a SQL SELECT statement.

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_select_data(con, "SELECT * FROM PATIENTS")
admissions <- db_select_data(con, "SELECT * FROM ADMISSIONS WHERE SUBJECT_ID = 10006")

RSQLite::dbDisconnect(con)

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