{ "_id": "6a1410e6acfb0bcc41d3b670", "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-05-25 08:58:26 UTC", "User": "root" }, "Author": "Edwin de Jonge [aut, cre] (ORCID:\n),\nWytze Gelderloos [ctb]", "Maintainer": "Edwin de Jonge ", "MD5sum": "0607bcda6e18888123ef0c2d193c88e1", "_user": "edwindj", "_type": "src", "_file": "dcmodifydb_0.3.1.tar.gz", "_fileid": "b4600322a56f60c733c555c607fe8ef4f5b46ba49a7b85915bd5659bfe4c1763", "_filesize": 137636, "_sha256": "b4600322a56f60c733c555c607fe8ef4f5b46ba49a7b85915bd5659bfe4c1763", "_created": "2026-05-25T08:58:26.000Z", "_published": "2026-05-25T09:05:42.577Z", "_distro": "noble", "_jobs": [ { "job": 77685042290, "time": 147, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "7195092582" }, { "job": 77685042273, "time": 150, "config": "linux-release-x86_64", "r": "4.6.0", "check": "ERROR", "artifact": "7195093082" }, { "job": 77685042254, "time": 80, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "7195074570" }, { "job": 77685042233, "time": 92, "config": "macos-release-arm64", "r": "4.6.0", "check": "ERROR", "artifact": "7195077635" }, { "job": 77684613746, "time": 197, "config": "source", "r": "4.6.0", "check": "ERROR", "artifact": "7195053338" }, { "job": 77685042268, "time": 106, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7195081688" }, { "job": 77685042262, "time": 93, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "7195078091" }, { "job": 77685042261, "time": 90, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "7195077443" }, { "job": 77685042256, "time": 399, "config": "windows-release", "r": "4.6.0", "check": "ERROR", "artifact": "7195156074" } ], "_buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513", "_status": "failure", "_host": "GitHub-Actions", "_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 }, "_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" }, "_downloads": { "count": 8, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dcmodifydb" }, "_devurl": "https://github.com/data-cleaning/dcmodifydb", "_searchresults": 14, "_rbuild": "4.6.0", "_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", "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.5440680443502757, "_indexed": false, "_nocasepkg": "dcmodifydb", "_universes": [ "edwindj" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.1", "date": "2026-05-25T09:00:41.000Z", "distro": "noble", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "32323eedaa757180da88b8b7fea4d6745a88109024e36ceee71657e3ed351cc3", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513" }, { "r": "4.6.0", "os": "linux", "version": "0.3.1", "date": "2026-05-25T09:00:42.000Z", "distro": "noble", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "54642887e5e07e628fc237204b022c22782d9f8a94069867a2c10ede935991ef", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513" }, { "r": "4.5.3", "os": "mac", "version": "0.3.1", "date": "2026-05-25T08:59:45.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "42f479ec711f8e56832339e2e90000acdd2bb82da822fbe8d7b86bceb6c3eba1", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513" }, { "r": "4.6.0", "os": "mac", "version": "0.3.1", "date": "2026-05-25T08:59:55.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "72cdc11682ec2630873ce59ce236ea90cbdd1bb1160d2ca9695258793c8dce9e", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.1", "date": "2026-05-25T09:00:30.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "9b9b15f0296db6514a49d2b1abcd6848980970e39347269d0a3e68496e8e51b8", "status": "success", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513" }, { "r": "4.7.0", "os": "win", "version": "0.3.1", "date": "2026-05-25T08:59:42.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "72cbdf0f6b2791fe829923bdf7e4655d5665f898113740d492edb20cdb68d76a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513" }, { "r": "4.5.3", "os": "win", "version": "0.3.1", "date": "2026-05-25T08:59:40.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "d19a67f5c50be1cf99d0f5c852226abcc8efb5e9255448a5845ebba6f3797da7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513" }, { "r": "4.6.0", "os": "win", "version": "0.3.1", "date": "2026-05-25T09:04:47.000Z", "commit": "dd34c40ebefd4febee335ed3805594eda8e237ff", "fileid": "08800b6dc64824f9cbb3d6c3a3ccee74e1bf1fcd6ea1bba0e5bf232b9b07c9a3", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/edwindj/actions/runs/26392277513" } ] }