Check for a file in the input/dbfiles tables

Function to check to see if a file exists in the dbfiles table as an input

Usage

dbfile.input.check(
  siteid,
  startdate = NULL,
  enddate = NULL,
  mimetype,
  formatname,
  parentid = NA,
  con,
  hostname = PEcAn.remote::fqdn(),
  exact.dates = FALSE,
  pattern = NULL,
  return.all = FALSE
)

Arguments

siteid

the id of the site that this data is applicable to

startdate

the start date of the data stored in the file

enddate

the end date of the data stored in the file

mimetype

the mime-type of the file

formatname

the name of the format to distinguish between simmilair mime-types

parentid

the id of the parent of the input

con

database connection object

hostname

the name of the host where the file is stored, this will default to the name of the current machine

exact.dates

setting to include start and end date in input query

pattern

text to seach for in the file name (default NULL = no check).

return.all

(Logical) If 'TRUE', return all files. If 'FALSE', return only the most recent files.

Value

data.frame with the id, filename and pathname of the input that is requested

Details

This will check the dbfiles, inputs, machines and formats tables to see if the file exists

Author

Rob Kooper, Tony Gardella, Hamze Dokoohaki

Examples

if (FALSE) { # \dontrun{
  dbfile.input.check(siteid, startdate, enddate, 'application/x-RData', 'traits', dbcon)
} # }