{ "_id": "6ab79b2e99f7aa8c6aa32c4f", "Package": "validatedb", "Title": "Validate Data in a Database using 'validate'", "Version": "0.3.2.9000", "Authors@R": "c(\nperson(given = \"Edwin\",\nfamily = \"de Jonge\",\nrole = c(\"aut\", \"cre\"),\nemail = \"edwindjonge@gmail.com\",\ncomment = c(ORCID=\"0000-0002-6580-4718\"))\n)", "Description": "Check whether records in a database table are valid using\nvalidation rules in R syntax specified with R package\n'validate'. R validation checks are automatically translated to\nSQL using 'dbplyr'.", "License": "GPL-3", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.2.0", "URL": "https://github.com/data-cleaning/validatedb", "BugReports": "https://github.com/data-cleaning/validatedb/issues", "Collate": "'aggregate.R' 'tbl_validation.R' 'as-data-frame.R'\n'check_rules.R' 'compute.R' 'confront.R' 'confront_tbl.R'\n'confront_tbl_sparse.R' 'contains_at_least.R' 'do_by.R'\n'dump_sql.R' 'exists_any.R' 'is_complete.R' 'is_record_based.R'\n'is_unique.R' 'rewrite.R' 'rule_works_on_tbl.R' 'show_query.R'\n'summary.R' 'tbl.R' 'unsparse.R' 'validatedb-package.R'\n'values.R' 'violating.R' 'wrap_expression.R'", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://edwindj.r-universe.dev", "Date/Publication": "2022-06-03 14:09:02 UTC", "RemoteUrl": "https://github.com/data-cleaning/validatedb", "RemoteRef": "HEAD", "RemoteSha": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "NeedsCompilation": "no", "Packaged": { "Date": "2026-09-26 10:10:26 UTC", "User": "root" }, "Author": "Edwin de Jonge [aut, cre] (ORCID:\n)", "Maintainer": "Edwin de Jonge ", "_user": "edwindj", "_type": "src", "_file": "validatedb_0.3.2.9000.tar.gz", "_fileid": "https://r2.ropensci.org/70a16578b01fd917f6898a8c1f723121dd1027dc7a61670554bd3b886d7c5ad5", "_filesize": 152649, "_sha256": "70a16578b01fd917f6898a8c1f723121dd1027dc7a61670554bd3b886d7c5ad5", "_expires": "2027-01-04T10:15:08.000Z", "_created": "2026-09-26T10:10:26.000Z", "_published": "2026-09-26T10:15:10.259Z", "_jobs": [ { "job": 108385049822, "time": 143, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "10903098703" }, { "job": 108385049935, "time": 175, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "10903892348" }, { "job": 108385049870, "time": 109, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "10903722984" }, { "job": 108385049806, "time": 130, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "10904195863" }, { "job": 108384522327, "time": 230, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10904350142" }, { "job": 108385049856, "time": 129, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10904066104" }, { "job": 108385049839, "time": 80, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "10904080985" }, { "job": 108385049838, "time": 78, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "ERROR", "artifact": "10904375175" }, { "job": 108385049830, "time": 82, "config": "windows-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "10903867373" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424", "_status": "success", "_upstream": "https://github.com/data-cleaning/validatedb", "_commit": { "id": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "author": "Edwin de Jonge ", "committer": "Edwin de Jonge ", "message": "fixing cran checks\n", "time": 1654265342 }, "_maintainer": { "name": "Edwin de Jonge", "email": "edwindjonge@gmail.com", "login": "edwindj", "bluesky": "@edwindjonge.bsky.social", "orcid": "0000-0002-6580-4718", "twitter": "@edwindjonge", "description": "", "uuid": 542492 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "validate", "role": "Depends" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "covr", "role": "Suggests" } ], "_owner": "data-cleaning", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "database", "datacleaning", "validation" ], "_stars": 33, "_contributors": [ { "user": "edwindj", "count": 78, "uuid": 542492 }, { "user": "markvanderloo", "count": 2, "uuid": 1927426 } ], "_userbio": { "uuid": 542492, "type": "user", "name": "Edwin de Jonge", "followers": 175 }, "_downloads": { "count": 17, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/validatedb" }, "_devurl": "https://github.com/data-cleaning/validatedb", "_searchresults": 4, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/validatedb.html" ], "_cranurl": false, "_releases": [ { "version": "0.1.3", "date": "2021-03-18" }, { "version": "0.1.4", "date": "2021-10-06" } ], "_exports": [ "check_rules", "compute", "confront", "confront.tbl_sql", "dump_sql", "show_query", "tbl", "values" ], "_help": [ { "page": "aggregate.tbl_validation", "title": "Count the number of invalid rules or records.", "topics": [ "aggregate.tbl_validation" ] }, { "page": "as.data.frame.tbl_validation", "title": "Retrieve validation results as a data.frame", "topics": [ "as.data.frame.tbl_validation" ] }, { "page": "check_rules", "title": "Check validation rules on the database", "topics": [ "check_rules" ] }, { "page": "compute.tbl_validation", "title": "Store the validation result in the db", "concept": [ "tbl_validation" ], "topics": [ "compute.tbl_validation" ] }, { "page": "confront_tbl_sparse", "title": "Create a sparse confrontation query", "concept": [ "confront" ], "topics": [ "confront_tbl_sparse" ] }, { "page": "confront.tbl_sql", "title": "Validate data in database 'tbl' with 'validator' rules.", "concept": [ "validation" ], "topics": [ "confront,ANY,validator,ANY-method", "confront.tbl_sql" ] }, { "page": "dump_sql", "title": "dump sql statements", "topics": [ "dump_sql" ] }, { "page": "rule_works_on_tbl", "title": "tests for each rule if it can be executed on the database", "topics": [ "rule_works_on_tbl" ] }, { "page": "show_query.tbl_validation", "title": "Show generated sql code", "topics": [ "show_query.tbl_validation" ] }, { "page": "tbl_validation-class", "title": "Validation object for 'tbl' object", "concept": [ "tbl_validation", "validation" ], "topics": [ "tbl_validation", "tbl_validation-class" ] }, { "page": "values-tbl_validation-method", "title": "Retrieve the result of a validation/confrontation", "concept": [ "validation" ], "topics": [ "values,tbl_validation-method" ] } ], "_readme": "https://github.com/data-cleaning/validatedb/raw/HEAD/README.md", "_rundeps": [ "blob", "cli", "cpp11", "DBI", "dbplyr", "dplyr", "generics", "glue", "lifecycle", "magrittr", "pillar", "pkgconfig", "purrr", "R6", "rlang", "settings", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "validate", "vctrs", "withr", "yaml" ], "_score": 3.2174839442139063, "_indexed": false, "_nocasepkg": "validatedb", "_universes": [ "edwindj" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.2.9000", "date": "2026-09-26T10:12:41.000Z", "distro": "resolute", "commit": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "fileid": "https://r2.ropensci.org/c327aeba454a4fe2608464cb5cd46b10ca33de6cf2e6cda652bd461f4fe3caa8", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424" }, { "r": "4.6.1", "os": "linux", "version": "0.3.2.9000", "date": "2026-09-26T10:13:17.000Z", "distro": "resolute", "commit": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "fileid": "https://r2.ropensci.org/5d5c68a8aa2729189b8ce56db032f9acb69aad1755f41d349f86301ddbbbd0a5", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424" }, { "r": "4.5.3", "os": "mac", "version": "0.3.2.9000", "date": "2026-09-26T10:14:17.000Z", "commit": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "fileid": "https://r2.ropensci.org/06008d455809eb7541107e3ea0c9cc667de1581017d8f448536ce64385db533e", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424" }, { "r": "4.6.1", "os": "mac", "version": "0.3.2.9000", "date": "2026-09-26T10:13:31.000Z", "commit": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "fileid": "https://r2.ropensci.org/4e6554b01fa4c402b29926ec1ba7e3980850a9906b8c33276f3b113e7a2de0a0", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.2.9000", "date": "2026-09-26T10:12:55.000Z", "commit": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "fileid": "https://r2.ropensci.org/2c0f6f5ade41c9e4b14288bdb8f5ab99a24648adb1f83a96556502ef58e83690", "status": "success", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424" }, { "r": "4.7.0", "os": "win", "version": "0.3.2.9000", "date": "2026-09-26T10:11:32.000Z", "commit": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "fileid": "https://r2.ropensci.org/b989b5fa5506027c2082c588688a45a8c31eeac36abe98d1714789da4f57e033", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424" }, { "r": "4.5.3", "os": "win", "version": "0.3.2.9000", "date": "2026-09-26T10:11:37.000Z", "commit": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "fileid": "https://r2.ropensci.org/2517761f8d9bfabe3e7233251f94c8ebcf93ad72c5a3c496584f24d8eec3cebc", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424" }, { "r": "4.6.1", "os": "win", "version": "0.3.2.9000", "date": "2026-09-26T10:11:44.000Z", "commit": "935f1ba79cc37ea30b46e5c11405f09147fc9357", "fileid": "https://r2.ropensci.org/78e3c2c7e58d64cb96eb029a81230bb3c2437d36a656f7b34ff1ff44933f4fe7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/36234784424" } ] }