db_collection_remove_ts {timeseriesdb}

Remove Keys From a User's Collection

Description

Removes a vector of time series keys from a user specific compilation.

Usage

db_collection_remove_ts(
  con,
  collection_name,
  ts_keys,
  user = Sys.info()["user"],
  schema = "timeseries"
)

Arguments

con

RPostgres connection object.

collection_name

character name of a collection to read. Collection are bookmark lists that contain time series keys.

ts_keys

character vector of time series identifiers.

user

character name of the database user. Defaults to the user of the R session. this is often the user for the database, too so you do not have to specify your username explicitly if that is the case.

schema

character name of the database schema. Defaults to 'timeseries'

See Also

Other collections functions: db_collection_add_ts(), db_collection_delete(), db_collection_get_keys(), db_collection_get_last_update(), db_collection_list()

Examples

## Not run: 
db_ts_store(con = connection, zrh_airport, schema = "schema")
db_ts_store(con = connection, kof_ts, schema = "schema")

db_collection_add_ts(
  con = connection,
  collection_name = "barometer and departures zurich",
  ts_keys = c(
    "ch.zrh_airport.departure.total",
    "ch.zrh_airport.departure.total",
    "ch.kof.barometer"
  ),
  schema = "schema"
)

db_collection_remove_ts(
  con = connection,
  collection_name = "barometer and departures zurich",
  ts_keys = "ch.zrh_airport.departure.total",
  schema = "schema"
)

## End(Not run)