{
  "_id": "6a1efad6b401979e734188db",
  "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-05-18 11:09:24 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": "c273b666c21db9d0242e92ca19d5a65a",
  "_user": "darwin-eu",
  "_type": "src",
  "_file": "TestGenerator_0.8.0.tar.gz",
  "_fileid": "637efdb27a24b585495a45e36a0999c5e31734b15084187acf24e3b4ad3f3d0a",
  "_filesize": 829375,
  "_sha256": "637efdb27a24b585495a45e36a0999c5e31734b15084187acf24e3b4ad3f3d0a",
  "_created": "2026-05-18T11:09:24.000Z",
  "_published": "2026-06-02T15:46:30.019Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 79111891011,
      "time": 266,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7056255084"
    },
    {
      "job": 79111891202,
      "time": 256,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7056252271"
    },
    {
      "job": 79111890836,
      "time": 268,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7056255748"
    },
    {
      "job": 79111890868,
      "time": 241,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7056247286"
    },
    {
      "job": 79111890289,
      "time": 194,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7056169641"
    },
    {
      "job": 79111889916,
      "time": 132,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7362721477"
    },
    {
      "job": 79111891000,
      "time": 299,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7056265753"
    },
    {
      "job": 79111891729,
      "time": 245,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7056248690"
    },
    {
      "job": 79111890995,
      "time": 225,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7056242336"
    }
  ],
  "_buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882",
  "_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": "2025-22",
      "n": 1
    },
    {
      "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.4.0",
      "date": "2025-05-30"
    },
    {
      "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": 51,
      "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",
    "description": "DARWIN EU® will deliver real-world evidence from across Europe on diseases, populations and the uses and performance of medicines."
  },
  "_downloads": {
    "count": 656,
    "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": 10,
  "_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"
    }
  ],
  "_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",
    "gh",
    "gitcreds",
    "glue",
    "hms",
    "httr",
    "httr2",
    "ini",
    "jsonlite",
    "lifecycle",
    "lubridate",
    "magrittr",
    "mime",
    "omopgenerics",
    "openssl",
    "openxlsx",
    "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.2552725051033065,
  "_indexed": true,
  "_nocasepkg": "testgenerator",
  "_universes": [
    "darwin-eu"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.8.0",
      "date": "2026-05-18T11:11:43.000Z",
      "distro": "noble",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "64a03f6fc8738db2cb2f6ce7c891d69ebfe13eb73dafab5f5cdf637c6c1891eb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.8.0",
      "date": "2026-05-18T11:11:36.000Z",
      "distro": "noble",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "7b93ca9b2aa90f6d34b661bb513d7b8913663541dc9f26f27359d362f22a7848",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.8.0",
      "date": "2026-05-18T11:11:35.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "6107960ffacf8b0d0d9a9fbbdf7c018d28ae8b9073297a8b5483528f42133439",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.8.0",
      "date": "2026-05-18T11:11:02.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "d8db919080defdb23dc8f9cd79222b757a74f67824dcce0c55bdd3ef20a495f4",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.8.0",
      "date": "2026-05-18T11:11:54.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "7e7033c2fa5d0a8a739cedc4102c570c4c8276153f92d5757c6022efdbd1ba01",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.8.0",
      "date": "2026-05-18T11:11:11.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "aa97e61bae32de9a7832ba503257beb99254d82ee998fc8972d69f39b0344cd7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.8.0",
      "date": "2026-05-18T11:10:53.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "7be9b20fdb6a326574d1f343ee5bb0d97b6b047abcbac3fe108fd952addce3d7",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.8.0",
      "date": "2026-06-02T15:46:02.000Z",
      "commit": "8f67c14384568bd1d05947e6c4e3d45cf9dd0458",
      "fileid": "bd05d164a17cf4563ca2fafa7bf8a406f69de28b2c378edfb7bd3cb3ed5e8ad1",
      "status": "success",
      "buildurl": "https://github.com/r-universe/darwin-eu/actions/runs/26029648882"
    }
  ]
}