Delete records from the database, based on subselection criteria

This is a convenience function that deletes records from the logging_session table, which cascades to dependent tables (individ info and status, deployment and retrieval info, startup and shutdown tables, and file archive).

Usage

deleteRecords(
  colony = NULL,
  intendedLocation = NULL,
  year = NULL,
  species = NULL,
  updatedAfter = NULL,
  updatedBefore = NULL,
  updatedBy = NULL,
  sessionId = NULL,
  force = FALSE
)

Arguments

selectColony

Character string. Option to limit selection to one or a set of colonies. Default is NULL.

selectUpdateTime

Timestamp or character string that can be interpreted as a timestamp through as.POSIXct. Delete only records that where last updated after this timestamp

selectSpecies

Character string. Option to limit selection to one or a set of species. Default is NULL.

Force

True, False (default = False). Skip confirmation check (for non interactive functionality)

Value

Status message

Examples

if (FALSE) { # \dontrun{
deleteRecords(selectUpdateTime = "2018-04-20")
} # }