Man pages for skgrange/databaser
Tools to Keep Database Interaction Easy and Consistent
| build_insert_statements | Function to build 'INSERT INTO' SQL statements from a data... |
| build_update_statements | Function to build SQL 'UPDATE' statements from an input data... |
| db_analyse | Function to analyse/analyze a database table. |
| db_arrange_variables | Function to arrange variables in a data frame/tibble to match... |
| db_check_integrity | Function to test a SQLite database's integrity. |
| db.class | Function to determine database connection class/type. |
| db_clear_results | Function to clear results for a database connection. |
| db_commit | Function to commit transactions for a database connection. |
| db_connect | Function to create a database connection with a 'JSON'... |
| db_connection_name | Functions to get a database connection strings/names that are... |
| db_copy_table_between_connections | Function to copy a database table from one connection to... |
| db_count_rows | Function to get row counts from database tables. |
| db_count_rows_insert | Function to get row counts and insert into a database table. |
| db_count_variables | Function to count variables/columns/fields in a database... |
| db_details | Function to return some high level details about a database. |
| db_details_insert | Function to return some high level details about a database. |
| db_direct_insert | Function to connect and insert directly into a database. |
| db_direct_list_tables | Function to connect and list a database's tables directly. |
| db_direct_read | Function to connect and read database table directly. |
| db_disconnect | Function to close a database connection cleanly. |
| db_drop_table | Function to drop a database table. |
| db_duplicates | Function to find duplicates in a database table's variable. |
| db_execute | Function to execute statements on a database. |
| db_get | Function to get/fetch data from a database with a statement. |
| db_has_duplicates | Function to test if duplicates are contained in a database... |
| db_head | Function to get first _n_ rows of a database table. |
| db_import_row_counts | Functions to import somewhat standard tables from databases. |
| db_information_schema | Function to get schema information from a database. |
| db_insert | Function to insert a data frame into/as a database table (R... |
| db_kill_process | Function to kill a database process. |
| db_list_activities | Function to list activities/processes for a database. |
| db_list_constraints | Function to list table constraints for a database. |
| db_list_data_types | Function to list data types of database tables. |
| db_list_indices | Function to list indices for a database tables. |
| db_list_results | Function to list results for a database connection. |
| db_list_schemas | Function to list schemas for a database. |
| db_list_tables | Function to list database tables. |
| db_list_users | Function to list users for a database. |
| db_list_variables | Function to list all variables/columns/fields in a database... |
| db_name | Function to get database name. |
| db_post_gis_version | Function to return PostGIS version information from an... |
| db_read_table | Function to read an entire database table. |
| db_send | Function to send a statements to a database. |
| db_size | Function to get the size of a database. |
| db_sqlite_master | Function to get SQLite 'sqlite_master' query. |
| db_table_data_types | Function to get a database tables' data types. |
| db_table_exists | Function to test if database contains a table. |
| db_table_info | Function to get SQLite table information ('PRAGMA... |
| db_table_names | Function to get the names of database table and produce a... |
| db_table_permissions | Function to get a database's table permissions information... |
| db_truncate_table | Function to run a 'TRUNCATE TABLE' statement for a database... |
| db_vacuum | Functions to vacuum, analyse, and optimise database tables. |
| db_value_exists | Function to test if a value exists in a database table's... |
| db_variables | Function to return all variable names in all tables in a SQL... |
| db_version | Function to get the version of a database service. |
| db_wildcard_check | Function to test for wildcards and then raise an error if... |
| db_with_transaction | Function open a database transaction, perform operations, and... |
| dplyr-functions | Pseudo-function to re-export *dplyr*'s common functions. |
| pipe | Pseudo-function to re-export *magrittr*'s pipe. |
| read_sql | Function to read a SQL script and store statments as a... |
| reexports | Objects exported from other packages |
| stringr-functions | Pseudo-function to re-export *stringr*'s common functions. |
| str_sql_collapse | Function to collapse vectors into a vector with a length of... |
| utils-functions | Pseudo-function to re-export functions from the *utils*... |
| zzz | Squash the global variable notes when building a package. |
