Check if DB connections available and valid or create new one

Check if DB connections available and valid or create new one

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.