28 lines
1010 B
SQL
28 lines
1010 B
SQL
UPDATE "course_week_modules" AS module
|
|
SET "prebuilt_artifacts" = (
|
|
SELECT jsonb_agg(
|
|
CASE
|
|
WHEN artifact->>'fileName' = 'lms-nav2-gazebo-planning-build-install.tar.zst'
|
|
OR artifact->>'url' LIKE '%/lms-nav2-gazebo-planning-build-install.tar.zst'
|
|
THEN jsonb_set(
|
|
artifact,
|
|
'{checksumSha256}',
|
|
to_jsonb('6087b12b35a4c2ea3073c6b9fad5e43175d7425c2f4a042fa654e8c42b2bf29d'::text)
|
|
)
|
|
WHEN artifact->>'fileName' = 'lms-nav2-gazebo-control-build-install.tar.zst'
|
|
OR artifact->>'url' LIKE '%/lms-nav2-gazebo-control-build-install.tar.zst'
|
|
THEN jsonb_set(
|
|
artifact,
|
|
'{checksumSha256}',
|
|
to_jsonb('ce8949b8a14f6d29b3924b82d4819923368fb67029f45cc50a07175afa659a7a'::text)
|
|
)
|
|
ELSE artifact
|
|
END
|
|
)
|
|
FROM jsonb_array_elements(module."prebuilt_artifacts") AS artifact
|
|
)
|
|
WHERE module."folder_name" IN (
|
|
'[lms-nav2-gazebo-planning]nav2-planning_v1.0.0_ws',
|
|
'[lms-nav2-gazebo-control]nav2-control_v1.0.0_ws'
|
|
);
|