store_location_group_location: store the link between locations and location groups in the...

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

Description

store the link between locations and location groups in the database

Usage

store_location_group_location(location_group_location, location_group,
  location, datafield, conn, hash, clean = TRUE)

Arguments

location_group_location	a data.frame with the locations per location group. Must contain location_group_local_id and location_local_id. Other columns are ignored.
location_group	the data.frame with location groups. Must contains local_id, description and scheme. Other variables are ignored. local_id must have unique values.
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_group_location must have variables location_local_id and location_group_local_id.

• location_group must have variables local_id, description and scheme

• 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

• all values in location_group_location$location_local_id must exist in location$local_id

• all values in location_group_location$location_group_local_id must exist in location_group$local_id

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