Easier 'SQL' Integration


[Up] [Top]

Documentation for package ‘sqlhelper’ version 0.2.1

Help Pages

config_examples Examples of yaml configurations for database connections
connect (Re-)Establish connections to databases
connection_info Browse available connections
default_conn Return the default connection
disconnect Close all connections and remove them from the connections cache
get_default_conn_name Set/get the name of the default connection to use
is_connected Test whether a database is connected
live_connection Return the named connection or NULL
not_connected Test whether a database is connected
prepare_sql prepare queries and assemble meta data prior to execution
read_sql Read a sql file and return it's contents as a tibble
runfiles Read, prepare and execute .SQL files
runqueries Execute a sequence of SQL queries
run_files Read, prepare and execute .SQL files
run_queries Execute a sequence of SQL queries
set_default_conn_name Set/get the name of the default connection to use