sbf_open_db: Open SQLite Database Connection

In poissonconsulting/subfoldr2: Save and Load R Objects

Open SQLite Database Connection

Description

Opens a SQLiteConnection to a SQLite database. Foreign key constraints are enabled.

Usage

sbf_open_db(
  db_name = sbf_get_db_name(),
  sub = sbf_get_sub(),
  main = sbf_get_main(),
  exists = TRUE,
  caption = NULL,
  report = NA,
  tag = NULL,
  ask = getOption("sbf.ask", TRUE)
)

Arguments

db_name	A string of the database name.
sub	A string specifying the path to the sub folder (by default the current sub folder).
main	A string specifying the path to the main folder (by default the current main folder)
exists	A logical scalar specifying whether the database must already exist.
caption	A string specifying the database metadata table caption. If NULL the caption is unchanged. If the caption is not specified for a databases it is set to be "". Deprecated.
report	A logical scalar specifying whether to include the database metadata table in the report. If report = NA the setting is not changed. Soft-deprecated. If the report status is not specified for a databases it is included in the report. deprecated.
tag	A string of the tag. Deprecated.
ask	A flag specifying whether to ask before deleting an existing database (if exists = FALSE).

See Also

Other database functions: sbf_add_blob_column_to_db(), sbf_close_db(), sbf_copy_db(), sbf_create_db(), sbf_execute_db(), sbf_query_db(), sbf_upload_flobs_to_db()

poissonconsulting/subfoldr2 documentation built on Nov. 17, 2024, 1:33 a.m.