Man pages for LearningToTalk/L2TDatabase
Helper Functions for the Learning-To-Talk 'MySQL' Database
| append_rows_to_table | Append rows to a database table |
| backup_tbl | Download a tbl from a db connection and write to a csv |
| chrono_age | Compute chronological age in months |
| convert_diff_to_update_statement | Convert a summary of diffs into a SQL UPDATE query |
| convert_row_to_delete_statement | Create a SQL DELETE query from a row of a dataframe |
| create_diff_table | Summarize the changes between two data-frames |
| delete_rows_in_table | Remove records in a table |
| describe_db | Download a codebook for a database |
| describe_tbl | Download a codebook for a database table |
| dump_database | Backup a database as a sequence of SQL statements |
| equality | A stronger element-wise equality operators |
| find_new_rows_in_table | Compare two tables to find new records |
| grapes-from-grapes | Grab a table from a source |
| l2t_backup | Download each tbl in a database and write to csv |
| l2t_connect | Connect to the L2T database using a MySQL config file |
| L2TDatabase | Helper functions for working with L2T's MySQL database |
| make_cnf_file | Create a MySQL config file |
| match_columns | Make columns in one data-frame match those in a second... |
| overwrite_rows_in_table | Update records in a table |
| select-helpers | Versions of dplyr's select helpers that fail safely |
| undo_excel_date | Convert an Excel date to a POSIX date |
