Function reference • sqlhelper

Execution

Functions for reading, preparing and executing SQL

run_files() runfiles(): Read, prepare and execute .SQL files

run_queries() runqueries(): Execute a sequence of SQL queries

read_sql(): Read a sql file and return it's contents as a tibble

prepare_sql(): prepare queries and assemble meta data prior to execution

Connections

Functions for creating and managing database connections

connect(): (Re-)Establish connections to databases

config_examples(): Examples of yaml configurations for database connections

connection_info(): Browse available connections

live_connection(): Return the named connection or NULL

set_default_conn_name() get_default_conn_name(): Set/get the name of the default connection to use

default_conn(): Return the default connection

is_connected() not_connected(): Test whether a database is connected

disconnect(): Close all connections and remove them from the connections cache