DBtestSQLite {FIESTAutils}

Database - Checks access to a SQLite database.

Description

Checks a SQLite database.

Usage

DBtestSQLite(
  SQLitefn = NULL,
  gpkg = FALSE,
  dbconnopen = FALSE,
  outfolder = NULL,
  showlist = TRUE,
  returnpath = TRUE,
  createnew = TRUE,
  stopifnull = FALSE,
  overwrite = TRUE
)

Arguments

SQLitefn

String. Name of SQLite database (*.sqlite).

gpkg

Logical. If TRUE, Sqlite geopackage database.

dbconnopen

Logical. If TRUE, the dbconn connection is not closed.

outfolder

String. Optional. Name of output folder. If NULL, export to working directory.

showlist

Logical. If TRUE, shows list of tables in database.

returnpath

Logical. If TRUE, returns full path to SQLite file name. If FALSE, returns SQLitefn.

createnew

If TRUE, creates new SQLite database.

stopifnull

Logical. If TRUE, stops if SQLite database doesn't exist.

overwrite

Logical. If TRUE, overwrites data.

Value

Character string containing the path to the SQLite database of interest.

Author(s)

Tracey S. Frescino