Get the dataset last update
db_dataset_get_last_update(con, set_id, schema = "timeseries")
RPostgres connection object.
character name of the set to get the last update
character name of the database schema. Defaults to 'timeseries'
Other datasets functions:
db_dataset_create()
,
db_dataset_delete()
,
db_dataset_get_keys()
,
db_dataset_list()
,
db_dataset_trim_history()
,
db_dataset_update_metadata()
,
db_ts_assign_dataset()
,
db_ts_get_dataset()
if (FALSE) {
# Storing different versions of the data, use parameter valid_from
# different versions are stored with the same key
ch.kof.barometer <- kof_ts["baro_2019m11"]
names(ch.kof.barometer) <- c("ch.kof.barometer")
db_ts_store(
con = connection,
ch.kof.barometer,
valid_from = "2019-12-01",
schema = "schema"
)
ch.kof.barometer <- kof_ts["baro_2019m12"]
names(ch.kof.barometer) <- c("ch.kof.barometer")
db_ts_store(
con = connection,
ch.kof.barometer,
valid_from = "2020-01-01",
schema = "schema"
)
db_dataset_create(
con = connection,
set_name = "barometer",
set_description = "KOF Barometer",
schema = "schema"
)
db_ts_assign_dataset(
con = connection,
ts_keys = "ch.kof.barometer",
set_name = "barometer",
schema = "schema"
)
db_dataset_get_last_update(
con = connection,
set_id = "barometer",
schema = "schema"
)
}