create_db_connection: Create Database Connection Function
In PHSKC-APDE/apde: Common functions used in APDE's work

create_db_connection

R Documentation

Create Database Connection Function

Create a connection to the prod or dev servers that APDE uses

create_db_connection(
  server = c("phextractstore", "hhsaw", "inthealth"),
  prod = TRUE,
  interactive = FALSE
)

`server`	Whether we are connecting to HHSAW, inthealth, or phextractstore
`prod`	Whether the production or dev/WIP servers are to be used. Defaults to `prod = TRUE`.
`interactive`	Whether to input password manually for HHSAW/inthealth or to use keyring. True should be used when connecting on VM, typically, or if keyring/odbc are not set up yet for a given server. Defaults to `interactive = FALSE`.