Add sp to retrieve beamlinesetup info
stufisher opened this issue · 3 comments
stufisher commented
Could we have an sp to retrieve beamlinesetup info for a specific beamlinename. This should return the current active beaminesetup for a given beamlinename (active=1).
The second option is also to return a beamlinesetup based on a datacollectionid, but this requires that gda correctly populated beamlinesetup in datacollection which may not be the case outside of mx. So maybe a second sp with a different signature
Useful fields to return:
preferredDatacentre
The table has:
detectorId
synchrotronMode
undulatorType1
undulatorType2
undulatorType3
focalSpotSizeAtSample
focusingOptic
beamDivergenceHorizontal
beamDivergenceVertical
polarisation
monochromatorType
setupDate
synchrotronName
maxExpTimePerDataCollection
maxExposureTimePerImage
minExposureTimePerImage
goniostatMaxOscillationSpeed
goniostatMaxOscillationWidth
goniostatMinOscillationWidth
maxTransmission
minTransmission
recordTimeStamp
CS
beamlineName
beamSizeXMin
beamSizeXMax
beamSizeYMin
beamSizeYMax
energyMin
energyMax
omegaMin
omegaMax
kappaMin
kappaMax
phiMin
phiMax
active
numberOfImagesMax
numberOfImagesMin
boxSizeXMin
boxSizeXMax
boxSizeYMin
boxSizeYMax
monoBandwidthMin
monoBandwidthMax
stufisher commented
Markus Gerstel 10:23 AM
Preferred solution: add a beamlinesetup model and make it reachable via the data collection model 🙂
Anthchirp commented
database issue -> transferred to database repo
stufisher commented
Dont need this now there is sqlalchemy