ConnectRAM: A function to connect to the RAM legacy stock assessment...

Description Usage Arguments Details Examples

Description

A function to connect to the RAM legacy stock assessment database

Usage

1
2
3
ConnectRAM(auth.list = getOption("RAM.auth",
  stop("Need to provide a list of authorization args with elements host, user, password, dbname, port")),
  drv.name = "PostgreSQL")

Arguments

auth.list

a list including authorization arguments including host, user, password, dbname, port (provided at link above)

drv.name

database driver to use for DBI ('PostgreSQL' on mac/linux)

Details

constructs a databse connection using DBI-compliant connection via RPostgreSQL package returns list of connection and driver. (latest connection info: http://ramlegacy.marinebiodiversity.ca/ram-legacy-stock-assessment-database/accessing-the-live-database) before using be sure to read the fair use policy: http://ramlegacy.marinebiodiversity.ca/ram-legacy-stock-assessment-database/ram-legacy-stock-assessment-database-fair-use-policy

Examples

1
2
3
4
5
6
7
8
## Not run: 
# Can add lines to your .Rprofile file to store connection info provided at http://ramlegacy.marinebiodiversity.ca/ram-egacy-stock-assessment-database/accessing-the-live-database
options(RAM.auth =  alist(host="nautilus-vm.mathstat.dal.ca", user="srdbuser", password="srd6us3r!", dbname="srdb", port="5432"))
## make a connection
c <- ConnectRAM()
CloseRAM(c)

## End(Not run)

ashander/RAMlegacyr documentation built on May 12, 2019, 4:41 a.m.