dbAdd_calibration_state: Add calibrated devices to 'calibration_state' table

Description Usage Arguments Value See Also Examples

View source: R/db_write.R

Description

dbWriteTable_calibration_state requires a correct device id while dbAdd_calibration_state derives that from the device name.

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
dbAdd_calibration_state(
  conn,
  dev_name,
  calstate_datetime = NULL,
  calstate_parameter = NULL,
  calstate_comment = NULL
)

dbWriteTable_calibration_state(
  conn,
  dev_id,
  calstate_datetime = NULL,
  calstate_parameter = NULL,
  calstate_comment = NULL
)

Arguments

conn

Database connection.

dev_name

String vector of name of device.

calstate_datetime

POSIXct vector of date and time of calibration.

calstate_parameter

String vector of values of calibration parameters.

calstate_comment

String vector of additional comments.

dev_id

Integer vector of device ID.

Value

Data frame of newly added rows.

See Also

dbAdd_device_uncalibrated for adding a device that does not require calibration to both device and calibration_state

Other custom dbWriteTable functions: dbAddCorrection_station_adlershof(), dbAddCorrection_station_patagonia(), dbAdd_device_model(), dbAdd_device(), dbAdd_integration(), dbAdd_measurand(), dbAdd_physical_quantity(), dbAdd_station_adlershof(), dbAdd_station_patagonia(), dbWriteTable_device_manufacturer(), dbWriteTable_device_type(), dbWriteTable_integration_type(), dbWriteTable_person(), dbWriteTable_quality_flag(), dbWriteTable_site()

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
## Not run: 
con <- dbConnect_klimageo()
dbWriteTable_device_manufacturer(con, "TSI")
dbWriteTable_device_type(con, "thermometer")
dbWriteTable_device_model(con, "THERMO1000", 1, 1)
dbWriteTable_device(con, "My first THERMO1000", 1, "NCC1701-T")
dbWriteTable_calibration_state(con,
                               1,
                               as.POSIXct("2012-01-01 12:15:12", tz = "GMT"),
                               "a=10, b=99.12")
dbDisconnect(con)

## End(Not run)

sebschub/klimageodb documentation built on Sept. 25, 2021, 4:16 p.m.