OpenSqliteConnection: Opens sqlite database connection

In dmenne/d13cbreath: Reads and Evaluates Gastric Emptying 13C Breath Test Data

Description

Opens an connection to sqlite database; creates the database if it does not exists. If missing, file name is given by getOption("Gastrobase2SqlitePath") which is set to <HOME>/GastroBase/Gastobase/Gastrobase2.sqlite at package load time.

When options(D13CBreath.sqldebug=TRUE), SQL of queries is printed out

Usage

OpenSqliteConnection(sqlitePath = NULL)

Arguments

sqlitePath

Full filename with path to create database file.

Value

con Connection for use with dbExecute and dbGetQuery

Examples

## Not run: 
con = OpenSqliteConnection()
dbGetQuery(con, "Select PatientID,Name,FirstName from Patient")
dbDisconnect(con)

## End(Not run)

dmenne/d13cbreath documentation built on March 1, 2020, 3:41 a.m.