credbl: credbl: Database Credential Management

In BCHSI/credbl: Credbl: Database Credential Management

credbl: Database Credential Management

credbl functions

• get_credentials – retrive credentials

• get_mssql_driver – retrive driver

• mj – format mongodb query

• date_to_mongo – convert date to mongodb format

Examples

# connecting to a Microsoft SQL database with the ODBC driver

# read server settings
dbconfig <- read_yaml("database_info.yaml")
# get driver
dbconfig <- get_mssql_driver(dbconfig)
# get credentials
credentials <- get_credentials(dbconfig$server)

connection <- DBI::dbConnect(
    odbc(),
    driver=dbconfig$driver,
    server=dbconfig$server,
    port=dbconfig$port,
    uid=credentials$uid,
    pwd=credentials$pwd,
    # database='mydatabase'
    )

BCHSI/credbl documentation built on April 16, 2023, 4:17 a.m.