Connect to a Time Series Database

Share:

Description

Return a connection to a time series database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
    TSconnect(q, dbname, ...)
    ## S4 method for signature 'character,character'
TSconnect(q, dbname, ...)
    ## S4 method for signature 'logicalId'
show(object)
    ## S4 method for signature 'TSdb'
show(object)
    ## S4 method for signature 'TSmeta'
show(object)
    ## S4 method for signature 'TSdb'
print(x, ...)

Arguments

q

A character string indicating the query interface to use, or a database connection object.

dbname

The name of the database to which the connection should be established, omitted if q is a database connection object.

x

A database connection as returned by TSconnect.

object

an object to display.

...

Additional arguments passed to other methods. For TSconnect these will be passed to the database driver.

Details

This function establishes a connection using a driver from one of the driver packages (e.g. TSMySQL or TSSQLite). If q is a character string (e.g. "MySQL") then the method attempts to get a connection using the character string.

"TSconnect" uses dbConnect but checks the database has expected tables and also establishes information about additional features that may be available (vintiges and/or panels).

Options can be set to simplify access to a commonly used database (see TSput).

Value

A database connection.

See Also

TSdbi-package, dbConnect, TSget, TSput, TSdates