Skip to content

This new version will enable us to store the device attributes in Postgres (OCDM)

Hugo Santos requested to merge devices-topology-state-to-ocdm into master

Dear All (@degon @youngman @carinanc @bondarv)

First, today, this https://in.xfel.eu/elog/OPERATION-2019/202 really pushed me to have something already before my holidays.

It is something simple but will help us a lot tracking (automatically) the devices that were running before any intervention on our control network/operation, like, PLC updates and/or Karabo updates.

Some remarks:

  1. OCDM Webservice is already ready (receiveDevice webmethod implemented)
  2. The new routine implemented on this device should be called **1 per day **or as we wish (Device Frequency parameter)
  3. Postgres device table designed and implemented based on the attributes available on the topology. For this, it is worthy to mention that I did not design it with natural joins and normalization on RDBM level (high written rates expected)

Screenshot_from_2019-04-03_19_34_31

Finally, again, I would like to have it running before my holidays (MR done on Thursday and deploy on Friday :P). Please, do not be a perfectionist.

Best, Hugo

Edited by Hugo Santos

Merge request reports