db_getSQLQuery: to perform general SQL select like statements

In BenBruyneel/BBPersonalR: BBPersonalR

to perform general SQL select like statements

Description

to perform general SQL select like statements

Usage

db_getSQLQuery(db, SQLString, doNotChangePool = FALSE)

Arguments

db	database access 'handle'
SQLString	the SQL query to be performed
doNotChangePool	boolean that sets whether the pool has to be locked/ released inside this function. Usually this needs to be done, so default is FALSE. Set to TRUE if this locking/release is done outside of the function. Note that there is a sort of bug when working with the pool::dbWriteTable : when a sql constraint like UNIQUE is defined for the table used, this may result in a locked database upon error. It's advisable to set doNotChangePool to TRUE to prevent this from happening

Value

result from the SQL query, usually a data.frame

BenBruyneel/BBPersonalR documentation built on Aug. 23, 2024, 8:28 p.m.