Learn R Programming

validatedb (version 0.1.4)

Validate Data in a Database using 'validate'

Description

Check whether records in a database table are valid using validation rules in R syntax specified with R package 'validate'. R validation checks are automatically translated to SQL using 'dbplyr'.

Copy Link

Version

Install

install.packages('validatedb')

Monthly Downloads

8

Version

0.1.4

License

GPL-3

Issues

4

Pull Requests

0

Stars

33

Forks

3

Maintainer

Edwin Jonge

Last Published

October 6th, 2021

Functions in validatedb (0.1.4)

as.data.frame.tbl_validation

Retrieve validation results as a data.frame
reexports

Objects exported from other packages
show_query.tbl_validation

Show generated sql code
confront_tbl_sparse

Create a sparse confrontation query
confront_tbl

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

tests for each rule if it can be executed on the database
aggregate.tbl_validation

Count the number of invalid rules or records.
is_record_based

determine the dimensional structure of values so that it conforms to validate. Only used for values simplify. Works heuristically: get a subset out of db and executes validate::confront on it. Note, this returns also a value for rules that do not work on db!
compute.tbl_validation

Store the validation result in the db
values,tbl_validation-method

Retrieve the result of a validation/confrontation
confront.tbl_sql

Validate data in database tbl with validator rules.
validatedb-package

validatedb: Validate Data in a Database using 'validate'
tbl_validation-class

Validation object for tbl object