Convert between file paths and ids

These functions check the dbfiles and machines tables to see if the file exists, and return the container_id (dbfile.id) or full filename with path (dbfile.file) to the first one found. If none is found, both will return NA.

Usage

dbfile.file(type, id, con, hostname = PEcAn.remote::fqdn())

dbfile.id(type, file, con, hostname = PEcAn.remote::fqdn())

Arguments

type

the type of dbfile (Input, Posterior)

id

the id of container type

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

file

the full pathname to the file

Value

filename on host, or NA if none found

Functions

• dbfile.file(): Return full path to file from the dbfiles table

• dbfile.id(): Return id to container type given a filename

Author

Rob Kooper

Examples

if (FALSE) { # \dontrun{
  type <- "Input"
  id <- 7
  dbcon <- db.open(list(host = "postgres", user = "bety", password = "carya"))

  dbfile.file(type, id, dbcon)
} # }
if (FALSE) { # \dontrun{
  type <- "Model"
  file <- "/usr/local/bin/sipnet"
  dbcon <- db.open(list(host = "postgres", user = "bety", password = "carya"))

  dbfile.id(type, file, dbcon)
} # }