dbQueryReconnect: Connect to DB, and if it's timed out, tries again

In dgarmat/dgfunctionpack: Key Functions I Use Often

Description

Connect to DB, and if it's timed out, tries again

Usage

dbQueryReconnect(statement, con = conn, ...,
  conn_specs = dbConnect_specs, db_func = c("get", "send"))

Arguments

statement	SQL code to query
conn_specs	a list that has item 1 = drv, item 2 = host, item 3 = keyring service name that is the server with password of user password for server
db_func	specifies which dbXQuery function to use, where X is the name of the db_func
conn	an open DBIConnection object, as returned by dbConnect()

Value

data_frame object

Examples

dbQueryReconnect("SELECT * FROM GENDER_D")
dbQueryReconnect("DROP TABLE ABC_XYZ_123___", db_func = "send")

dgarmat/dgfunctionpack documentation built on May 17, 2020, 9:58 p.m.