[User Story] As a service developer I want call rest NGSILD API for temporal/history data stored in timeseries database using Scorpio broker

[yshashix]

Details

Use NGSILD API with temporal query format to access timeseries data

Acceptance Criteria

1. Start with a normal temporal query in NGSI-LD API format, should receive a response based on time duration
2. Apply complex temporal query like aggregation function on temporal entity data using NGSILD API

• Response should have value according to Aggregation method

Tasks

[] Analyse SQL complex query implemented by Scorpio Broker and evaluate if it make sense with timeseries db function
[] Adapt Scorpio Broker history manager to timescaledb
[] Create connection of Scorpio broker with timescaledb

Resources:

• For reference implement aggregation query on temporal data form timeseries data base scorpio aggregation support

Notes

• Socpio 4.1.15 store entity data in temporalentityattrinstance table on jsonb format and process it.
• look in file for reference implementation of temporal aggregation query Scorpio history manager implementation link

[yshashix]

Multiple temporal API are like below from standard which is handled in temporal query manager of scorpio but need to be adjusted for timescaledb query as timeseries hyperfunction aggregate, max,min query read data directly.

1. temporal/entities/
2. temporal/entities/{entityId}
3. temporal/entities/{entityId}/attrs/
4. temporal/entities/{entityId}/attrs/{attrId}
5. /temporal/entities/{entityId}/attrs/{attrId}/{instanceId}