{ "_id": "6a49e0422c82cd361482549f", "Package": "dcmodifydb", "Title": "Modifying Rules on a DataBase", "Version": "0.3.1", "Authors@R": "c(\nperson(given = \"Edwin\",\nfamily = \"de Jonge\",\nrole = c(\"aut\", \"cre\"),\nemail = \"edwindjonge@gmail.com\",\ncomment = c(ORCID = \"0000-0002-6580-4718\")),\nperson(given=\"Wytze\", family = \"Gelderloos\", role=c(\"ctb\"), email=\"\")\n)", "Description": "Apply modification rules from R package 'dcmodify' to the\ndatabase, prescribing and documenting deterministic data\ncleaning steps on records in a database. The rules are\ntranslated into SQL statements using R package 'dbplyr'.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "URL": "https://github.com/data-cleaning/dcmodifydb", "BugReports": "https://github.com/data-cleaning/dcmodifydb/issues", "VignetteBuilder": "knitr", "RoxygenNote": "7.2.0", "Config/testthat/edition": "3", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://edwindj.r-universe.dev", "Date/Publication": "2022-06-17 14:29:49 UTC", "RemoteUrl": "https://github.com/data-cleaning/dcmodifydb", "RemoteRef": "HEAD", "RemoteSha": "dd34c40ebefd4febee335ed3805594eda8e237ff", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-05 04:37:22 UTC", "User": "root" }, "Author": "Edwin de Jonge [aut, cre] (ORCID:\n),\nWytze Gelderloos [ctb]", "Maintainer": "Edwin de Jonge ", "_user": "edwindj", "_type": "src", "_file": "dcmodifydb_0.3.1.tar.gz", "_fileid": "https://r2.ropensci.org/fcc0308921e16d60d26ebc50fea036164a5d4ec8ee6a61966e05026c748bcf7c", "_filesize": 139688, "_sha256": "fcc0308921e16d60d26ebc50fea036164a5d4ec8ee6a61966e05026c748bcf7c", "_expires": "2026-10-13T04:40:33.000Z", "_created": "2026-07-05T04:37:22.000Z", "_published": "2026-07-05T04:40:34.452Z", "_jobs": [ { "job": 85193043941, "time": 159, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "8088357190" }, { "job": 85193043950, "time": 156, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "8088356903" }, { "job": 85193043949, "time": 93, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "8088350587" }, { "job": 85193043942, "time": 89, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "8088350249" }, { "job": 85192889184, "time": 178, "config": "source", "r": "4.6.1", "check": "ERROR", "artifact": "8088340946" }, { "job": 85193043939, "time": 114, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8088352613" }, { "job": 85193043956, "time": 79, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "8088349122" }, { "job": 85193043948, "time": 93, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "8088350711" }, { "job": 85193043953, "time": 91, "config": "windows-release", "r": "4.6.1", "check": "ERROR", "artifact": "8088350413" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551", "_status": "failure", "_upstream": "https://github.com/data-cleaning/dcmodifydb", "_commit": { "id": "dd34c40ebefd4febee335ed3805594eda8e237ff", "author": "Edwin de Jonge ", "committer": "Edwin de Jonge ", "message": "adding snaps\n", "time": 1655476189 }, "_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": "R", "version": ">= 4.0.0", "role": "Depends" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dcmodify", "version": ">= 0.1.9", "role": "Imports" }, { "package": "validate", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "covr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "data-cleaning", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "correction", "data-cleaning", "database" ], "_stars": 5, "_contributors": [ { "user": "edwindj", "count": 100, "uuid": 542492 }, { "user": "wytzepakito", "count": 7, "uuid": 23073102 } ], "_userbio": { "uuid": 542492, "type": "user", "name": "Edwin de Jonge", "followers": 175 }, "_downloads": { "count": 14, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dcmodifydb" }, "_devurl": "https://github.com/data-cleaning/dcmodifydb", "_searchresults": 17, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dcmodifydb.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_cranurl": false, "_releases": [ { "version": "0.1.2", "date": "2021-09-27" }, { "version": "0.2.0", "date": "2022-01-21" }, { "version": "0.3.1", "date": "2022-06-17" } ], "_exports": [ "dump_sql", "is_working_db", "modifier_to_sql", "modify" ], "_datasets": [ { "name": "person", "title": "Person data, income and smoking habits", "object": "person", "class": [ "data.frame" ], "fields": [ "income", "age", "gender", "year", "smokes", "cigarettes" ], "rows": 4, "table": true, "tojson": true } ], "_help": [ { "page": "dump_sql", "title": "Show generated sql", "concept": [ "sql translation" ], "topics": [ "dump_sql" ] }, { "page": "is_working_db", "title": "Rule check on the database", "topics": [ "is_working_db" ] }, { "page": "modifier_to_sql", "title": "Utility function to extract SQL statements", "concept": [ "sql translation" ], "topics": [ "modifier_to_sql" ] }, { "page": "modify-ANY-modifier-method", "title": "Apply corrections/derivations to a db table", "topics": [ "modify,ANY,modifier-method" ] }, { "page": "person", "title": "Person data, income and smoking habits", "topics": [ "person" ] } ], "_readme": "https://github.com/data-cleaning/dcmodifydb/raw/HEAD/README.md", "_rundeps": [ "blob", "cli", "cpp11", "DBI", "dbplyr", "dcmodify", "dplyr", "generics", "glue", "lifecycle", "lumberjack", "magrittr", "pillar", "pkgconfig", "purrr", "R6", "rlang", "settings", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "validate", "vctrs", "withr", "yaml" ], "_score": 2.6283889300503116, "_indexed": false, "_nocasepkg": "dcmodifydb", "_universes": [ "edwindj" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.1", "date": "2026-07-05T04:39:45.000Z", "distro": "resolute", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "https://r2.ropensci.org/f66859ce43270386bdd916af062b70ce63246b3194535aa295cf98b13e6fb415", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551" }, { "r": "4.6.1", "os": "linux", "version": "0.3.1", "date": "2026-07-05T04:39:44.000Z", "distro": "resolute", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "https://r2.ropensci.org/2635e174ea7d469fb96017ca5924beab6169c2c120877484fcbc8252e02da58d", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551" }, { "r": "4.5.3", "os": "mac", "version": "0.3.1", "date": "2026-07-05T04:38:52.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "https://r2.ropensci.org/63ada021e5734eca789d301147d8e3a61c9f94dab9a099e3db7aec8f34ff6c77", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551" }, { "r": "4.6.1", "os": "mac", "version": "0.3.1", "date": "2026-07-05T04:38:50.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "https://r2.ropensci.org/d57a8b59380ee823a2a41bbe82bc14359d57f5639a15e1933b195980d47344cd", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.1", "date": "2026-07-05T04:39:31.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "https://r2.ropensci.org/9361e4fc0073c0127a361c7d32170cc04bfaf8fe4f7a4fbe40260cc8760fe608", "status": "success", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551" }, { "r": "4.7.0", "os": "win", "version": "0.3.1", "date": "2026-07-05T04:38:24.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "https://r2.ropensci.org/13f94d5023292e1ebfc49c15c3f9e7f1182cffe40a6d277cbaa07f1b2b121046", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551" }, { "r": "4.5.3", "os": "win", "version": "0.3.1", "date": "2026-07-05T04:38:39.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "https://r2.ropensci.org/bbdf8322122e9ae821e556b24969b4cf9d206f90e13daef3e554c992c62805e3", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551" }, { "r": "4.6.1", "os": "win", "version": "0.3.1", "date": "2026-07-05T04:38:37.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "https://r2.ropensci.org/b70981b07f020f86912f2912dafd06bb74238d08605861ce6ed1758c5a580722", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/28729596551" } ] }