check_get_connection: Check if DB connections available and valid or create new one

In idea-analytics/ideadata: Tools and Utilities for accessing IDEA's Data Warehouse

Check if DB connections available and valid or create new one

Description

Check if DB connections available and valid or create new one

Usage

check_get_connection(
  .database_name,
  .schema,
  .server_name,
  r_and_a_server = FALSE
)

Arguments

.database_name	name of the database you want to connect to
.schema	the schema for the table you want to access
.server_name	the name of the server the database is hosted on
r_and_a_server	switch for attaching to R&A server. Default is FALSE

Value

returns an S4 object that inherits from DBIConnection. This object is used to communicate with the database engine.

Note that this function is called for it's side-effect: it will create a connection object with the name conn_{.database_name} so that other functions and users have access to the connection.

idea-analytics/ideadata documentation built on Feb. 1, 2024, 5:40 a.m.