⚠️There's a newer version (3.4.1) of this package.Take me there.

Opal R

Opal R Client for the Opal data warehouse. Most of the web services of Opal can be reached by an opalr function: import/export, data dictionaries, projects, tables, resources, permissions, users, DataSHIELD profiles etc.

See opalr documentation.

Installation:

# install from CRAN
install.packages("opalr")

# or install latest development version
remotes::install_github("obiba/opalr")

Basic usage:

library(opalr)
o <- opal.login('administrator', 'password', url = 'https://opal-demo.obiba.org')

# assign a table (as a data.frame) to a R symbol
opal.assign(o, 'D', 'CNSIM.CNSIM1')

# perform R operations on the server side
opal.execute(o, 'summary(D$GENDER)')
opal.execute(o, 'summary(D$LAB_GLUC)')

opal.logout(o)

Cookbooks

DataSHIELD Client

See the DSOpal documentation.

Copy Link

Version

Install

install.packages('opalr')

Monthly Downloads

648

Version

3.3.1

License

GPL-3

Issues

Pull Requests

Stars

Forks

Maintainer

Last Published

February 28th, 2023

Functions in opalr (3.3.1)

dictionary.annotate

Set variable annotation with a taxonomy term
dictionary.apply

Apply the dictionary to a tibble
.as.zeroOne

Turns a value into 0/1 numeric.
.extractJsonField

Extract JSON
.extractOpalSessionId

Extract opalsid from cookie data frame.
.getRSessionId

Extract R session Id from opal object, create a new R session if not found.
.deparse

Turn expression into character strings.
.getSessions

Get all R session in Opal.
.getContent

Wrapper of httr::content()
.handleError

Handle error response
.handleResponseLocation

Default request response Location handler.
.handleResponse

Default request response handler.
.opal.login

Create the opal object
.extractLabel

Extract label for locale. If not found, fallback to undefined language label (if any).
.getPEMFilePath

Extract absolute path to the pem file
.handleResponseOrCallback

Process response with default handler or the provided one
.is.verbose

Verbose option
.newSession

Create a new R session in Opal.
.tickProgress

Output the progress status if option "datashield.progress" is allows to.
.select

Returns a list r such that r[[i]] == l[[i]][field] for all i:length(l)
.isContentEmpty

Check if response content is empty.
.rmOpalSession

Remove a Opal session (logout)
.rmRSession

Remove a R session from Opal.
dsadmin.install_local_package

Install a DataSHIELD package from a local archive file
.listToJson

Simple transformation function of a list into a JSON object/array.
dsadmin.install_github_package

Install a DataSHIELD package from GitHub
.newProgress

Create a new progress instance with default settings.
dsadmin.profile

Get a DataSHIELD profile
dsadmin.perm_delete

Delete a DataSHIELD permission
dsadmin.get_method

Get a DataSHIELD method
.verbose

Verbose flag
dsadmin.profile_create

Create a DataSHIELD profile
dsadmin.profile_access

Restrict or open access to a DataSHIELD profile
dsadmin.perm_add

Add or update a DataSHIELD permission
dsadmin.perm

Get the DataSHIELD permissions
.tokenHeader

Constructs the value for the X-Opal-Auth header
.url

Utility method to build urls. Concatenates all arguments and adds a '/' separator between each element
dsadmin.get_options

Get the DataSHIELD options
dsadmin.get_methods

Get DataSHIELD methods
dsadmin.profile_delete

Delete a DataSHIELD profile
dsadmin.remove_package

Remove DataSHIELD package
dsadmin.rm_method

Remove DataSHIELD method
dsadmin.profiles

Get DataSHIELD profiles
dsadmin.profile_init

Initialize a DataSHIELD profile
dsadmin.profile_exists

Check a DataSHIELD profile exists
dsadmin.rm_methods

Remove DataSHIELD methods.
dsadmin.profile_perm_delete

Delete a permission from a DataSHIELD profile
dsadmin.profile_rparser

Set or remove the R parser version of a DataSHIELD profile
dsadmin.rm_option

Remove a DataSHIELD option
dsadmin.install_package

Install a DataSHIELD package
dsadmin.set_method

