rapOpenDbConnection: Provide connection handle for data source at Rapporteket

View source: R/dbConnection.R

rapOpenDbConnectionR Documentation

Provide connection handle for data source at Rapporteket

Description

Generic to registries, handle the data source connections, including usernames and passwords needed to open these connections

Usage

rapOpenDbConnection(dbName, dbType = "mysql")

Arguments

dbName

String providing the name of the database to connect to. If it is "data" it will use the MYSQL_DB_DATA environment variable, if it is "autoreport" it will use the MYSQL_DB_AUTOREPORT environment variable, and if it is "raplog" it will use the MYSQL_DB_LOG environment variable. If none of these are set, it will use the name provided.

dbType

String providing type of data source, one of "mysql" and "mssql". Defaults to "mysql". "mssql" is not supported anymore.

Value

A named list of con and drv representing the db connection handle and driver, respectively.


Rapporteket/rapbase documentation built on June 10, 2025, 4:58 a.m.