search

DPIclimate / broker

3 stars 3 forks source link

Add logical device id, time received to the phyiscal_timeseries table #53

Closed dajtxx closed 8 months ago

dajtxx commented 10 months ago

For analysing message frequency at a site it would be useful to be able to query the phyiscal_timeseries table by logical device id. This makes it easier to check on a logical device without going through the mapping table.

Add a logical id column to the phyiscal_timeseries table, this column may be NULL when a message comes from an unmapped physical device.

Also add a received_at column, defaulting to the current time.

Explore whether it is possible to add a calculated interval column that holds the difference between the message timestamp and the received time.

dajtxx commented 8 months ago

Fixed by commit e4b75444bc290ec979956083488a250c2f57ee2e.