JCKalt / General-Work

Modeling database
0 stars 0 forks source link

Pull new purify hub data for Christi #161

Closed JCKalt closed 5 months ago

JCKalt commented 5 months ago

Christi wants sensor data coming in for HUB serial number 'F577097C71E3'

purify_2=> select * from serial_number where serial_number = 'F577097C71E3'; device_type | serial_number | serial | po_id | batch_id -------------+---------------+--------------------+-------+---------- pairing | F577097C71E3 | 0xF100244CABED1504 | 66 | 2 (1 row)

Dynamo pairing payload is:

{ "serial": "0xF100244CABED1504", "timestamp": 1706546752, "payload": { "concentratorId": "0xF100244CABED1504", "displayName": "Unassigned.1", "generators": [ { "CurrentData": null, "Data": null, "displayName": "Zoneless Sensors", "name": "Zoneless Sensors", "sensors": [ { "CurrentData": null, "Data": null, "displayName": "Sensor 1", "name": "Sensor 1", "uid": "0xF4CE362542F58AB8" } ], "uid": "Unassigned" } ], "mac": null, "model": null, "name": "Unassigned.1", "temperatureScale": null, "timeZone": null, "version": null, "zipCode": null } }