cdr_update_db_deltas_tbl: Populates deltas table when user updates primary table

In eauleaf/crudr: Simplifies CRUD tasks including tracking changes of a db table

Populates deltas table when user updates primary table

Description

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

eauleaf/crudr documentation built on Jan. 29, 2024, 4:39 p.m.