Learn R Programming

validatedb (version 0.1.4)

confront_tbl: create a table with per record if it abides to the rule.

Description

create a table with per record if it abides to the rule.

Usage

confront_tbl(tbl, x, key = NULL)

Arguments

tbl

dbplyr::tbl_dbi() table in a database, retrieved with tbl()

x

validate::validator() object with validation rules.

key

character with key column name.

Value

a list with needed information, see details.

Details

The return value of the function is a list with:

  • $query: A dbplyr::tbl_dbi() object that refers to the confrontation query.

  • $errors: The validation rules that are not working on the database

  • $working: A logical with which expression are working on the database.

  • $exprs: All validation expressions.

  • $nexprs: Number of working expression.