fecalConnect: Connect to the KRSP Fecals Database

In mwhalen18/krspfecals: KRSP Auxilary Fecal Database

Description

These methods are extensions of the RMySQL and DBI drivers and are therefore compatible with tbl functions.

For additional information on underlying arguments that can be passed to this call, see documentation for dbConnect or dbConnect

Usage

fecalConnect(...)

Arguments

username, password	Username and password. If username omittedd, defaults to the current user. If password is omitted, only users without a password can login. By defualt this will throw and error if no parameters are entered. This will be changed in future version to default to local instance without a password.
dbname	krsp fecal database name. Defualts to "krspfecals"
host	host endpoint for database instance. Defulats to remote AWS instance but can be changed to localhost.

Examples

## Not run: 
#connect5 to the MySQL database running remotely
con = fecalConnect(user = "user", password = "password")

#connect to local instance of the database
con = fecalConnect(user = "user", password = "password", host = "127.0.0.1")

#Always clean up by disconnecting from the database
dbDisconnect(con)

#Alternatively, there is a handy function built in here
fecalDisconnect(con)

## End(Not run)

mwhalen18/krspfecals documentation built on Dec. 21, 2021, 11:05 p.m.