richardcalahan

<td class="paddingcomp" style="border-collapse:collapse; mso-table-lspace:0pt; mso-table-rspace:0pt;border:0px;padding:7px 15px;font-size:12pt;font-family:Arial,Helvetica;line-height:19pt;border-top:0px none ;   border-bottom:0px none ;padding-top:4px;padding-bottom:21px;padding-right:120px;padding-left:120px;">
  <div componentbgcolor="#000000" componentpaddingbottom="21px" componentpaddingleft="120px" componentpaddingright="120px" componentpaddingtop="4px" style="background-color: rgb(0, 0, 0);">
    <p align="center" style="font-family:Arial,verdana;font-size:12px; color:#000000;padding:0px;margin: 0;line-height: 19pt; text-align: center;"><font color="#ffffff" face="Arial, Helvetica" style="font-size: 10pt;">&nbsp;You are receiving this email as you signed up for our newsletters.</font></p>
    <p align="center" style="font-family:Arial,verdana;font-size:12px; color:#000000;padding:0px;margin: 0;line-height: 19pt; text-align: center;"><font color="#ffffff"><font face="Arial, Helvetica" style="font-size: 1

richardcalahan

#!/bin/bash

BUCKET="sgw-pd-t1"
PAGE_SIZE=10

# Search and replace this key
NEW_META_KEY="file-permissions"
NEW_META_VALUE="0777"

# can manually set in case of script failure, new token is output every `PAGE_SIZE` requests. 

richardcalahan

WITH 
custom_values AS (
  SELECT 
    location_id,
    COALESCE(
      JSONB_OBJECT_AGG(name, value) FILTER (WHERE name IS NOT NULL), 
      '{}'
    ) AS data
  FROM custom_values
  GROUP BY location_id