Function reference • crudr

All functions

cdr_DB2RT_chg_log(): Download database change log and send it to the module server

cdr_DB2RT_primary(): Download database table and sync it to user interface

cdr_RT2DT_chg_log(): Format the change log R table into a DT

cdr_RT2DT_primary(): Format the primary R table into a DT

cdr_adj_timezone(): Provides an equivalent R timezone for the DB timezone

cdr_admin_key_ui(): Interface buttons for row additions and/or row deletions in the admin table

cdr_admin_tbl_ui(): HTML to output a DT from the Server module

cdr_append_tbl(): Appends data from a dataframe into an existing database table

cdr_attach_activity(): Determine the type of changes for the user change-log

cdr_chk_uniq_id(): Checks availability of unique ID in DB

cdr_chunk_tbl(): break a dataframe into a list of dataframes

cdr_coerce_value(): Change cell value using DT::coerceValue()

cdr_create_row_in_db(): Appends new row to primary table

cdr_delete_row_in_db(): Removes specified row from db table

cdr_deliver_admin_tbl(): Shiny UI HTML for the administrator table and

cdr_deliver_chg_log_tbl(): Gets the the change history table in the Shiny UI

cdr_id(): A drop-in replacement for DBI::Id(), but with ordered output

cdr_id2sql(): Convert a name or DBI::Id to SQL

cdr_join_tbls(): Join primary and deltas tables

cdr_js_edit_ctrl(): DT Javascript callback to make edit keys mimic the navigation and cell editing keys of LibreCalc/Excel

cdr_label_chg_log_activity(): Create change types for the change-log table

cdr_make_db_tbls(): Creates primary and deltas tables in a DB

cdr_make_unique_ids(): Attach unique IDs as the key column

cdr_manage_db_tbls(): Server module to present and control a DB table

cdr_name_delta_tbl(): creates the name of the change tracking table so it's set in one location

cdr_pull_db_tbls(): Collect both tables (admin & chg-log) from the DB, join them in a user view, and return all 3 tables in a list

cdr_reconstruct_past_tbl(): Build the admin table as it was at a point in the past

cdr_row_editor_html(): The html for the UI to add and delete new rows

cdr_std_pad(): Integer sequence with preceding zeroes

cdr_tbl2ansi_format(): Prep dataframe columns to become SQL insert stmts

cdr_trunc_tbl(): Removes a specified table by deleting the table or by removing just the table data (truncating)

cdr_update_db_deltas_tbl(): Populates deltas table when user updates primary table

cdr_update_db_primary_tbl(): Updates the primary db table by specifying value to change, corresponding db table, unique row ID, and column

cdr_which_db(): Given a DBI or pool connection, provides DB type