Add profile monitors resolution and pixel size to a yaml file

[jp-ga]

Currently, profile monitors' resolutions and pixel sizes are obtained by accessing the machine PVs. It would be useful to save them into a yaml file so that they can be accessed when the machine is off, or when creating virtual accelerator lattices without the need of logging into the control room servers.

Ideally, there should be a script to get all profile monitors info and save it in a yaml as follows:

<ELEMENT>:
  name: <control system name>
  shape: 
    - <n_rows>
    - <n_cols>
  pixel_size: <microns> 

Example:

OTRH1:
   name: OTRS:IN20:465
   shape:
   - 1040
   - 1392
   pixel_size: 18.59

OTRH2:
   name: OTRS:IN20:471
   shape:
   - 1040
   - 1392
   pixel_size: 19.16

OTR2:
   name: OTRS:IN20:571
   shape:
   - 1040
   - 1392
   pixel_size: 12.66

...

[eloise-nebula]

Hi JP, thank you for the issue.

The slac-tools team discussed this with @williamColocho and @phys-cgarnier today. This repo is designed to help developers connect metadata from MAD/Oracle to their associated addresses on EPICS, and we don't currently have plans to cache the value of PVs in this repo. Furthermore, we don't update this database on a regular cadence, which is to say it may often be out of date.

That being said, we'd be happy to help you use these tools to develop a solution that works for you. @phys-cgarnier agreed to help you all write a script that will support caching PVs on an interval that works for you. We can look up the resoution PVs for all the cameras we have on the db right now, and record their values into a format that works for you.

See here for PV lookup:

slac-db/slac_db/device.py

Lines 78 to 96 in 8f86896

	def get_all_accessors(device):
	"""Get all accessors from a device.
	An accessor is a developer friendly name for a PV
	associated with a single device.
	Args:
	device (str): MAD name for a device.
	"""
	with _session() as s:
	return {
	r["accessor_name"]: r["cs_address"]
	for r in s.select(
	sqlalchemy.select(
	s.t.accessors
	).where(
	s.t.accessors.c["device_name"] == device
	)
	)
	}

and here for device lookup:

slac-db/slac_db/device.py

Lines 60 to 76 in 8f86896

	def get_devices(area=None, device_type=None):
	""" Get all devices in an area of a type.
	Args:
	area (str) optional: Area name
	device_type (str) optional: Device type in Oracle
	Out:
	List of devices in alphabetical order.
	"""
	with _session() as s:
	selection = sqlalchemy.select(s.t.devices)
	if area is not None:
	selection = selection.where(s.t.devices.c["area"] == area)
	if device_type is not None:
	selection = selection.where(s.t.devices.c["device_type"] == device_type)
	return sorted([d["device_name"] for d in s.select(selection)])

If you need additional query styles we can definitely add those too, or create a PR to include them. I know all the DIAG0 cameras are available right now. If you see any more that aren't there but you'd like to include, let me know.

Thank you!