initcommitsdb: Initialize my db connection

In crazybilly/muadc: A collection of functions and variables

Description

a convinence function to connect to the commits database on localhost.

Usage

initcommitsdb(
  use = "RMariaDB",
  odbc = "warehouse510c",
  mysqldb = "commits",
  mysqlhost = "10.40.9.145",
  mysqluser = "adc",
  mysqlpassword = "goBigBlue",
  ...
)

Arguments

use	what kind of database connection to use. Currently valid options include: RMariaDB, odbc, mysql and pool. RMariaDB is used by default. The pool option uses RMariaDB, but makes the connection with pool::dbPool() rather than DBI::dbConnect().
odbc	a string of an odbc connection to use. If NULL, database connects with credentials in mysql* arguments.
mysqldb	a string of the name of the database name with which you should connect. Defaults to the 'commits' db.
mysqlhost	the hostname or ip address for the database server
mysqluser	the database username
mysqlpassword	the database password
...	further arguments to pass to DBI::dbConnect

Value

Assigns a database connection, plus connections to the hallp, dnrc, desgs, commits, gifts, pledges and memos tables in the global environment.

crazybilly/muadc documentation built on March 6, 2021, 4:15 p.m.