make_new_database_if_necessary: Create or delete a new database as required

In personalscience/tasterdb: Create and Maintain Databases for Tastermonial Projects

Description

Intended for situations where you want to start all over, this function will use direct SQL calls to either create a brand new database or, if optionally drop=TRUE, wipe out any existing database. IMPORTANT: database connection is dropped regardless, so if you need a connection, be sure reconnect.

Usage

make_new_database_if_necessary(
  conn_args = config::get("dataconnection"),
  db_name,
  drop = FALSE,
  force = FALSE
)

Arguments

conn_args	connection
db_name	character string name for proposed new database
drop	Nuke a database with this name if it already exists (default = FALSE)
force	override the warning about creating a database with the magic name qsdb (default = FALSE)

personalscience/tasterdb documentation built on Dec. 22, 2021, 7:44 a.m.