createStaticNASIS: Create a memory or file-based instance of NASIS database

In soilDB: Soil Database Interface

Create a memory or file-based instance of NASIS database

Description

Create a memory or file-based instance of NASIS database for selected tables.

Usage

createStaticNASIS(
  tables = NULL,
  new_names = NULL,
  SS = TRUE,
  dsn = NULL,
  output_path = NULL,
  verbose = FALSE
)

Arguments

tables	Character vector of target tables. Default: NULL is whatever tables are listed by DBI::dbListTables for the connection typ being used.
new_names	Optional: new table names (should match length of vector of matching tables in dsn)
SS	Logical. Include "selected set" tables (ending with suffix "_View_1"). Default: TRUE
dsn	Optional: path to SQLite database containing NASIS table structure; or a DBIConnection. Default: NULL
output_path	Optional: path to new/existing SQLite database to write tables to. Default: NULL returns table results as named list.
verbose	Show error messages from attempts to dump individual tables? Default FALSE

Value

A named list of results from calling dbQueryNASIS for all columns in each NASIS table.

soilDB documentation built on Sept. 11, 2024, 8:28 p.m.