Description Usage Arguments Details Value Note Author(s) See Also Examples
View source: R/dbDownloadTemplate.R
Download Acoustic Templates from a Database
1 2 | dbDownloadTemplate(db.name = "acoustics", uid, pwd, type, names,
species, FFTwl, FFTovlp, FFTwn, ...)
|
db.name |
Name of the ODBC connector data source corresponding to the acoustics database. |
uid |
User ID to allow ODBC connector to connect to database, if not present in ODBC connector. |
pwd |
Password to allow ODBC connector to connect to database, if not present in ODBC connector. |
type |
Type of templates to select. Character value of either "BIN" or "COR". Some partial matching is performed to accept "bt" and "ct", for example. |
names |
Optional character value or vector of template names to filter selection from the database. If missing all templates matching other filters are selected. |
species |
Optional character value or vector of species to filter selection from the database. If missing all templates matching other filters are selected. |
FFTwl |
Optional character value or vector of FFT window lengths to filter selection from the database. If missing all templates matching other filters are selected. |
FFTovlp |
Optional character value or vector of FFT window overlap to filter selection from the database. If missing all templates matching other filters are selected. |
FFTwn |
Optional character value or vector of FFT window names to filter selection from the database. If missing all templates matching other filters are selected. |
... |
Additional arguments to |
This function assumes a database structure identical to that provided in the acoustics schema. If the username and password are present in the ODBC datasource they do not need to be provided. It is possible to store only the username in the datasource and enter a password, but the reverse will not work.
An object of class TemplateList
.
In the acoustics database templates are broken into components, and vectors are stored as text objects in various fields. To stay beneath the maximum download vector size of sqlQuery
, extraneous characters are removed from each vector during upload; some must be re-inserted during download. Space characters are not replaced, but all amplitude values for correlation templates are sign-inverted and converted from integers to floating point decimal. All decimals were rounded to the hundredth's place during upload. These measures are sometimes insufficient and users may find it useful to increase the maximum download vector size in sqlQuery (see the vignette “MySQL_DataSources_RODBC” for further details). Large templates may take more than several seconds to download; 2-10 seconds is normal for binary point matching templates, and 5-30 seconds is normal for correlation templates.
Jon Katz
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | ## Not run:
#If using the 'acoustics' schema verbatim:
btnw <- dbDownloadTemplate(
type = "BIN",
names= c("template1", "template2")
FFTwl = 512,
FFTovlp = 0,
FFTwn = "hanning")
#'acoustics' schema, different database name:
btnw <- dbDownloadTemplate(
db.name = "LocalSQLdb",
uid = "EntryOnly" ,
pwd = "07H23BBM",
type = "COR",
species = c("BTNW", "OVEN")
FFTwl = 512,
FFTovlp = 0,
FFTwn = "hanning")
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.