store_location: store locations in the database

In inbo/n2kupdate: Auxiliary Functions to Update the n2kresult Database

Description

store locations in the database

Usage

store_location(location, datafield, conn, hash, clean = TRUE)

Arguments

location	a data.frame with location metadata. Must contain the following columns: local_id, description, parent_local_id, datafield_local_id and external_code. Other columns are ignored.
datafield	a data.frame with datafield metadata. Must contain the variables local_id, datasource, table_name, primary_key and datafield_type. Other variables are ignored.
conn	a DBIconnection
hash	the hash of the update session
clean	perform all database operations within a transaction and clean up the staging tables. Defaults to TRUE.

Details

• location must have variables local_id, description, parent_local_id, datafield_local_id and extranal_code. Other variables are ignored

• datafield must have variables local_id, datasource, table_name, primary_key and datafield_type

• all local_id variables must be unique within their data.frame

• all values in location$datafield_local_id must exist in datafield$local_id

• all values in location$parent_location must be either NA or exist in location$local_id

inbo/n2kupdate documentation built on May 8, 2019, 5:42 p.m.