Skip to contents

PostgreSQL Database Module

Source: R/mod_PostgreSQL_setup.R
mod_postgres.Rd

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.

Usage

postgresql_setup_ui(id)

postgresql_setup_server(id)

Arguments

id

The module namespace

Value

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.