{ "_id": "6a53418f9b92047c28d572e3", "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-07-12 07:21:45 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/df4ae8055a8c3086af88a7a9772c7377f93672f4dc6054fa8f5be9cdcf0a6b5d", "_filesize": 237480, "_sha256": "df4ae8055a8c3086af88a7a9772c7377f93672f4dc6054fa8f5be9cdcf0a6b5d", "_expires": "2026-10-20T07:26:05.000Z", "_created": "2026-07-12T07:21:45.000Z", "_published": "2026-07-12T07:26:07.600Z", "_jobs": [ { "job": 86627061744, "time": 148, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "8257433835" }, { "job": 86627061699, "time": 150, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "8257433953" }, { "job": 86627061686, "time": 105, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "8257427763" }, { "job": 86627061693, "time": 88, "config": "macos-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "8257425798" }, { "job": 86626815208, "time": 206, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8257412737" }, { "job": 86627061694, "time": 113, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8257429121" }, { "job": 86627061713, "time": 222, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "8257444157" }, { "job": 86627061755, "time": 218, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "8257443506" }, { "job": 86627061727, "time": 216, "config": "windows-release", "r": "4.6.1", "check": "ERROR", "artifact": "8257443005" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928", "_status": "success", "_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/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE", "manual.pdf" ], "_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-07-12T07:24:06.000Z", "distro": "resolute", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/8470a46a2d78a3ff30a714b24a86b4d34c130d739f7dd91722aa7b379095ad56", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-07-12T07:24:05.000Z", "distro": "resolute", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/16b6825d17625d77d85256119c0ca3c195c455f8ac9d0e62e795d236e1cf654e", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-07-12T07:23:18.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/429657fe2a2d039985c09d1cf99f0fa64b50e15f333326931873fa27549cdaa1", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-07-12T07:23:12.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/39de84e61ed8f223dc8c6e2a99173cd979dd9c456d89e2a996833377b45fa33c", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-07-12T07:23:59.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/897c326c17fd7852bb12accebb650cced35c9530f56e327c567f575d3c36fef2", "status": "success", "buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-07-12T07:23:04.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/8b368eaf8c6d87c923777e9e0c2f39d6d492515cb2ff951d53af4b16fc9069ea", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-07-12T07:23:06.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/1fbf0c6f4cc4a27efa90d381715d509c6634ecede08f6004b0be130a0ffab34a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-07-12T07:22:59.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "https://r2.ropensci.org/0cff872a858c7faa85825ae3369766314a7b9a6016e789b5b752ca3e5534a7ae", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/29184020928" } ] }