Add details about a new sample

Add details about a new sample

db_describe_sample(db, sample_code, site_code)

Arguments

db	database connection
sample_code	sampling feature code for sample
site_code	sampling feature code for where sample was collected from

Value

message that sample was added to sampling feature table

Details

Adds entry to samplingfeatures table as type 'Specimen' and entry into related features table that "sample_code" wasCollectedAt "site_code". Does not add an action for specimen collection - for that use db_insert_results_samples.

Examples

db <- create_sqlite(connect = TRUE)
db_describe_site(db, site_code = "site1")
#> Site site1 has been entered into the samplingfeatures table.

db_describe_sample(db,
sample_code = "sample001",
site_code = "site1")
#> Sample sample001 has been entered into the samplingfeatures table.