{ "_id": "6a10298dacfb0bcc41c9176c", "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-05-13 07:33:14 UTC", "User": "root" }, "Author": "Robert Ashton [aut, cre]", "Maintainer": "Robert Ashton ", "MD5sum": "d6ffe4422d2bde3c3f9c255ed1b2f6d4", "_user": "vimc", "_type": "src", "_file": "dettl_0.1.0.tar.gz", "_fileid": "5db8124fb038a20897c317598df1759ad8933ea2db38c54a9b784c63936034f0", "_filesize": 237181, "_sha256": "5db8124fb038a20897c317598df1759ad8933ea2db38c54a9b784c63936034f0", "_created": "2026-05-13T07:33:14.000Z", "_published": "2026-05-22T10:01:49.851Z", "_distro": "noble", "_jobs": [ { "job": 77357675728, "time": 144, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "6964183703" }, { "job": 77357675838, "time": 157, "config": "linux-release-x86_64", "r": "4.6.0", "check": "ERROR", "artifact": "6964189178" }, { "job": 77357675746, "time": 142, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "ERROR", "artifact": "6964182454" }, { "job": 77357675919, "time": 115, "config": "macos-release-arm64", "r": "4.6.0", "check": "ERROR", "artifact": "6964174258" }, { "job": 77357675071, "time": 218, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6964138298" }, { "job": 77357675062, "time": 121, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7157858140" }, { "job": 77357675501, "time": 233, "config": "windows-devel", "r": "4.7.0", "check": "ERROR", "artifact": "6964210830" }, { "job": 77357675850, "time": 218, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "6964205984" }, { "job": 77357675751, "time": 242, "config": "windows-release", "r": "4.6.0", "check": "ERROR", "artifact": "6964213826" } ], "_buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242", "_status": "success", "_host": "GitHub-Actions", "_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", "uuid": 39248272 }, "_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" }, "_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.0", "_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", "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", "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-05-13T07:35:30.000Z", "distro": "noble", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "88e4209204e8f997b08322269a991b2781489b1bae070e54c1ce0591b9c17a2a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-05-13T07:35:48.000Z", "distro": "noble", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "b70f53ce1d52a607feba4f3a66c53f3bfeda326cdcf0c7d66871ce2cf45c3ce7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-05-13T07:35:21.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "5aa3d40d543fd3ee0cf76e1949139041d466e6c24d86b4e6ec7a537677ed03df", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-05-13T07:34:59.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "90d0b6cd1e686925b5889cc2b766020368b6d727155d539e0544120eda1f070c", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-05-13T07:34:47.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "285da1d043164e60e9313bc26539b95c5a6f8d8781d03039d699d8d9b0bd8ed7", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-05-13T07:34:28.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "6457b0b4b3e50533cd78bcabffe07460e0ff1b64c667e5027f0f5baaf6e8f873", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-05-13T07:34:44.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "9b0d124f1f0c8eb2ddf76321893b061fcaaabb5b2087d9b2442bf1f053ac5455", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-05-22T10:00:57.000Z", "commit": "79918d4273ac0bb71aa6bf37b564332757e5603a", "fileid": "b1a14845ecb5a156cf8aa69c9c9eac6e7ac515ddacee43e80fe2a9a7608380f2", "status": "success", "buildurl": "https://github.com/r-universe/vimc/actions/runs/25784921242" } ] }