new_det: Add new determinations to specimens.

In kamapu/specimensDB: Linking databases with package specimens

Add new determinations to specimens.

Description

Inserting new determinations to specimens stored in the database.

Note that more than one determination at the same date for the same specimen are not allowed and this will be checked before inserting new determinations. You can override this by setting 'compare = TRUE'

Usage

new_det(db, df, ...)

## S4 method for signature 'PostgreSQLConnection,data.frame'
new_det(
  db,
  df,
  schema = "specimens",
  tax_schema = "plant_taxonomy",
  compare = FALSE,
  ask = TRUE,
  ...
)

Arguments

db	Connections to the database as PostgreSQLConnection.
df	A data frame containing the information to be appended in the determination history of the specimen. This data frame must contain following columns: spec_id (identifier of specimens), taxon_usage_id (identifier of the taxon usage name), taxonomy (name of the taxonomic list applied to the update), det (name of the person that determined the species), and det_date (date of determination as Date).
...	Further arguments passed among methods (not yet used).
schema	Character value indicating the name of the schema containing the specimens' information.
tax_schema	Character value indicating the name of the schema containng the associated taxonomic list.
compare	Logical value indicating whether the determinations to be inserted should be compared with the input data frame or not (by default, not). If determinations for the same specimen at the same date are suppossed to be inserted in the database, they will be skipped. Note that duplicates in the input data frame will not be solved by this setting.
ask	A logical value, whether the function retrieves an interactive request printing the data frame to be appended or not.

Value

SQL commands will be executed.

Author(s)

Miguel Alvarez [e-mail]

kamapu/specimensDB documentation built on March 15, 2024, 1:27 p.m.