validateKeys: Validate key parameters

In talithafs/dzVis-Package: Data Visualization with Data Zoom

Description

Checks if the values of a parameter are unique within a data table. It uses a direct connection to the dzVis database.

Usage

validateKeys(table, candidateKeys, connection = NULL)

Arguments

table	A character. The name of the table in the dzVis database.
keys	A character vector. The column name(s) of the candidate key(s).

Value

A character. The constant .VALID if the parameters are valid. Otherwise, a vector containing the names of the columns that should be restricted to make keys values unique when combined.

Validation rules

1. If keys has only one column name, each row of this column must contain a different value.

2. If keys has more than one column name, a subset of those columns must have unique values when combined.

talithafs/dzVis-Package documentation built on May 31, 2019, 2:54 a.m.