Advertisement
Kenedy-Hernique

Scripts que devem ser executados depois do deploy da sprint 41 em produção

Sep 29th, 2022 (edited)
1,829
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. update msauthpersonaldata
  2. set body = jsonb_set(body, '{profileImageBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
  3. where msauthpersonaldata.body -> 'profileImageBlobCache' is null;
  4.  
  5. update msclientscompanies
  6. set body = jsonb_set(body, '{logoImageBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
  7. where msclientscompanies.body -> 'logoImageBlobCache' is null;
  8.  
  9. update msvacanciesfunnel
  10. set body = jsonb_set(body, '{coverImageBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
  11. where msvacanciesfunnel.body -> 'coverImageBlobCache' is null;
  12.  
  13. update msadmissions
  14. set body = jsonb_set(body, '{medicalExamScheduling, medicalExamSchedulingGuideFileBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
  15. where msadmissions.body -> 'medicalExamScheduling' -> 'medicalExamSchedulingGuideFileBlobCache' is null;
  16.  
  17. update msadmissions
  18. set body = jsonb_set(body, '{accountOpeningLetter, openingLetterTemplateBlobCache}', ('{"sasUri": "", "creationDate": "", "durationInHours": ""}')::jsonb)
  19. where msadmissions.body -> 'accountOpeningLetter' -> 'openingLetterTemplateBlobCache' is null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement