{ "_id": "6a12a9a3acfb0bcc41d15f06", "Package": "ResultModelManager", "Title": "Result Model Manager", "Version": "0.6.2", "Authors@R": "person(\"Jamie\", \"Gilbert\", , \"gilbert@ohdsi.org\", role = c(\"aut\", \"cre\"))", "Description": "Database data model management utilities for R packages in\nthe Observational Health Data Sciences and Informatics\nprogramme. 'ResultModelManager' provides utility functions to\nallow package maintainers to migrate existing SQL database\nmodels, export and import results in consistent patterns.", "URL": "https://github.com/OHDSI/ResultModelManager,\nhttps://ohdsi.github.io/ResultModelManager/", "BugReports": "https://github.com/OHDSI/ResultModelManager/issues", "License": "Apache License (== 2.0)", "Encoding": "UTF-8", "VignetteBuilder": "knitr", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "Config/testthat/edition": "3", "Config/pak/sysreqs": "make default-jdk libicu-dev libxml2-dev libx11-dev", "Repository": "https://ohdsi.r-universe.dev", "Date/Publication": "2025-10-02 16:49:30 UTC", "RemoteUrl": "https://github.com/ohdsi/resultmodelmanager", "RemoteRef": "HEAD", "RemoteSha": "90b4626860d604e762a95ff13617611932d922b9", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-24 07:25:26 UTC", "User": "root" }, "Author": "Jamie Gilbert [aut, cre]", "Maintainer": "Jamie Gilbert ", "MD5sum": "73740cc87a6fd5f72ed6b69ad0b08d6f", "_user": "ohdsi", "_type": "src", "_file": "ResultModelManager_0.6.2.tar.gz", "_fileid": "9885cf058ee6aa59c8a71a0a1b658ab9075da8875703ff9fc4d132c96e42c3d1", "_filesize": 247292, "_sha256": "9885cf058ee6aa59c8a71a0a1b658ab9075da8875703ff9fc4d132c96e42c3d1", "_created": "2026-05-24T07:25:26.000Z", "_published": "2026-05-24T07:32:51.608Z", "_distro": "noble", "_jobs": [ { "job": 77580320493, "time": 226, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7183268827" }, { "job": 77580320495, "time": 235, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7183269672" }, { "job": 77580320531, "time": 99, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7183287320" }, { "job": 77580320541, "time": 95, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7183288140" }, { "job": 77580118015, "time": 230, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7183245495" }, { "job": 77580320492, "time": 141, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7183260363" }, { "job": 77580320532, "time": 116, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7183257662" }, { "job": 77580320547, "time": 118, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7183257964" }, { "job": 77580320534, "time": 263, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7183272732" } ], "_buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/ohdsi/resultmodelmanager", "_commit": { "id": "90b4626860d604e762a95ff13617611932d922b9", "author": "Jamie Gilbert ", "committer": "GitHub ", "message": "Merge pull request #87 from OHDSI/hotfix-0.6.2\n\nHotfix 0.6.2", "time": 1759423770 }, "_maintainer": { "name": "Jamie Gilbert", "email": "gilbert@ohdsi.org", "login": "azimov", "description": "Epidemiology Analytics and Open Source Software Development with a background in Computational Systems Biology", "uuid": 180659 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "R6", "role": "Depends" }, { "package": "DatabaseConnector", "version": ">= 7.0.0", "role": "Depends" }, { "package": "SqlRender", "role": "Imports" }, { "package": "ParallelLogger", "role": "Imports" }, { "package": "checkmate", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "pool", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "zip", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "fastmap", "role": "Imports" }, { "package": "withr", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "duckdb", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "keyring", "role": "Suggests" }, { "package": "devtools", "role": "Suggests" }, { "package": "pkgdown", "role": "Suggests" }, { "package": "remotes", "role": "Suggests" }, { "package": "styler", "role": "Suggests" }, { "package": "rJava", "role": "Suggests" }, { "package": "reticulate", "role": "Suggests" } ], "_owner": "ohdsi", "_selfowned": true, "_usedby": 4, "_updates": [ { "week": "2025-38", "n": 1 }, { "week": "2025-39", "n": 1 }, { "week": "2025-40", "n": 1 } ], "_tags": [ { "name": "v0.6.0", "date": "2025-09-18" }, { "name": "v0.6.1", "date": "2025-09-24" }, { "name": "v0.6.2", "date": "2025-10-02" } ], "_stars": 4, "_contributors": [ { "user": "azimov", "count": 237, "uuid": 180659 }, { "user": "anthonysena", "count": 1, "uuid": 12902366 }, { "user": "chrisknoll", "count": 1, "uuid": 6818777 } ], "_userbio": { "uuid": 6570077, "type": "organization", "name": "Observational Health Data Sciences and Informatics" }, "_downloads": { "count": 641, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ResultModelManager" }, "_devurl": "https://github.com/ohdsi/resultmodelmanager", "_pkgdown": "https://ohdsi.github.io/ResultModelManager/", "_searchresults": 16, "_topics": [ "openjdk" ], "_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/ResultModelManager.html", "manual.pdf" ], "_homeurl": "https://github.com/ohdsi/resultmodelmanager", "_realowner": "ohdsi", "_cranurl": true, "_releases": [ { "version": "0.5.9", "date": "2024-07-21" }, { "version": "0.5.10", "date": "2024-08-21" }, { "version": "0.5.11", "date": "2024-09-19" }, { "version": "0.6.0", "date": "2025-09-18" }, { "version": "0.6.1", "date": "2025-09-25" }, { "version": "0.6.2", "date": "2025-10-03" } ], "_exports": [ "ConnectionHandler", "createQueryNamespace", "createResultExportManager", "DataMigrationManager", "deleteAllRowsForDatabaseId", "deleteAllRowsForPrimaryKey", "disablePythonUploads", "enablePythonUploads", "generateSqlSchema", "grantTablePermissions", "install_psycopg2", "loadResultsDataModelSpecifications", "PooledConnectionHandler", "pyPgUploadEnabled", "pyUploadCsv", "pyUploadDataFrame", "QueryNamespace", "ResultExportManager", "unzipResults", "uploadResults" ], "_help": [ { "page": "ConnectionHandler", "title": "ConnectionHandler", "topics": [ "ConnectionHandler" ] }, { "page": "createQueryNamespace", "title": "Create query namespace", "topics": [ "createQueryNamespace" ] }, { "page": "createResultExportManager", "title": "Create Result Export Manager", "topics": [ "createResultExportManager" ] }, { "page": "DataMigrationManager", "title": "DataMigrationManager (DMM)", "topics": [ "DataMigrationManager" ] }, { "page": "deleteAllRowsForDatabaseId", "title": "Delete all rows for database id", "topics": [ "deleteAllRowsForDatabaseId" ] }, { "page": "deleteAllRowsForPrimaryKey", "title": "Delete results rows for primary key values from database server tables", "topics": [ "deleteAllRowsForPrimaryKey" ] }, { "page": "disablePythonUploads", "title": "Disable python uploads", "topics": [ "disablePythonUploads" ] }, { "page": "enablePythonUploads", "title": "Enable Python Postgres Uploads", "topics": [ "enablePythonUploads" ] }, { "page": "generateSqlSchema", "title": "Schema generator", "topics": [ "generateSqlSchema" ] }, { "page": "grantTablePermissions", "title": "Grant Table Permissions", "topics": [ "grantTablePermissions" ] }, { "page": "install_psycopg2", "title": "install psycopg2", "topics": [ "install_psycopg2" ] }, { "page": "loadResultsDataModelSpecifications", "title": "Get specifications from a given file path", "topics": [ "loadResultsDataModelSpecifications" ] }, { "page": "PooledConnectionHandler", "title": "Pooled Connection Handler", "topics": [ "PooledConnectionHandler" ] }, { "page": "pyPgUploadEnabled", "title": "are python postgresql uploads enabled?", "topics": [ "pyPgUploadEnabled" ] }, { "page": "pyUploadCsv", "title": "Py Upload CSV", "topics": [ "pyUploadCsv" ] }, { "page": "pyUploadDataFrame", "title": "Py Upload data.frame", "topics": [ "pyUploadDataFrame" ] }, { "page": "QueryNamespace", "title": "QueryNamespace", "topics": [ "QueryNamespace" ] }, { "page": "ResultExportManager", "title": "Result Set Export Manager", "topics": [ "ResultExportManager" ] }, { "page": "unzipResults", "title": "Unzips a results.zip file and enforces standards required by 'uploadResults'", "topics": [ "unzipResults" ] }, { "page": "uploadResults", "title": "Upload results to the database server.", "topics": [ "uploadResults" ] } ], "_readme": "https://github.com/ohdsi/resultmodelmanager/raw/HEAD/README.md", "_rundeps": [ "backports", "bit", "bit64", "blob", "checkmate", "cli", "clipr", "cpp11", "crayon", "DatabaseConnector", "DBI", "dbplyr", "digest", "dplyr", "fastmap", "generics", "glue", "hms", "jsonlite", "later", "lifecycle", "lubridate", "magrittr", "memuse", "ParallelLogger", "pillar", "pkgconfig", "pool", "prettyunits", "progress", "purrr", "R6", "Rcpp", "readr", "rJava", "rlang", "rstudioapi", "snow", "SqlRender", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "timechange", "triebeard", "tzdb", "urltools", "utf8", "vctrs", "vroom", "withr", "xml2", "zip" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-21-jre-headless", "headers": "openjdk-21-jre-headless", "source": "openjdk", "version": "21.0.10+7-1~24.04", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_vignettes": [ { "source": "CreatingMigrations.Rmd", "filename": "CreatingMigrations.html", "title": "Creating Migrations", "author": "James P. Gilbert", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Assumptions", "Creating the required file structure", "In an R package", "Using folder structure", "Adding a migration", "Adding migrator", "Unit testing", "Common issues", "Supporting all database platforms", "SQLite column types", "Non-existent data" ], "created": "2022-08-30 19:56:47", "modified": "2023-09-12 22:42:10", "commits": 4 }, { "source": "PackageDesign.Rmd", "filename": "PackageDesign.html", "title": "Package Design", "author": "James P. Gilbert", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Problem statement", "Package name", "Package purpose", "Scope and Intended Use", "System Features and Requirements", "General", "Package dependencies", "Data Migration Manager (DMM) Class", "Class definition", "Example implementation for package", "Proposed structure of a migration SQL script", "Naming convention", "Required parameters", "Example SQL", "Adding script to list of executed migrations", "Results Data model class", "Utilities", "Add migration function", "Create DDL design", "Create new DDL", "Limitations and scope" ], "created": "2022-08-30 19:56:47", "modified": "2023-09-12 22:42:10", "commits": 4 }, { "source": "UsingPythonUploads.Rmd", "filename": "UsingPythonUploads.html", "title": "Using python for postrgresql uploads", "author": "James P. Gilbert", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Installing psycopg2", "Using a virtualenv", "Using conda or system python installs", "Usage within functions" ], "created": "2025-09-18 16:42:03", "modified": "2025-09-18 16:42:03", "commits": 1 }, { "source": "UploadFunctionality.Rmd", "filename": "UploadFunctionality.html", "title": "Upload Functionality", "author": "James P. Gilbert", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Creating a schema definition file", "Creating a schema", "Uploading results" ], "created": "2023-02-15 02:28:04", "modified": "2023-09-12 22:42:10", "commits": 2 }, { "source": "UsingAnExportManager.Rmd", "filename": "UsingAnExportManager.html", "title": "Using An Export Manager", "author": "James P. Gilbert", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Creating the export manager for a package", "Saving large results sets with a batch operation", "Setup", "Exporting a database query result", "Performing R operations", "Exporting an Andromeda result in batch", "Creating a results manifest file" ], "created": "2023-09-12 22:35:33", "modified": "2023-09-12 22:42:10", "commits": 2 }, { "source": "UsingConnectionHandlers.Rmd", "filename": "UsingConnectionHandlers.html", "title": "Using Connection Handlers", "author": "James P. Gilbert", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Basic usage", "Creating an instance", "Pooled connections", "Querying a database" ], "created": "2022-09-09 20:01:11", "modified": "2022-09-09 20:01:11", "commits": 1 }, { "source": "UsingQueryNamespaces.Rmd", "filename": "UsingQueryNamespaces.html", "title": "Using Query Namespaces", "author": "James P. Gilbert", "engine": "knitr::rmarkdown", "headings": [ "Purpose", "Basic usage", "Adding replacement variables at runtime" ], "created": "2023-04-05 23:21:54", "modified": "2023-09-12 22:42:10", "commits": 2 } ], "_score": 7.207580514765432, "_indexed": true, "_nocasepkg": "resultmodelmanager", "_universes": [ "ohdsi", "azimov" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.6.2", "date": "2026-05-24T07:28:56.000Z", "distro": "noble", "commit": "90b4626860d604e762a95ff13617611932d922b9", "fileid": "7fcfb6172141a2e7a143d5b657d51bafc491ed6100e19c11d008c308ceb29669", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214" }, { "r": "4.6.0", "os": "linux", "version": "0.6.2", "date": "2026-05-24T07:29:08.000Z", "distro": "noble", "commit": "90b4626860d604e762a95ff13617611932d922b9", "fileid": "0a5b3fa5b22bc7789470d6c3b49c4c048ef0c7e21ffb5d278d11ebd0d28ecd6d", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214" }, { "r": "4.5.3", "os": "mac", "version": "0.6.2", "date": "2026-05-24T07:32:07.000Z", "commit": "90b4626860d604e762a95ff13617611932d922b9", "fileid": "d22649bec5b287c3b913d481194656c9f54032e020cb7a4a36dfa1d7e5f29249", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214" }, { "r": "4.6.0", "os": "mac", "version": "0.6.2", "date": "2026-05-24T07:32:14.000Z", "commit": "90b4626860d604e762a95ff13617611932d922b9", "fileid": "27271e0cc15e0ab134e3ce8fc0a6a89eb5d935af6c928fa858c7cffc1db74d0b", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214" }, { "r": "4.6.0", "os": "wasm", "version": "0.6.2", "date": "2026-05-24T07:28:10.000Z", "commit": "90b4626860d604e762a95ff13617611932d922b9", "fileid": "f0f0c2d814aeb84d78bf4896ff3d1621cc2c9be4e55a4389deab0bd345431116", "status": "success", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214" }, { "r": "4.7.0", "os": "win", "version": "0.6.2", "date": "2026-05-24T07:27:03.000Z", "commit": "90b4626860d604e762a95ff13617611932d922b9", "fileid": "1be349ce5f91c39abb24dcaa99afa6c9235fb1149fa526cfeb86c9f369170c37", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214" }, { "r": "4.5.3", "os": "win", "version": "0.6.2", "date": "2026-05-24T07:26:46.000Z", "commit": "90b4626860d604e762a95ff13617611932d922b9", "fileid": "700de418c40a1c00ea94e2b13efd9d0f2822ee8e07255e0a21aa7a10fcaf3e17", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214" }, { "r": "4.6.0", "os": "win", "version": "0.6.2", "date": "2026-05-24T07:29:16.000Z", "commit": "90b4626860d604e762a95ff13617611932d922b9", "fileid": "4f4b782452417fced7ff3423446243a6e6e30e7f5a1824aee23bd2189d113642", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/ohdsi/actions/runs/26355028214" } ] }