Skip to content
Snippets Groups Projects

Refactor aat_wrest

Closed Charlotte Hausman requested to merge refactor_aat_wrest into main
  • fileset_id == sdm_id for everything except VLBA and GBT! Please use sdm_id! If workspaces starts processing VLBA or GBT data we'll switch to using external_name for this field to avoid having multiple names for the same thing

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
139 Given an execution block science product locator and calibration science product locator, returns
140 the required metadata to run the restore CMS workflow
141 :return:
142 """
143
144 eb_sql = f"""
145 SELECT ngas_fileset_id as filesetId,
146 e.project_code as projectCode,
147 p.title as title,
148 e.starttime as startTime,
149 (a.firstname || ' ' || a.lastname) as observer,
150 telescope as telescope
151 FROM execution_blocks e
152 JOIN projects p on e.project_code = p.project_code
153 JOIN authors a on p.project_code = a.project_code
154 WHERE science_product_locator = %(spl)s AND a.is_pi = true
  • reopened

  • Janet Goldstein approved this merge request

    approved this merge request

  • Please register or sign in to reply
    Loading