data-cleaning. 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.5)validatedb_0.3.2.9000.zip(r-4.4)validatedb_0.3.2.9000.zip(r-4.3)
validatedb_0.3.2.9000.tgz(r-4.4-any)validatedb_0.3.2.9000.tgz(r-4.3-any)
validatedb_0.3.2.9000.tar.gz(r-4.5-noble)validatedb_0.3.2.9000.tar.gz(r-4.4-noble)
validatedb_0.3.2.9000.tgz(r-4.4-emscripten)validatedb_0.3.2.9000.tgz(r-4.3-emscripten)
validatedb.pdf |validatedb.html✨
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 3 years agofrom:935f1ba79c. Checks:OK: 1 ERROR: 6. Indexed: no.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Dec 01 2024 |
| R-4.5-win | ERROR | Dec 01 2024 |
| R-4.5-linux | ERROR | Dec 01 2024 |
| R-4.4-win | ERROR | Dec 01 2024 |
| R-4.4-mac | ERROR | Dec 01 2024 |
| R-4.3-win | ERROR | Dec 01 2024 |
| R-4.3-mac | ERROR | Dec 01 2024 |
Exports:check_rulescomputeconfrontconfront.tbl_sqldump_sqlshow_querytblvalues
Dependencies:blobclicpp11DBIdbplyrdplyrfansigenericsgluelifecyclemagrittrpillarpkgconfigpurrrR6rlangsettingsstringistringrtibbletidyrtidyselectutf8validatevctrswithryaml
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 |
