whereSQL

The core of this package is a function eDT() which enhances DT::datatable() such that it can be used to interactively modify data in 'shiny'. By the use of generic 'dplyr' methods it supports many types of data storage, with relational databases ('dbplyr') being the main use case.

Jasper Schelfhout

editbl

'DT' Extension for CRUD (Create, Read, Update, Delete)
Applications in 'shiny'

Maxim Nazarov

Daan Seynaeve

Lennart Tuijnder

Saar Junius

whereSQL function

<dl><dt>conn</dt>
<dd>database connection object as given by <code><a href="https://dbi.r-dbi.org/reference/dbConnect.html">dbConnect</a></code>.</dd>
<dt>table</dt>
<dd>character table name (or alias used in query)</dd>
<dt>column</dt>
<dd>character column of table</dd>
<dt>operator</dt>
<dd>character</dd>
<dt>values</dt>
<dd>character vector of values</dd></dl>

Arguments

Author

Generate where sql — whereSQL

<dl>

<dt>conn</dt>
<dd>database connection object as given by <code><a href='https://dbi.r-dbi.org/reference/dbConnect.html'>dbConnect</a></code>.</dd>


<dt>table</dt>
<dd>character table name (or alias used in query)</dd>


<dt>column</dt>
<dd>character column of table</dd>


<dt>operator</dt>
<dd>character</dd>


<dt>values</dt>
<dd>character vector of values</dd>

</dl>

Generate where sql

whereSQL: Generate where sql

Description

Usage

Value

Arguments

Author