getProtocolTable {birdscanR} | R Documentation |
Get BirdScan protocol table
Description
load protocol table from an already connected 'Birdscan MR1' 'SQL' database
Usage
getProtocolTable(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 protocol table
Author(s)
Fabian Hertner, fabian.hertner@swiss-birdradar.com; Birgen Haest, birgen.haest@vogelwarte.ch
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)
protocolTable = getProtocolTable(dbConnection, dbDriverChar)
## End(Not run)
[Package birdscanR version 0.3.0 Index]