Populates deltas table when user updates primary table — cdr_update_db_deltas_tbl • crudr

Connects to and posts who-what-when data to a change tracking table Function is called when a user updates the data in a primary table

Usage

cdr_update_db_deltas_tbl(
  conn_pool,
  db_tbl_name,
  to_deltas_tbl,
  db_tzone = cdr_adj_timezone(conn_pool)
)

Arguments

conn_pool: pool connection object: the pool of connections established by the session
db_tbl_name: string: name of the specific database table or cdr_id() object
to_deltas_tbl: tibble of delta values to append
db_tzone: the DB timezone (obtained from cdr_adj_timezone(conn_pool))

Value

an in-memory copy of the data appended to the tracking table