populate_db: Populate target database

In AdamCottrill/glfishr: Fetch fisheries assessment data from the FN Portal

Populate target database

Description

given a list containing our data elements and a target database, iterate over the list and insert the data into the corresponding table in the target database. The names in the list must correspond with the tables in the target database, and it must be possible to insert the tables in alphabetical order. (which works for FN-2, but may not always be the case)

Usage

populate_db(target, data, verbose, verbose_sqlsave)

Arguments

target	the path to the target accdb file
data	a named list containing the data to insert the target db
verbose	should the table and record count be reported
verbose_sqlsave	Boolean. Default=FALSE. This value is passed through to RODBC::sqlsave. Set to True to see all of the sql statements passed to target database. Useful for debugging.

Author(s)

Adam Cottrill [e-mail]

See Also

append_data, populate_template_assessment

AdamCottrill/glfishr documentation built on Aug. 9, 2024, 5:47 p.m.