Skip to contents

View the current or full sample status history

Usage

get_sample_status(con, sample_ids, full_history = FALSE)

Arguments

con

connection to the database

sample_ids

vector of sample ids to update

full_history

when set to TRUE, will return the current and each previously assigned status for a sample ID

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 <- get_sample_locations(con,
                                         sample_ids = c("FTH_RM1722_3_A_1",
                                                         "FTH_RM1722_3_A_2"))
#> Error in get_sample_locations(con, sample_ids = c("FTH_RM1722_3_A_1",     "FTH_RM1722_3_A_2")): unused argument (sample_ids = c("FTH_RM1722_3_A_1", "FTH_RM1722_3_A_2"))