is.historical: Checks if table contains historical data

In SCDB: Easily Access and Maintain Time-Based Versioned Data (Slowly-Changing-Dimension)

Checks if table contains historical data

Description

Checks if table contains historical data

Usage

is.historical(.data)

Arguments

.data

(data.frame(1), tibble(1), data.table(1), or tbl_dbi(1)) Data object.

Value

TRUE if .data contains the columns: "checksum", "from_ts", and "until_ts". FALSE otherwise.

Examples

  conn <- get_connection()

  dplyr::copy_to(conn, mtcars, name = "mtcars", temporary = FALSE)
  create_table(mtcars, conn, db_table = id("mtcars_historical", conn))

  is.historical(get_table(conn, "mtcars")) # FALSE
  is.historical(get_table(conn, "mtcars_historical")) # TRUE

  close_connection(conn)

SCDB documentation built on Oct. 4, 2024, 1:09 a.m.