Skip to contents

Set Status Code

set_sample_status.Rd

Set the status code for existing samples

Usage

set_sample_status(con, sample_ids, sample_status_code, comment = NULL)

Arguments

con

connection to the database

sample_ids

vector of sample ids to update

status

status code to use for the update

  • created status assigned automatically when a new sample ID is generated

  • prepped sample tube has been created

  • out to field sample tube is out in the field to be collected

  • return from field sample tube has returned from the field

  • in analysis sample is being analyzed

  • stored sample is in storage

  • archived sample has been sent to a tissue archive

  • other lab sample is out at another lab

See also

Other status code functions: add_status_code(), delete_status_code(), get_sample_status(), get_status_codes(), update_status_code(), update_status_code_status()

Examples

# example database connection
cfg <- config::get()
con <- DBI::dbConnect(RPostgres::Postgres(),
                      dbname = cfg$dbname,
                      host = cfg$host,
                      port = cfg$port,
                      user = cfg$username,
                      password = cfg$password)
#> Error: connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D/10061)
#> 	Is the server running on that host and accepting TCP/IP connections?
#> connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused (0x0000274D/10061)
#> 	Is the server running on that host and accepting TCP/IP connections?

sample_locations <- set_sample_locations(con,
                                         sample_ids = c("FTH_RM1722_3_A_1",
                                                         "FTH_RM1722_3_A_2"),
                                         status = "prepped",
                                         comment = "ready for pickup")
#> Error in set_sample_locations(con, sample_ids = c("FTH_RM1722_3_A_1",     "FTH_RM1722_3_A_2"), status = "prepped", comment = "ready for pickup"): could not find function "set_sample_locations"