Set DataSHIELD method
dsadmin.package_descriptions

Get DataSHIELD package descriptions
dsadmin.package_description

Get DataSHIELD package description
dsadmin.installed_package

Check DataSHIELD package
dsadmin.profile_perm

Get the permissions of a DataSHIELD profile
oadmin.install_cran_package

Install a package from CRAN
oadmin.install_bioconductor_package

Install a package from Bioconductor
dsadmin.publish_package

Publish DataSHIELD package settings
oadmin.install_package

Install CRAN package
oadmin.install_local_package

Install a package from a local archive file
oadmin.install_github_package

Install a package from GitHub
oadmin.install_devtools

Install devtools package
dsadmin.unpublish_package

Unpublish DataSHIELD package settings
oadmin.installed_devtools

Check devtools package
dsadmin.profile_enable

Enable or disable a DataSHIELD profile
dsadmin.set_package_methods

Set DataSHIELD package methods
oadmin.installed_package

Check package is installed
dsadmin.rm_package_methods

Remove DataSHIELD package methods
dsadmin.rm_options

Remove all DataSHIELD options
oadmin.installed_packages

List installed packages
oadmin.perm_delete

Delete a R permission (deprecated)
oadmin.system_perm

Get the System permissions
oadmin.remove_package

Remove package
oadmin.system_metrics

Get system metrics
oadmin.package_description

Get package description
oadmin.users

Get the users
oadmin.r_perm_delete

Delete a R permission
opal.assign.table.tibble

Data assignment to a tibble
oadmin.user_delete

Delete a user
opal.assign

Data or expression assignment
opal.assign.data

Data assignment
opal.annotate

Apply the annotations to a Opal table
oadmin.r_perm_add

Add or update a R permission
oadmin.user_enable

Enable a user
oadmin.system_perm_add

Add or update a System permission
opal.assign.table

Data assignment to a data.frame
oadmin.system_perm_delete

Delete a System permission
oadmin.user_profile_delete

Delete a user profile
opal.attribute_values

Get a vector of attribute values
opal.command

Get an asynchronous command
opal.execute

Execute a R script
oadmin.user_exists

Check user exists
oadmin.user_add

Add a user
opal.delete

Generic REST resource deletion.
opal.command_result

Get result of an asynchronous command
opal.command_rm

Remove an asynchronous command
opal.execute.source

Execute a R file script
opal.file

Get file content
oadmin.r_perm

Get the R permissions
opal.file_ls

List content of a folder
opal.as_md_table

Array to Markdown
opal.datasource

Get a datasource
opal.annotations

Get the annotations of a Opal table
opal.file_rm

Remove a file
opal.file_read

Read a file
opal.profiles

List R profiles
opal.project

Get a project
opal.datasources

Get datasources
opal.login

Opal login
opal.file_mkdir

Make a folder
opal.load_package

Load package
opal.file_cp

Copy a file
opal.file_download

Download a file
opal.file_unzip

Unzip a zip archive file
opal.file_upload

Upload a file or a folder
opal.commands

List the asynchronous commands
opal.project_backup

Backup a project
opal.project_command

Get project task
opal.post

Generic REST resource creation.
opal.put

Generic REST resource update.
opal.resource_perm

Get the permissions on a resource
opal.projects_databases

Get projects databases
opal.resource_perm_add

Add or update a permission on a resource
opal.projects

Get projects
opal.project_perm

Get the permissions on a project
opal.resource_perm_delete

Delete a permission from a resource
opal.project_exists

Check a project exists
opal.logout

Logout from Opal(s)
opal.resource_view_create

Create an Opal view over a resource reference
opal.commands_rm

Remove all asynchronous commands
opal.resource_view_reconnect

Reconnect an Opal view to its underlying resource
opal.resource

Get a resource reference of a project
opal.resources

Get the resource references of a project
opal.report_md

Turn a R markdown file to html.
opal.report

Opal report
opal.resource_create

Create a resource reference in a project
dsadmin.profile_perm_add

Add or update a permission on a DataSHIELD profile
opal.resources_perm_add

Add or update a permission on any resource
opal.resources_perm

