{ "_id": "6acb3e96fe5cc25786e8cae9", "Package": "dettl", "Title": "Data Extract, Transform, Test and Load", "Version": "0.1.0", "Authors@R": "person(given = \"Robert\",\nfamily = \"Ashton\",\nrole = c(\"aut\", \"cre\"),\nemail = \"r.ashton@imperial.ac.uk\")", "Description": "Data extract, transform, test and load tool for sanitising\nyour workflow.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "7.2.1", "VignetteBuilder": "knitr", "Language": "en-GB", "Config/pak/sysreqs": "cmake git make libgit2-dev libuv1-dev libssl-dev\nzlib1g-dev", "Repository": "https://vimc.r-universe.dev", "Date/Publication": "2022-09-29 08:48:36 UTC", "RemoteUrl": "https://github.com/vimc/dettl", "RemoteRef": "master", "RemoteSha": "79918d4273ac0bb71aa6bf37b564332757e5603a", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-10 08:49:24 UTC", "User": "root" }, "Author": "Robert Ashton [aut, cre]", "Maintainer": "Robert Ashton ", "_user": "vimc", "_type": "src", "_file": "dettl_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/91b4427e5d3b7e26f9dd321adc4ac5c0faf0a1820727a2d15b695a3c0309a32b", "_filesize": 237055, "_sha256": "91b4427e5d3b7e26f9dd321adc4ac5c0faf0a1820727a2d15b695a3c0309a32b", "_expires": "2027-01-18T09:19:11.000Z", "_created": "2026-10-10T08:49:24.000Z", "_published": "2026-10-11T07:45:26.743Z", "_buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 114418060020, "time": 138, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "11695737080" }, { "job": 114418060029, "time": 140, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "11694829798" }, { "job": 114418059975, "time": 94, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "11696160058" }, { "job": 114418059982, "time": 115, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "11695024345" }, { "job": 114418060398, "time": 187, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11664787945" }, { "job": 114418061012, "time": 103, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11665385654" }, { "job": 114418060065, "time": 245, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "11695199063" }, { "job": 114418060038, "time": 229, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "ERROR", "artifact": "11695403985" }, { "job": 114418060014, "time": 213, "config": "windows-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "11695159233" } ], "_upstream": "https://github.com/vimc/dettl", "_commit": { "id": "79918d4273ac0bb71aa6bf37b564332757e5603a", "author": "Rob <39248272+r-ash@users.noreply.github.com>", "committer": "GitHub ", "message": "Merge pull request #64 from vimc/vimc-6754\n\nAdd ability for dettl auto load to handle tables in different schemas", "time": 1664441316 }, "_maintainer": { "name": "Robert Ashton", "email": "r.ashton@imperial.ac.uk", "login": "r-ash", "description": "🚀 Senior Software Engineer @ Avenir Health 🛠️ Building tools and web applications for epidemiologists and public health program planners", "uuid": 39248272 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.5.0", "role": "Depends" }, { "package": "bit64", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "gert", "role": "Imports" }, { "package": "R6", "role": "Imports" }, { "package": "testthat", "role": "Imports" }, { "package": "yaml", "role": "Imports" }, { "package": "withr", "role": "Imports" }, { "package": "writexl", "role": "Imports" }, { "package": "docopt", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "mockery", "role": "Suggests" }, { "package": "readxl", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RPostgres", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "vaultr", "version": ">= 0.2.2", "role": "Suggests" } ], "_owner": "vimc", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 1, "_contributors": [ { "user": "r-ash", "count": 515, "uuid": 39248272 }, { "user": "richfitz", "count": 78, "uuid": 1558093 }, { "user": "weshinsley", "count": 39, "uuid": 9009312 } ], "_userbio": { "uuid": 26278316, "type": "organization", "name": "Vaccine Impact Modelling Consortium", "followers": 14 }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dettl" }, "_devurl": "https://github.com/vimc/dettl", "_searchresults": 1, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dettl.html", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_cranurl": false, "_exports": [ "dettl", "dettl_auto_load", "dettl_create_log_table", "dettl_new", "dettl_run", "dettl_save" ], "_help": [ { "page": "dettl", "title": "Create an import object using functions defined at specified path", "topics": [ "dettl" ] }, { "page": "dettl_auto_load", "title": "Automatic load function for append mode imports.", "topics": [ "dettl_auto_load" ] }, { "page": "dettl_create_log_table", "title": "Initialise the database by creating log table if it doesn't already exist", "topics": [ "dettl_create_log_table" ] }, { "page": "dettl_new", "title": "Create new directory and templated code for new dettl process.", "topics": [ "dettl_new" ] }, { "page": "dettl_run", "title": "Run specified stages of an import", "topics": [ "dettl_run" ] }, { "page": "dettl_save", "title": "Save data", "topics": [ "dettl_save" ] }, { "page": "prepare_test_import", "title": "Prepare example import inside a git repo", "topics": [ "prepare_test_import" ] }, { "page": "RImport", "title": "Manage R based data import.", "topics": [ "RImport" ] }, { "page": "SqlImport", "title": "Manage SQL based data import.", "topics": [ "SqlImport" ] } ], "_readme": "https://github.com/vimc/dettl/raw/master/README.md", "_rundeps": [ "askpass", "bit", "bit64", "brio", "callr", "cli", "crayon", "credentials", "curl", "DBI", "desc", "diffobj", "evaluate", "fs", "gert", "glue", "jsonlite", "lifecycle", "magrittr", "openssl", "otel", "pkgbuild", "pkgload", "praise", "processx", "ps", "R6", "rlang", "rprojroot", "rstudioapi", "sys", "testthat", "waldo", "withr", "writexl", "yaml", "zip" ], "_vignettes": [ { "source": "dettl.Rmd", "filename": "dettl.html", "title": "Using dettl for importing data", "author": "Robert Ashton", "engine": "knitr::rmarkdown", "headings": [ "ETL", "Repository setup", "dettl_config.yml", "Creating a new ETL import", "Developing the import", "Extract", "Transform", "Load", "Running the import", "Run functions", "Working with import object", "Dry run", "Other stuff", "I want to write an import which creates a table", "I want to write a custom load", "I want to use the automatic load but make additional changes to the database", "What about cycles?" ], "created": "2019-02-11 17:47:16", "modified": "2020-11-03 16:27:05", "commits": 17 } ], "_score": 3, "_indexed": true, "_nocasepkg": "dettl", "_universes": [ "vimc", "r-ash" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-10-11T07:36:55.000Z", "distro": "resolute", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/7fb92c35590551b1d4ff532693f13e124355f78387a6f06e43394a0dadea7cd0", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-10-11T07:36:56.000Z", "distro": "resolute", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/3ead52158f1a8f6b16806f7f12920e576051231b4e3bdd15afa61b1768d9b339", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-10-11T07:44:26.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/5b4ae78b9f37658a51e372d31d3ee51bd504f3786c64535a13c878af9c3509d2", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-10-11T07:37:49.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/4105ccc77195f8e485535e101756af0dfabcf5a7c41796f21d4c330bfde52011", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-10-10T08:51:26.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/97ba5fceede3c01b347578de7438668b6f62c8b2b03c5de89470d3a00340c305", "status": "success", "buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-10-11T07:36:09.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/47143640e6ae4daf9731c7c6c35e45c89b4422cd64160e23d5619aa1a95c2c3b", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-10-11T07:36:16.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/36202c190e5564a12debf5dab29486f156dc23983d7c4123f539d7cb4b75db0c", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-10-11T07:35:59.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/b9ebd29aa429de411f1ad8ae88614f91d6a9753881ec7a40d8a43266a28e9990", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/38039031815" } ] }