db.read_table

Wrapper function to read table from default or custom schema,
 and return <code>NA</code> by default if an error is encountered.

An enterprise-targeted scalable and customizable 'shiny' module providing an easy way to incorporate free-form note taking or discussion boards into applications.
The package includes a 'shiny' module that can be included in any 'shiny' application to create a panel containing searchable, editable text broken down by section headers.
Can be used with a local 'SQLite' database, or a compatible remote database of choice.

Daniel Kovtun

shinyNotes

Shiny Module for Taking Free-Form Notes

db.read_table function

<dl><dt>con</dt>
<dd>An object that inherits from
<code>DBIConnection-class</code>, typically generated by
<code>dbConnect()</code></dd>
<dt>table</dt>
<dd>A character string specifying the DBMS table name.</dd>
<dt>schema</dt>
<dd>A character string specifying the schema in which the table is
nested.</dd>
<dt>collect</dt>
<dd>A logical specifying whether the query results should be
collected into memory or left as a lazy query.</dd>
<dt>error_value</dt>
<dd>Error value to return if <code>dbReadTable()</code>
fails. Default is <code>NA</code>.</dd></dl>

Arguments

Read remote database tables into data frames with additional
  validation — db.read_table

<dl>

<dt>con</dt>
<dd>An object that inherits from
<code>DBIConnection-class</code>, typically generated by
<code>dbConnect()</code></dd>


<dt>table</dt>
<dd>A character string specifying the DBMS table name.</dd>


<dt>schema</dt>
<dd>A character string specifying the schema in which the table is
nested.</dd>


<dt>collect</dt>
<dd>A logical specifying whether the query results should be
collected into memory or left as a lazy query.</dd>


<dt>error_value</dt>
<dd>Error value to return if <code>dbReadTable()</code>
fails. Default is <code>NA</code>.</dd>

</dl>

db.read_table: Read remote database tables into data frames with additional validation

Description

Usage

Value

Arguments

Examples