A Time Series Database for Official Statistics with R and PostgreSQL

---

Documentation for package ‘timeseriesdb’ version 1.0.0-1.1.2

• DESCRIPTION file.
• User guides, package vignettes and other documentation.
• Package NEWS.

Help Pages

as.meta	Convert a List into a Metadata Object
as.tsmeta	Convert a List into a Metadata Object
change_access_level	Change the Access Level of a Time Series
create_meta	Create Meta Data Objects
create_tsmeta	Meta in
date_to_index	Convert date-likes to time index
db_access_level_create	Create a New Role (Access Level)
db_access_level_delete	Delete a role in access levels table
db_access_level_list	Get All Access Levels and Their Description
db_access_level_set_default	Set the Default Access Level
db_call_function	Helper to construct SQL function calls
db_collection_add_ts	Bundles Keys into an Existing Collection or Adds a New Collection
db_collection_delete	Remove an Entire Time Series Key Collection
db_collection_get_keys	Get All Keys in a User Collection
db_collection_get_last_update	Get the last update of a collection for a specific User
db_collection_list	List All Available Collections for a Specific User
db_collection_read_metadata	Read Metadata for a Collection
db_collection_read_ts	Read all Time Series in a User Collection
db_collection_remove_ts	Remove Keys From a User's Collection
db_connection_close	Close an Existing Database Connection
db_connection_create	Create Database Connection
db_dataset_change_access	Change the Access Level of a Time Series
db_dataset_create	Create a New Dataset
db_dataset_delete	Irrevocably Delete All Time Series in a Set and the Set Itself
db_dataset_get_keys	Get All Time Series Keys in a Given Set
db_dataset_get_last_update	Get the dataset last update
db_dataset_get_latest_release	Get the latest Release for Given Datasets
db_dataset_get_next_release	Get Next Release Date for Given Datasets
db_dataset_get_release	Get the latest Release for Given Datasets
db_dataset_list	Get All Available Datasets and Their Description
db_dataset_read_metadata	Read Dataset Meta Information
db_dataset_read_ts	Read all Time Series in a Dataset
db_dataset_trim_history	Remove Vintages from the Beginning of Dataset
db_dataset_update_metadata	Update Description and/or Metadata of a Dataset
db_get_installed_version	Get the Currently Installed Version of Timeseriesdb
db_grant_to_admin	GRANT all rights on a (temp) table to schema admin
db_metadata_read	Read Time Series Metadata
db_metadata_store	Store Time Series Metadata to PostgreSQL
db_meta_get_latest_validity	Get Latest Validity for Metadata of a Given Time Series
db_release_cancel	Cancel a Scheduled Release
db_release_create	Create an Entry in the Release Calendar
db_release_list	List Data on Registered Releases
db_release_update	Update an Existing Release Record
db_ts_assign_dataset	Assign Time Series Identifiers to a Dataset
db_ts_change_access	Change the Access Level of a Time Series
db_ts_delete	Remove Time Series from the Database
db_ts_delete_latest_version	Delete the Latest Vintage of a Time Series
db_ts_find_keys	Get All keys that follow a pattern
db_ts_get_access_level	Find Out About the Access Level of a Vintage
db_ts_get_dataset	Find Datasets Given a Set
db_ts_get_last_update	Get the times series last update
db_ts_read	Read Time Series From PostgreSQL into R
db_ts_read_history	Read the Entire History of a Time Series
db_ts_rename	Rename Time Series by Assigning a New Key
db_ts_store	Store a Time Series to the Database
db_ts_trim_history	Remove Vintages from the Beginning
db_with_tmp_read	Helper to Create and Populate a Temporary Table for Fast Reading
has_depth_2	Test if a list has exactly depth 2
index_to_date	Helper Function for Date Operations
install_timeseriesdb	Install timeseriesdb
json_to_ts	Convert JSON Representation of a Time Series into R Time Series Objects
kof_ts	KOF indicators
param_defs	Common parameters
print.meta	Print Method for meta Object
setup_sql_extentions	Install PostgreSQL Schemas and Extensions
setup_sql_functions	Install timeseriesdb System Functions
setup_sql_grant_rights	Grant execute on timeseriesdb functions
setup_sql_roles	Create Roles needed for operation of timeseriesdb
setup_sql_tables	Install timeseriesdb System Tables
setup_sql_triggers	Install timeseriesdb Triggers