db_describe_equipment: Add a piece of equipment to the equipment table
In khondula/rodm2: Use an ODM2 Database in R

Description Usage Arguments Value See Also Examples

Add a piece of equipment to the equipment table

db_describe_equipment(db, equip_name, serial_no, model_name, vendor,
  owner_first, equipment_type = "Sensor", owner_last = NULL,
  owner_email = NULL, manufacturer = NULL,
  purchase_date = Sys.Date())

`db`	database connection
`equip_name`	a unique short code name of the instrument
`serial_no`	serial number of equipment
`model_name`	model name of equipment
`vendor`	organization that sold the product
`owner_first`	first name of person who owns equipment
`equipment_type`	type of equipment from controlled vocabulary defaults to sensor
`owner_last`	last name of person who owns equipment, required if the person is not in the people table already
`owner_email`	email of person who owns equipment, required if the person is not in the people table arelady
`manufacturer`	company that makes the model of the equipment, required if the model is not in the equipmentmodels table
`purchase_date`	date that the equipment was purchased, defaults to current date

TRUE if successful

Other describe functions: db_describe_annotation, db_describe_method, db_describe_organization, db_describe_person, db_describe_site, db_describe_variable

# db <- create_sqlite()
# OR
# db <- connect_sqlite()
# db_describe_equipment(db, "unit1", "001", "model1",
# "vendor name", "Wendy", "Sensor", "Wetland", "ww email", "hobo")

khondula/rodm2 documentation built on Jan. 9, 2020, 1:48 p.m.