Package: ResultModelManager 0.6.2

Jamie Gilbert

ResultModelManager: Result Model Manager

Database data model management utilities for R packages in the Observational Health Data Sciences and Informatics programme. 'ResultModelManager' provides utility functions to allow package maintainers to migrate existing SQL database models, export and import results in consistent patterns.

Authors:Jamie Gilbert [aut, cre]

ResultModelManager_0.6.2.tar.gz
ResultModelManager_0.6.2.zip(r-4.7)ResultModelManager_0.6.2.zip(r-4.6)ResultModelManager_0.6.2.zip(r-4.5)
ResultModelManager_0.6.2.tgz(r-4.6-any)ResultModelManager_0.6.2.tgz(r-4.5-any)
ResultModelManager_0.6.2.tar.gz(r-4.7-any)ResultModelManager_0.6.2.tar.gz(r-4.6-any)
ResultModelManager_0.6.2.tgz(r-4.6-emscripten)
manual.pdf |manual.html
DESCRIPTION |NEWS
card.svg |card.png
ResultModelManager/json (API)

# Install 'ResultModelManager' in R:
install.packages('ResultModelManager', repos = c('https://ohdsi.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/ohdsi/resultmodelmanager/issues

Pkgdown/docs site:https://ohdsi.github.io

Uses libs:
  • openjdk– OpenJDK Java runtime, using Hotspot JIT

On CRAN:

Conda:

openjdk

7.36 score 4 stars 5 packages 18 scripts 754 downloads 20 exports 54 dependencies

Last updated from:90b4626860. Checks:7 NOTE, 2 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64NOTE314
source / vignettesOK290
linux-release-x86_64NOTE198
macos-release-arm64NOTE117
macos-oldrel-arm64NOTE147
windows-develNOTE118
windows-releaseNOTE2878
windows-oldrelNOTE122
wasm-releaseOK156

Exports:ConnectionHandlercreateQueryNamespacecreateResultExportManagerDataMigrationManagerdeleteAllRowsForDatabaseIddeleteAllRowsForPrimaryKeydisablePythonUploadsenablePythonUploadsgenerateSqlSchemagrantTablePermissionsinstall_psycopg2loadResultsDataModelSpecificationsPooledConnectionHandlerpyPgUploadEnabledpyUploadCsvpyUploadDataFrameQueryNamespaceResultExportManagerunzipResultsuploadResults

Dependencies:backportsbitbit64blobcheckmateclicliprcpp11crayonDatabaseConnectorDBIdbplyrdigestdplyrfastmapgenericsgluehmsjsonlitelaterlifecyclelubridatemagrittrmemuseParallelLoggerpillarpkgconfigpoolprettyunitsprogresspurrrR6RcppreadrrJavarlangrstudioapisnowSqlRenderstringistringrtibbletidyrtidyselecttimechangetriebeardtzdburltoolsutf8vctrsvroomwithrxml2zip

Using python for postrgresql uploads
Introduction | Installing psycopg2 | Using a virtualenv | Using conda or system python installs | Usage within functions

Last update: 2025-09-18
Started: 2025-09-18

Creating Migrations
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

Last update: 2023-09-12
Started: 2022-08-30

Package Design
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

Last update: 2023-09-12
Started: 2022-08-30

Upload Functionality
Introduction | Creating a schema definition file | Creating a schema | Uploading results

Last update: 2023-09-12
Started: 2023-02-15

Using An Export Manager
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

Last update: 2023-09-12
Started: 2023-09-12

Using Query Namespaces
Purpose | Basic usage | Adding replacement variables at runtime

Last update: 2023-09-12
Started: 2023-04-05

Using Connection Handlers
Introduction | Basic usage | Creating an instance | Pooled connections | Querying a database

Last update: 2022-09-09
Started: 2022-09-09