timeseriesdb (version 0.4.1)

updateMetaInformation: Update Meta Information Records

Description

When a time series is stored to the database by storeTimeSeries a minimal unlocalized (i.e. untranslatable) meta information record is being generated. This meta information can be supplement using the updateMetaInformation methods. Depending on the class of the environment that holds the meta information localized or unlocalized meta information is updated. NOTE: AVOID looping over this function. This functions accepts entire environments and creates large SQL queries instead of looping over multiple small queries. In other words loops are moved to the databse level for massive speed gain.

Usage

updateMetaInformation(meta, con, schema = "timeseries",
  tbl = "meta_data_unlocalized", locale = NULL, keys = NULL, quiet = F,
  chunksize = 10000)
# S3 method for meta_env
updateMetaInformation(meta, con, schema = "timeseries",
  tbl = "meta_data_unlocalized", locale = NULL, keys = NULL, quiet = F,
  chunksize = 10000)

Arguments

meta

object of class meta_env. Most likely generated by addMetaInformation

con

a PostgreSQL connection object

schema

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

tbl

character name of the meta information table to write to. Defaults to 'meta_data_unlocalized'.

locale

character iso 2 digit locae description. Defaults to NULL.

keys

character vector of time series. If specified only the selected meta information is stored. Defaults to NULL which stores all meta information records in the environment.

quiet

logical should function be quiet instead of returning a message when done? Defaults to FALSE.

chunksize

integer max size of chunks to split large query in.