Instrument control developmentIcon indicating the project type

Instrument control development

Uploaded image for project: 'Instrument control development'
  1. Instrument control development
  2. INSTRM-866

Convert spsaitActor, etc. experiment/exposure logs to new opDb tables.

    Details

    • Type: Task
    • Status: Done (View Workflow)
    • Priority: Normal
    • Resolution: Done
    • Component/s: None
    • Labels:
    • 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...

        Attachments

          Issue Links

          blocks

          Task - A task that needs to be done. INSTRM-778 Post-delivery, pre-operations SM1 changes at Subaru.

          • Normal - Normal priorities
          • Done
          relates to

          Task - A task that needs to be done. INSTRM-909 Change opDB according to LAM's proposal for AIT and operation of SpS on the mountain

          • Normal - Normal priorities
          • Done

          Task - A task that needs to be done. INSTRM-922 handle opDB schema in spsActor

          • Normal - Normal priorities
          • Done

          Task - A task that needs to be done. INSTRM-933 Migrate LAM spsAitCommands to the Subaru framework

          • Normal - Normal priorities
          • Done

            Activity

            Hide
            Permalink
            arnaud.lefur arnaud.lefur added a comment -

            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.

            Show
            arnaud.lefur arnaud.lefur added a comment - 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.

              People

              • Assignee:
                arnaud.lefur arnaud.lefur
                Reporter:
                cloomis cloomis
              • Votes:
                0 Vote for this issue
                Watchers:
                Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: