sda.dashboard.api.routes.timeseries
===================================

.. py:module:: sda.dashboard.api.routes.timeseries

.. autoapi-nested-parse::

   Route for reading timeseries data from the cloud PostgreSQL database.



Attributes
----------

.. autoapisummary::

   sda.dashboard.api.routes.timeseries.router


Functions
---------

.. autoapisummary::

   sda.dashboard.api.routes.timeseries.get_timeseries
   sda.dashboard.api.routes.timeseries.get_commentary


Module Contents
---------------

.. py:data:: router

.. py:function:: get_timeseries(body)
   :async:


   Load timeseries data from PostgreSQL for *tag* within the given time window.

   Credentials are read from ``~/sda.json`` (keys ``DB_USER``, ``DB_PASSWORD``,
   ``DB_HOST``, ``DB_PORT``, ``DB_NAME``).  Returns a flat list of row dicts plus
   the ordered column list.


.. py:function:: get_commentary(body)
   :async:


   Load commentary entries for *tag* from the ``commentary`` table.

   Credentials are read from ``~/sda.json``.  Entries are filtered by
   ``pid_code`` and optionally by the same time window used for timeseries.