insert_names: Insert new taxonomic names in database

In kamapu/vegtableDB: Handling Vegetation Data Sets (Advanced Features)

Insert new taxonomic names in database

Description

Different routines may require to compare a list of new names with existing database. Names that are already in the database will be maintained and only new names will get inserted in the database.

For existing names, if further information is provided, this will be updated in the database.

Usage

insert_names(conn, df, schema, ...)

## S4 method for signature 'PostgreSQLConnection,data.frame,character'
insert_names(conn, df, schema, clean = TRUE, eval = TRUE, update = FALSE, ...)

## S4 method for signature 'PostgreSQLConnection,data.frame,missing'
insert_names(conn, df, schema = "plant_taxonomy", ...)

Arguments

conn	A PostgreSQLConnection object connecting to a target database.
df	A data frame with the list of names that will be inserted to the database. Two columns are mandatory in this data frame, namely usage_name and author_name.
schema	A character value indicating the name of the schema containing the taxonomic list. If the table taxon_names does not exists in this schema, this function retrieves an error message.
...	Further arguments passed among methods (not in use).
clean	A logical value indicating cleaning of characters.
eval	A logical value indicating whether the produced SQL commands should be sent to the database or not.
update	A logical value indicating whether attributes of existing names (mentioned as recycled) should be updated according to the input data frame or not.

kamapu/vegtableDB documentation built on June 18, 2024, 1:13 a.m.