dbGetMultiQuery {SQLove}

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

Description

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.

Usage

dbGetMultiQuery(connection, sql_file_path, pattern = NULL, replacement = NULL)

Arguments

connection

A database connection object

sql_file_path

Character vector pointing to SQL script

pattern

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

replacement

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

Value

A data object