firecloud: Data table commands through firecloud

In vjcitn/BiocTNU: Interface to terra-notebook-utils

Data table commands through firecloud

Description

tables() lists the available tables in a workspace with the corresponding row count and column names.

table() returns a table.

table_delete_values() deletes row from the table.

table_upload() uploads a table to the AnVIL workspace.

tables_gadget() provides a simple graphical interface to allow selection of a table from the workspace.

Usage

tables(namespace = tnu_workspace_namespace(), name = tnu_workspace_name())

table(
  table,
  namespace = tnu_workspace_namespace(),
  name = tnu_workspace_name()
)

table_delete_values(
  table,
  values,
  dry.run = TRUE,
  namespace = tnu_workspace_namespace(),
  name = tnu_workspace_name()
)

table_upload(
  tbl,
  namespace = tnu_workspace_namespace(),
  name = tnu_workspace_name()
)

tables_gadget(
  namespace = tnu_workspace_namespace(),
  name = tnu_workspace_name()
)

Arguments

namespace	character(1) AnVIL workspace namespace; see ?tnu_workspace for details and default value.
name	character(1) AnVIL workspace name; see ?tnu_workspace for details and default value.
table	character(1) table name.
values	character(1) The '*_id' of the row that should be deleted from the table.
dry.run	logical(1) When TRUE (default) report the action to be performed, without actually doing the action.
tbl	A tibble to uploaded as a data table to the workspace.

Value

tables() returns a tibble.

table() a tibble of data from the table.

table_delete_values() returns the name of the table that had the row deleted from.

tables_gadget() returns a tibble representing the selected table.

Examples

if (tnu_workspace_ok()) {
    tables()
    table("test_table")
    mycars <- head(mtcars) |>
        dplyr::as_tibble(rownames = "model_id")
    table_upload(mycars)
    table_delete_values("model", "Mazda_RX4")
    tables_gadget()
}

vjcitn/BiocTNU documentation built on July 28, 2023, 8:09 p.m.