Man pages for brucemoran/shinySetupPostgreSQL
Read XLSX, RDS and CMD PDF files into a PostgreSQL table using Shiny.
| colExtant | Test if a column exists |
| date_as_class | Take a tibble with colnames to match pattern and force to... |
| date_table_cols | Columns that are date |
| grep_choice_selectin | For selectizeInput, grep on set of choices as to what is most... |
| grep_choice_selectin_vec | Set of predetermined named vector for grep_choice_selectin() |
| grepSpec | Column grep from vector of terms grep spectaculare |
| import_cmd_pdf | Parse CMD PDF reports, very hacky |
| inputDat | Read sheets from XLSX |
| inputData | Tests for previous input data, and/or takes input from user... |
| input_from_xlsx | Input XLSX file parsing |
| input_xlsx | Input XLSX file parsing |
| launchSSP | Launch the app |
| macroDissect | Parse macrodissection into correct format ensures that data... |
| mod_add_column | Opens modal (text-box for input) to ask for name of new... |
| mod_delete_column | Opens modal to ask for columns to delete (only those without... |
| mod_disc_db_con | Disconnection from Postgresql |
| mod_load_data_proceed | Tell user a table they are trying to create exists and will... |
| mod_map_columns | Opens modal to ask for map from data column to table column |
| mod_order_column | Opens modal (dropdowns for input) to ask for orders of... |
| mod_rename_column | Opens modal (dropdowns for input) to ask for column to rename |
| mod_saving_to | Opens modal telling save location |
| mod_sure_to_save | Opens modal (text-box for input) to ask if save should go... |
| mod_test_db_con | Test if connection to Postgresql can be made |
| mod_test_db_results | Test connection to Postgresql, handle success and error |
| mod_uniq_columns | Opens modal (dropdowns for input) to ask for columns to... |
| mod_validate_user_cond | Conditionally show advanced connection options for... |
| mod_validate_user_nt | Opens modal (text-box for input) to ask for user credentials |
| mutationStatus | Parse mutation status into correct format ensures that data... |
| new_table_cols | Columns for new table |
| new_table_reqs | Required columns for new table |
| numeric_table_cols | Columns that are numeric |
| obsev_add_col | Add column into table |
| obsev_arr_col | Method to reorder columns in table |
| obsev_col_del | Method to delete column into table |
| obsev_db_conxn | Allow change of connection credentials |
| obsev_del_col | Delete column into table |
| obsev_disconnex | Allow disconnection (useful if too many previous connections... |
| obsev_extantabled | Allow change of connection credentials |
| obsev_FILENAMES | Take filename INPUT and parse |
| obsev_go_loaddata | Load data into current table |
| obsev_go_rds | Go saving RDS |
| obsev_go_save | Save table to db |
| obsev_ins_col | Method to add column into table |
| obsev_ord_col | Method to initiate reorder columns in table |
| obsev_rename_col | Reordering columns in table |
| obsev_ren_col | Method to rename columns in table |
| obsev_save_rds | Save table to RDS |
| obsev_save_tab | Save table |
| obsev_show_tab | Show table |
| obsev_uni_col | Uniquify columns in table |
| obsev_uniq_col | Column data uniquified and output |
| obsev_userpass | Test connection credentials and connect, specify if table is... |
| obsev_valsdata_new | Parse Dates and other Data from VALS_DATA$New and binds to... |
| otherSummary | Allow choice to return 'other' as a value from summary tables |
| refHospital | Parse referring hospital into correct format ensures that... |
| render_simple_maintable | DT:renderDataTable filtering The resulting output should be... |
| render_unique_maintable | DT:renderDataTable |
| sheet_grep_string | string to grep XLSX sheets |
| siteCode | Parse site code ensures that data is formatted correctly |
| siteSource | Parse site source into correct format ensures that data is... |
| tatNA | Make TAT |
| tb_col_delim_split | Take a tibble column and split on delimiter returning index x... |
| test_coding | Make Test_Code from sheet NAME and other Test_Codes |
| year_shootout | Make Year based on one of the 4 dates included |
