{
  "_id": "6a3560cd3efcd9bda43eac04",
  "Package": "TestGenerator",
  "Type": "Package",
  "Title": "Integration Unit Tests for Pharmacoepidemiological Studies",
  "Version": "0.8.0",
  "Authors@R": "c(\nperson(\"Cesar\", \"Barboza\", , \"c.barboza@darwin-eu.org\", role = c(\"aut\", \"cre\"), comment = c(ORCID = \"0009-0002-4453-3071\")),\nperson(\"Ioanna\", \"Nika\", , \"i.nika@darwin-eu.org\", role = \"aut\"),\nperson(\"Ger\", \"Inberg\", , \"g.inberg@erasmusmc.nl\", role = c(\"aut\"), comment = c(ORCID = \"0000-0001-8993-8748\")),\nperson(\"Adam\", \"Black\", , \"black@ohdsi.org\", role = \"aut\", comment = c(ORCID = \"0000-0001-5576-8701\"))\n)",
  "Maintainer": "Cesar Barboza <c.barboza@darwin-eu.org>",
  "Description": "An R interface to load testing data in the 'OMOP' Common\nData Model ('CDM'). An input file, csv or xlsx, can be\nconverted to a 'CDMConnector' object. This object can be used\nto execute and test studies that use the 'CDM'\n<https://www.ohdsi.org/data-standardization/>.",
  "License": "Apache License (>= 2)",
  "Encoding": "UTF-8",
  "RoxygenNote": "7.3.3",
  "VignetteBuilder": "knitr",
  "Config/testthat/edition": "3",
  "URL": "https://github.com/darwin-eu/TestGenerator,\nhttps://darwin-eu.github.io/TestGenerator/",
  "BugReports": "https://github.com/darwin-eu/TestGenerator/issues",
  "Config/pak/sysreqs": "cmake git make libgit2-dev libicu-dev libuv1-dev\nlibssl-dev libpq-dev libx11-dev xz-utils",
  "Repository": "https://darwin-eu.r-universe.dev",
  "Date/Publication": "2026-05-18 09:52:25 UTC",
  "RemoteUrl": "https://github.com/darwin-eu/testgenerator",
  "RemoteRef": "HEAD",
  "RemoteSha": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-06-19 14:39:08 UTC",
    "User": "root"
  },
  "Author": "Cesar Barboza [aut, cre] (ORCID:\n<https://orcid.org/0009-0002-4453-3071>),\nIoanna Nika [aut],\nGer Inberg [aut] (ORCID: <https://orcid.org/0000-0001-8993-8748>),\nAdam Black [aut] (ORCID: <https://orcid.org/0000-0001-5576-8701>)",
  "MD5sum": "d88b42575b64fabacaf7a1e7e841fe63",
  "_user": "darwin-eu",
  "_type": "src",
  "_file": "TestGenerator_0.8.0.tar.gz",
  "_fileid": "121f304decfeddb272a5570c20ab290a559e483380aaeb14886fbdce43ea9f09",
  "_filesize": 831361,
  "_sha256": "121f304decfeddb272a5570c20ab290a559e483380aaeb14886fbdce43ea9f09",
  "_created": "2026-06-19T14:39:08.000Z",
  "_published": "2026-06-19T15:31:25.587Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 82371272517,
      "time": 256,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7752480630"
    },
    {
      "job": 82371272489,
      "time": 264,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7752482823"
    },
    {
      "job": 82371272493,
      "time": 198,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7752461935"
    },
    {
      "job": 82371272653,
      "time": 216,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7752467162"
    },
    {
      "job": 82370655556,
      "time": 224,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7752397060"
    },
    {
      "job": 82371272534,
      "time": 130,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7752440975"
    },
    {
      "job": 82371272543,
      "time": 3103,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7753406788"
    },
    {
      "job": 82371272540,
      "time": 3017,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7753379749"
    },
    {
      "job": 82371272538,
      "time": 2953,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7753358921"
    }
  ],
  "_buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/darwin-eu/testgenerator",
  "_commit": {
    "id": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
    "author": "github-actions[bot] <github-actions[bot]@users.noreply.github.com>",
    "committer": "github-actions[bot] <github-actions[bot]@users.noreply.github.com>",
    "message": "chore: prepare public release\n\nSource-Repository: darwin-eu-dev/TestGenerator\n\nSource-Branch: develop\n",
    "time": 1779097945
  },
  "_maintainer": {
    "name": "Cesar Barboza",
    "email": "c.barboza@darwin-eu.org"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "jsonlite",
      "role": "Imports"
    },
    {
      "package": "readxl",
      "role": "Imports"
    },
    {
      "package": "readr",
      "role": "Imports"
    },
    {
      "package": "CDMConnector",
      "version": ">= 2.5.1",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "checkmate",
      "role": "Imports"
    },
    {
      "package": "glue",
      "role": "Imports"
    },
    {
      "package": "duckdb",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "withr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "role": "Imports"
    },
    {
      "package": "openxlsx",
      "role": "Imports"
    },
    {
      "package": "omopgenerics",
      "role": "Imports"
    },
    {
      "package": "RPostgres",
      "role": "Imports"
    },
    {
      "package": "fs",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "usethis",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "curl",
      "role": "Suggests"
    },
    {
      "package": "httr",
      "role": "Suggests"
    },
    {
      "package": "odbc",
      "role": "Suggests"
    },
    {
      "package": "CohortConstructor",
      "role": "Suggests"
    }
  ],
  "_owner": "darwin-eu",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-03",
      "n": 2
    },
    {
      "week": "2026-16",
      "n": 3
    },
    {
      "week": "2026-18",
      "n": 1
    },
    {
      "week": "2026-20",
      "n": 17
    },
    {
      "week": "2026-21",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "v0.6.0",
      "date": "2026-04-16"
    },
    {
      "name": "v0.7.0",
      "date": "2026-05-01"
    },
    {
      "name": "v0.8.0",
      "date": "2026-05-17"
    }
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "cebarboza",
      "count": 177,
      "uuid": 113351542
    },
    {
      "user": "ginberg",
      "count": 37,
      "uuid": 7089667
    },
    {
      "user": "ioannanika",
      "count": 11,
      "uuid": 45609421
    }
  ],
  "_userbio": {
    "uuid": 120334168,
    "type": "organization",
    "name": "Darwin EU® Public Code Repository",
    "followers": 59,
    "description": "DARWIN EU® will deliver real-world evidence from across Europe on diseases, populations and the uses and performance of medicines."
  },
  "_downloads": {
    "count": 632,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/TestGenerator"
  },
  "_devurl": "https://github.com/darwin-eu/testgenerator",
  "_pkgdown": "https://darwin-eu.github.io/TestGenerator/",
  "_searchresults": 11,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/TestGenerator.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/darwin-eu/testgenerator",
  "_realowner": "darwin-eu",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.2.5",
      "date": "2024-02-01"
    },
    {
      "version": "0.3.1",
      "date": "2024-05-28"
    },
    {
      "version": "0.3.3",
      "date": "2024-11-08"
    },
    {
      "version": "0.4.0",
      "date": "2025-05-27"
    },
    {
      "version": "0.5.0",
      "date": "2026-01-14"
    },
    {
      "version": "0.6.0",
      "date": "2026-04-16"
    },
    {
      "version": "0.7.0",
      "date": "2026-04-30"
    },
    {
      "version": "0.8.0",
      "date": "2026-05-26"
    }
  ],
  "_exports": [
    "cleanupTestCdm",
    "downloadTestData",
    "generateTestTables",
    "graphCohort",
    "patientsCDM",
    "readPatients",
    "readPatients.csv",
    "readPatients.xl",
    "useGithubAction"
  ],
  "_help": [
    {
      "page": "checkRemoteFileAvailable",
      "title": "Check if a given remote file is available for download",
      "topics": [
        "checkRemoteFileAvailable"
      ]
    },
    {
      "page": "checkTablesColumns",
      "title": "Check if the given tables and columns are valid and return the loaded data.",
      "topics": [
        "checkTablesColumns"
      ]
    },
    {
      "page": "cleanupTestCdm",
      "title": "Clean up a test CDM on a remote database",
      "topics": [
        "cleanupTestCdm"
      ]
    },
    {
      "page": "downloadTestData",
      "title": "Download Test Data Files",
      "topics": [
        "downloadTestData"
      ]
    },
    {
      "page": "generateTestTables",
      "title": "Generates an Excel file with sheets that correspond to an OMOP-CDM tables.",
      "topics": [
        "generateTestTables"
      ]
    },
    {
      "page": "graphCohort",
      "title": "Deprecated cohort timeline visualisation",
      "topics": [
        "graphCohort"
      ]
    },
    {
      "page": "patientsCDM",
      "title": "Pushes test population into a blank CDM.",
      "topics": [
        "patientsCDM"
      ]
    },
    {
      "page": "readPatients",
      "title": "Converts a sample of patients into Unit Testing Definition JSON file.",
      "topics": [
        "readPatients"
      ]
    },
    {
      "page": "readPatients.csv",
      "title": "Converts a sample of patients in CSV format into a Unit Testing Definition JSON file.",
      "topics": [
        "readPatients.csv"
      ]
    },
    {
      "page": "readPatients.xl",
      "title": "Converts a sample of patients in XLSX format into Unit Testing Definition JSON file.",
      "topics": [
        "readPatients.xl"
      ]
    },
    {
      "page": "useGithubAction",
      "title": "Create GitHub Action workflows for specific DBMS",
      "topics": [
        "useGithubAction"
      ]
    }
  ],
  "_readme": "https://github.com/darwin-eu/testgenerator/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "backports",
    "bit",
    "bit64",
    "blob",
    "brio",
    "callr",
    "CDMConnector",
    "cellranger",
    "checkmate",
    "cli",
    "clipr",
    "cpp11",
    "crayon",
    "credentials",
    "curl",
    "DBI",
    "dbplyr",
    "desc",
    "diffobj",
    "dplyr",
    "duckdb",
    "evaluate",
    "fs",
    "generics",
    "gert",
    "gitcreds",
    "glue",
    "hms",
    "httr2",
    "ini",
    "jsonlite",
    "lifecycle",
    "lubridate",
    "magrittr",
    "omopgenerics",
    "openssl",
    "openxlsx",
    "otel",
    "pillar",
    "pkgbuild",
    "pkgconfig",
    "pkgload",
    "praise",
    "prettyunits",
    "processx",
    "progress",
    "ps",
    "purrr",
    "R6",
    "rappdirs",
    "Rcpp",
    "readr",
    "readxl",
    "rematch",
    "rlang",
    "RPostgres",
    "rprojroot",
    "rstudioapi",
    "snakecase",
    "stringi",
    "stringr",
    "sys",
    "testthat",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "tzdb",
    "usethis",
    "utf8",
    "vctrs",
    "vroom",
    "waldo",
    "whisker",
    "withr",
    "yaml",
    "zip"
  ],
  "_vignettes": [
    {
      "source": "gettingStarted.Rmd",
      "filename": "gettingStarted.html",
      "title": "Getting started with TestGenerator",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Create a Unit Test Definition",
        "Load the Test Population into a CDM",
        "Use the CDM in Unit Tests",
        "Start from a Blank Excel Template",
        "CSV Inputs",
        "Clean Up"
      ],
      "created": "2026-04-30 17:06:38",
      "modified": "2026-05-17 20:43:04",
      "commits": 3
    },
    {
      "source": "githubActions.Rmd",
      "filename": "githubActions.html",
      "title": "GitHub Actions",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Create the workflow files",
        "Add the expected test files",
        "PostgreSQL and SQL Server actions",
        "Databricks action",
        "Suggested CI workflow"
      ],
      "created": "2026-05-17 20:43:04",
      "modified": "2026-05-17 20:43:04",
      "commits": 1
    },
    {
      "source": "remoteDatabases.Rmd",
      "filename": "remoteDatabases.html",
      "title": "Remote databases",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Use patientsCDM() with a remote database",
        "Environment variables for direct use",
        "A minimal backend test pattern"
      ],
      "created": "2026-05-17 20:43:04",
      "modified": "2026-05-17 20:43:04",
      "commits": 1
    }
  ],
  "_score": 5.217483944213907,
  "_indexed": true,
  "_nocasepkg": "testgenerator",
  "_universes": [
    "darwin-eu"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.8.0",
      "date": "2026-06-19T14:41:48.000Z",
      "distro": "noble",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "2a0c2a5feb355b202887edf3a4f42b252bb087a3d75b4b3c4416b7ce2746171a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.8.0",
      "date": "2026-06-19T14:41:48.000Z",
      "distro": "noble",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "4fe95305ad82fb9c7d4b4e1d2049a1c9fd16f9c24fcbe15fb3563cfba461228b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.8.0",
      "date": "2026-06-19T14:40:51.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "79b30554002cf5a2c57e4eccdd66b569ed53a1e8193b1d6766088dd4b62709a6",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.8.0",
      "date": "2026-06-19T14:40:59.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "c6eca5c2fde661060d615a01600d7bace47769522b28d5d9d6a44ff3f65d86db",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.8.0",
      "date": "2026-06-19T14:41:37.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "2d678223af0b2b961cda6f252135cb6adc393208151517482f08f2cebee14089",
      "status": "success",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.8.0",
      "date": "2026-06-19T15:28:24.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "2e989f099acbf7b1904ea7df308158148d739587dadd60e56635aee14b30a576",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.8.0",
      "date": "2026-06-19T15:27:35.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "341000ab71837f04fc9c675eae063f272e5cd04dd1ee6def2f96ce8f03079166",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.8.0",
      "date": "2026-06-19T15:26:11.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "f537a53742380fd0a6eb014a3b6a48fe1e679383188d7693d470a03f010301cd",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/27831938973"
    }
  ]
}