loadESEData: loadESEData

In PopulationEcologyDivision/andesmerge: andesmerge: Maritimes tools for getting data out of ANDES and into the Maritimes groundfish database

loadESEData

Description

This function loads any of 6 known data frame objects into Oracle. If an unknown target_table is specified, that table will be created (and deleted, if it already existed) If the target_table is an existing ESE_* table, and confirmOverwrite is TRUE, then the new data will be appended.

Usage

loadESEData(
  cxnObj = NULL,
  source_df = NULL,
  target_table = NULL,
  confirmOverwrite = F
)

Arguments

cxnObj	default is NULL. This is a connection object from Mar.utils::make_oracle_cxn(). It MUST use ROracle - RODBC is not supported. The account specified by this needs permission to write tables in the target_schema.
source_df	default is NULL. This is a data frame containing the data that should be loaded to Oracle. It should correspond with the structure used by one of ESE_MISSIONS, ESE_SETS, ESE_CATCHES, ESE_BASKETS, ESE_SPECIMENS, ESE_LV1_OBSERVATIONS
target_table	default is NULL. This is the name of the specific Oracle table within the user schema (i.e. GROUNDFISH) where the data should go
confirmOverwrite	default is F. This must be set to T to append data to the production ESE tables

Value

nothing, but data gets loaded to the selected location in Oracle.

Author(s)

Mike McMahon, [e-mail]

See Also

Other general_use: colTypeConverter(), loadData(), matchAndesToESE(), setExperimentType(), tweakBasketsPostProcessing(), tweakBaskets(), tweakCatches(), tweakLv1(), tweakSets(), tweakSpecimensRaw(), tweakUniversal()

PopulationEcologyDivision/andesmerge documentation built on April 12, 2024, 6:28 a.m.