query_check

We define a query as valid when it contains either one of the column names of
the table being queried and/or one of the <code>R</code> operators provided in the
<code>lookup_table</code> object of the package.

internal

Import Data from Relational Database Management Systems
(RDBMS) and Health Information Systems ('HIS'). The current version of the
package supports importing data from RDBMS including 'MS SQL', 'MySQL',
'PostGRESQL', and 'SQLite', as well as from two HIS platforms: 'DHIS2' and
'SORMAS'.

Bubacarr Bah

readepi

Read Data from Relational Database Management Systems and Health
Information Systems

Karim Mané

Emmanuel Kabuga

Bankolé Ahadzie

Nuredin Mohammed

Abdoelnaser Degoot

Hugo Gruson

Pratik Gupte

Andree Valle-Campos

London School of Hygiene and Tropical Medicine, LSHTM 

data.org 

query_check function

<dl><dt>query</dt>
<dd>An R expression that will be converted into an SQL query</dd>
<dt>login</dt>
<dd>The connection object obtained from the <code>login()</code> function.</dd>
<dt>table_name</dt>
<dd>A character with the table name</dd></dl>

Arguments

Check whether the user-provided query is valid — query_check

<dl>

<dt>query</dt>
<dd>An R expression that will be converted into an SQL query</dd>


<dt>login</dt>
<dd>The connection object obtained from the <code>login()</code> function.</dd>


<dt>table_name</dt>
<dd>A character with the table name</dd>

</dl>

Check whether the user-provided query is valid

query_check: Check whether the user-provided query is valid

Description

Usage

Value

Arguments