dbcon: Connect to a database

In mpio-be/sdb: Database Tools

Connect to a database

Description

dbcon returns a database connection. If user and password are not given dbq looks for previously saved credentials see( saveCredentials ). closeCon closes the connection.

Usage

dbcon(
  user = Sys.info()["user"],
  pwd = "",
  db = NA,
  host = "scidb.mpio.orn.mpg.de",
  path,
  driver = "MySQL",
  ...
)

closeCon(con)

## S4 method for signature 'MariaDBConnection'
closeCon(con)

## S4 method for signature 'MySQLConnection'
closeCon(con)

Arguments

user	username
pwd	password ("" or NA means no password e.g. for localhost)
db	database to connect to
host	default to "scidb.mpio.orn.mpg.de"
path	to credentials file (if different from the default)
driver	MySQL, MariaDB or mysql_gdal, ... Defaults to MySQL
...	pass to dbConnect
con	a connection made with dbcon or dbConnect

Value

a connection object

See Also

saveCredentials, dbq

mpio-be/sdb documentation built on Nov. 18, 2022, 12:24 a.m.