dbGetMultiQuery

Requires a DBI workflow that creates a connection with a relational database per DBI: https://dbi.r-dbi.org/. This function is an extension of the DBI::dbGetQuery and RJDBC::dbSendUpdate functions.

The nature of working with structured query language ('SQL') scripts
efficiently often requires the creation of temporary tables and there
are few clean and simple 'R' 'SQL' execution approaches that allow
you to complete this kind of work with the 'R' environment. This
package seeks to give 'SQL' implementations in 'R' a little love
by deploying functions that allow you to deploy complex 'SQL'
scripts within a typical 'R' workflow.

Kerns Sam

SQLove

Execute 'SQL' Scripts in 'R' Containing Multiple Queries

dbGetMultiQuery function

<dl><dt>connection</dt>
<dd>A database connection object</dd>
<dt>sql_file_path</dt>
<dd>Character vector pointing to SQL script</dd>
<dt>pattern</dt>
<dd>A character object you would like to substitute in the SQL script - this is not required and defaults to NULL. Calls gsub under the hood, so use regex for pattern identification</dd>
<dt>replacement</dt>
<dd>A character vector replacing the pattern specified - this is not required and defaults to NULL. Calls gsub under the hood, so use regex for pattern identification</dd></dl>

Arguments

Query a database with multiple query actions and one, final, select statement. — dbGetMultiQuery

<dl>

<dt>connection</dt>
<dd>A database connection object</dd>


<dt>sql_file_path</dt>
<dd>Character vector pointing to SQL script</dd>


<dt>pattern</dt>
<dd>A character object you would like to substitute in the SQL script - this is not required and defaults to NULL. Calls gsub under the hood, so use regex for pattern identification</dd>


<dt>replacement</dt>
<dd>A character vector replacing the pattern specified - this is not required and defaults to NULL. Calls gsub under the hood, so use regex for pattern identification</dd>

</dl>

dbGetMultiQuery: Query a database with multiple query actions and one, final, select statement.

Description

Usage

Value

Arguments