manage_dbcons: Returns a connection to the election violence database

In gidonc/durhamevp: ESRC/AHRC Victorian Election Violence Project R Code (Durham University)

Returns a connection to the election violence database

Description

This function is primarily for use within other functions. This is now a wrapper function around pool::dbPool to handle connections to the database. Database password is obtained from the keyring if there is a password for the database in the keyring. Otherwise the user is prompted for the database password.

Usage

manage_dbcons(
  host = "coders.victorianelectionviolence.uk",
  username = "data_writer",
  dbname = "evp",
  port = 3306
)

gidonc/durhamevp documentation built on April 8, 2022, 10:31 a.m.