Get the permissions on any resource
opal.project_perm_add

Add or update a permission on a project
dsadmin.set_option

Set DataSHIELD option
opal.symbol_import

Import a tibble
oadmin.perm

Get the R permissions (deprecated)
opal.sql

Execute a SQL query on tables
opal.sql_history

SQL query execution history
opal.table_delete

Delete a Opal table
opal.rm

Remove a R symbol (deprecated)
opal.table_dictionary_get

Get the dictionary of a Opal table
opal.table_perm_add

Add or update a permission on a table
opal.table_save

Save a local tibble as a Opal table
opal.table_perm_delete

Delete a permission from a table
opal.table_truncate

Truncate a Opal table
opal.taxonomy

Get a taxonomy
opal.taxonomies

Get taxonomies
opal.table_perm

Get the permissions on a table
oadmin.user_reset_password

Reset user password
opal.tasks

Get the tasks
opal.assign.script

R script assignment
opal.task_wait

Wait for a task to complete.
opal.table_export

Export a table as a file
opal.table_get

Get a Opal table as a tibble
oadmin.perm_add

Add or update a R permission (deprecated)
opal.file_mkdir_tmp

Make a temporary folder
oadmin.user_profiles

Get user profiles
opal.table_import

Import a file as table
opal.file_write

Write a file
opal.tables_perm_add

Add or update a permission on any table of a project
opal.tables_perm_delete

Delete a permission from any table of a project
opal.tokens

Get the personal access tokens
opal.vocabulary

Get a taxonomy vocabulary
opal.unload_package

Unload package
opal.variable_summary

Get summary statistics of a variable of a table
opal.token_delete

Delete a personal access token
opal.token_renew

Renew an inactive personal access token
opal.variables

Get variables of a table
opal.assign.resource

Resource assignment
opal.symbol_save

Save a tibble
opal.workspace_restore

Restore a R workspace from a opal.
opal.token_r_create

Create a personal access token for R usage
opal.symbols

List R symbols
opal.token_datashield_create

Create a personal access token for Datashield usage
opalr-package

opalr: 'Opal' Data Repository Client and 'DataSHIELD' Utils
opal.task

Get a task
opal.task_cancel

Cancel a task
opal.workspaces

Get the R workspaces from a opal.
opal.token

Get a personal access token
opal.tables

Get tables of a datasource
opal.version_compare

Compare
opal.get

Generic REST resource getter.
opal.vocabularies

Get the vocabularies of a taxonomy
opal.table

Get a table of a datasource
opal.project_perm_delete

Delete a permission from a project
opal.file_mv

Move and/or rename a file
opal.resource_delete

Delete a resource reference
opal.taxonomy_delete

Delete a taxonomy
opal.symbol_rm

Remove a R symbol
opal.taxonomy_download

Download a taxonomy file
opal.tables_perm

Get the permissions on any table of a project
opal.table_create

Create an Opal table or view
opal.resource_exists

Check a resource reference exists
opal.workspace_rm

Remove a R workspace from a opal.
opal.table_dictionary_update

Update the dictionary of a Opal table
opal.project_create

Create a project
opal.resource_get

Get the resource object of a project
opal.project_restore

Restore a project
opal.table_exists

Check a Opal table exists
opal.project_delete

Delete a project
opal.workspace_save

Save the current session in a opal R workspace.
opal.resource_extension_create

Create an extended resource reference in a project
opal.token_sql_create

Create a personal access token for SQL usage
opal.valueset

Get the values of an entity
opal.table_view_create

Create an Opal view over tables
opal.resources_perm_delete

Delete a permission from any resource
opal.taxonomy_upload

Upload a taxonomy file
opal.table_view_update

Update the table references and the entity filter of an Opal view
opal.terms

Get the terms of a vocabulary
opal.variable

Get a variable of a table
.authorizationHeader

Constructs the value for the Authorization header
dictionary.annotations

List the annotations
dictionary.inspect

Inspect the dictionary of a tibble
dictionary.annotate.harmo_status

Set variable annotation with Harmonization Status term
.aclsToDataFrame

Permsissions (ACLs) into a data frame.