[INSTRM-866] Convert spsaitActor, etc. experiment/exposure logs to new opDb tables. Created: 19/Dec/19  Updated: 16/Apr/20  Resolved: 16/Apr/20

Status: Done
Project: Instrument control development
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: cloomis Assignee: arnaud.lefur
Resolution: Done Votes: 0
Labels: SPS, opDB
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PDF File PFS-DAT-IPM003002-01_pfs_schema.pdf    
Issue Links:
Blocks
blocks INSTRM-778 Post-delivery, pre-operations SM1 cha... Done
Relates
relates to INSTRM-909 Change opDB according to LAM's propos... Done
relates to INSTRM-922 handle opDB schema in spsActor Done
relates to INSTRM-933 Migrate LAM spsAitCommands to the Sub... Done
Story Points: 3
Sprint: SM1PD-2019 E, SM1PD-2020 A, SM1PD-2020 B, SM1PD-2020 C, SM1PD-2020 D

 Description   

The spsaitActor "experiment" scripting already uses SQL tables to track commands, group exposures, and annotate results.

Convert that to the visit_set, etc. tables in the opDb. Note that these tables may not have been properly discussed with LAM – the changes were made as part of a much larger opDb reorganization. So please review the schema first...

 Comments   
Comment by arnaud.lefur [ 22/Jan/20 ]

I think that this design work for us, I would have to add one experiment table which groups visits together.
We would prefer to keep our own sqlite database up to date at least as a first step.

What is unclear to me in this schema is which piece of software handle a given table.

Generated at Sat Apr 05 13:49:24 JST 2025 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.