mod_postgres function

PostgreSQL Database Module

This module is designed to guide a user through the process of authenticating with a PostgreSQL database. The user is visually prompted for typical PostgreSQL connection parameters. User entered information is verified and once authenticated, a DBI::dbConnect() object is returned.

This module consists of the following components:

Module UI function

• postgresql_setup_ui: A uiOutput that allows users to connect to provide connection parameters required to connect to a PostgreSQL database.

Module Server function

• postgresql_setup_server: The logic that controls the graphical user interface, validates user inputs, and returns a DBI::dbconnect() object used to connect to the desired PostgreSQL database.

postgresql_setup_ui(id)

postgresql_setup_server(id)

Arguments

• id: The module namespace

Returns

postgresql_setup_ui: - tagList: The shinyPostgreSQL Setup UI

postgresql_setup_server: - reactiveValues: * moduleName: A string, containing the module moniker. * moduleType: A string, with the module type (what does it do?) * setup_ui: The module setup ui function * is_connected: A string, with module connection status. Valid statuses are 'yes' or 'no'. * db_con: A DBI::dbConnect object, containing the user configured PostgreSQL connection information.