data-cleaning. To fix this you can add URL: https://edwindj.r-universe.dev/validatedb to the package DESCRIPTION file. See also theR-universe documentation.Package: validatedb 0.3.2.9000
validatedb: Validate Data in a Database using 'validate'
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'.
Authors:
validatedb_0.3.2.9000.tar.gz
validatedb_0.3.2.9000.zip(r-4.7)validatedb_0.3.2.9000.zip(r-4.6)validatedb_0.3.2.9000.zip(r-4.5)
validatedb_0.3.2.9000.tgz(r-4.6-any)validatedb_0.3.2.9000.tgz(r-4.5-any)
validatedb_0.3.2.9000.tar.gz(r-4.7-any)validatedb_0.3.2.9000.tar.gz(r-4.6-any)
validatedb_0.3.2.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
validatedb/json (API)
NEWS
| # Install 'validatedb' in R: |
| install.packages('validatedb', repos = c('https://edwindj.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/data-cleaning/validatedb/issues
databasedatacleaningvalidation
Last updated from:935f1ba79c. Checks:7 ERROR, 2 OK. Indexed: no.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | ERROR | 159 | ||
| source / vignettes | OK | 205 | ||
| linux-release-x86_64 | ERROR | 160 | ||
| macos-release-arm64 | ERROR | 138 | ||
| macos-oldrel-arm64 | ERROR | 79 | ||
| windows-devel | ERROR | 105 | ||
| windows-release | ERROR | 107 | ||
| windows-oldrel | ERROR | 93 | ||
| wasm-release | OK | 111 |
Exports:check_rulescomputeconfrontconfront.tbl_sqldump_sqlshow_querytblvalues
Dependencies:blobclicpp11DBIdbplyrdplyrgenericsgluelifecyclemagrittrpillarpkgconfigpurrrR6rlangsettingsstringistringrtibbletidyrtidyselectutf8validatevctrswithryaml
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Count the number of invalid rules or records. | aggregate.tbl_validation |
| Retrieve validation results as a data.frame | as.data.frame.tbl_validation |
| Check validation rules on the database | check_rules |
| Store the validation result in the db | compute.tbl_validation |
| Create a sparse confrontation query | confront_tbl_sparse |
| Validate data in database 'tbl' with 'validator' rules. | confront,ANY,validator,ANY-method confront.tbl_sql |
| dump sql statements | dump_sql |
| tests for each rule if it can be executed on the database | rule_works_on_tbl |
| Show generated sql code | show_query.tbl_validation |
| Validation object for 'tbl' object | tbl_validation tbl_validation-class |
| Retrieve the result of a validation/confrontation | values,tbl_validation-method |
