getTimeBinsTable {birdscanR}

Get BirdScan time bins table

Description

load time bins table from an already connected 'Birdscan MR1' 'SQL' database

Usage

getTimeBinsTable(dbConnection, dbDriverChar)

Arguments

dbConnection

a valid database connection

dbDriverChar

the name of the driver. If different from 'PostgreSQL' it connects to cloud.birdradar.com

Value

A dataframe with the time bins table

Author(s)

Fabian Hertner, [e-mail]; Birgen Haest, [e-mail]

Examples

## Not run: 
# Set server and database settings
# ===========================================================================
  dbServer       = "MACHINE\\SERVERNAME" # Set the name of your SQL server
  dbName         = "db_Name"               # Set the name of your database
  dbDriverChar   = "SQL Server"            # Set either "SQL Server" or "PostgreSQL"

# Open the connection with the database
# ===========================================================================
  dsn = paste0("driver=", dbDriverChar, ";server=", dbServer,
               ";database=", dbName,
               ";uid=", rstudioapi::askForPassword("Database user"),
               ";pwd=", rstudioapi::askForPassword("Database password"))
  dbConnection = RODBC::odbcDriverConnect(dsn)

timeBinsTable = getTimeBinsTable(dbConnection, dbDriverChar)

## End(Not run)