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

In SQLove: Execute 'SQL' Scripts in 'R' Containing Multiple Queries

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(conn, conn_type = "JDBC", sql_path, pattern = NULL, replacement = NULL)

Arguments

conn	A database connection object
conn_type	A string indicating if the connection type is a JDBC or ODBC connection - accepts "JDBC" or "ODBC" as arguments, defaults to "JDBC"
sql_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. You may provide a single string or a vector of strings equal in length to the vector of strings in the replacement field.
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. You may provide a single string or a vector of strings equal in length to the vector of strings in the replacement field.

Value

A data object

SQLove documentation built on June 8, 2025, 1:09 p.m.