vinnyjth/1-summary.md

## 1-summary.md

      
    Raw
  

              1-summary.md
            
          
    Diff Summary.

diff File

The diff file describes the net changes across the total DB. You should expect changes to this file to represent intended changes to the shovel output. If you are performing a refactor, with no intended code changes, you should expect no changes to this file.
csv File

The csv file represents all operations that were performed that resulted in a data update. This doesn't including touching a content item (only updating a timestamp), but does include wiping a field out and then restoring that field to it's original contents. It will also track id changes.
Optimally, a dag that is not producing changes should not be wiping/restoring data on a run (should produce an empty csv). Practically, we have a long way to go in this area. Some operations (such as keeping track of content_tags) is easier to do by wiping the table and restoring, which produces operations, but doesn't result in a net diff.

  
## 2-diff-5fbb4d3fdfcf2b6b04291e1b938adf232d44146d.diff
30c30
< 0e011141-7158-4f32-8413-cad64af875ec	Campbell	2301 Jacksboro Pike Suite 3	\N	LaFollette	TN	37766	36.34487	-84.161683	\N	\N	Campus	5	ministry_platform	\N	\N	f	\N	apollos_demo	campus
---
> 0e011141-7158-4f32-8413-cad64af875ec	Campbell	2301 Jacksboro Pike Suite 3	\N	LaFollette	TN	37766	36.34487	-84.161683	\N	\N	Campus	5	ministry_platform	\N	\N	f	c157be44-da49-456f-828f-bedfc6354626	apollos_demo	campus
41c41
< 686d6e59-c657-4342-b960-9a97d398de32	Friends						\N	\N	\N	\N	Campus	2	ministry_platform	\N	\N	f	\N	apollos_demo	campus
---
> 686d6e59-c657-4342-b960-9a97d398de32	Friends						\N	\N	\N	\N	Campus	2	ministry_platform	\N	\N	f	c157be44-da49-456f-828f-bedfc6354626	apollos_demo	campus
55c55
< ea30c956-8763-4e1a-b2b7-3e3795159ec3	UT						\N	\N	\N	\N	Campus	4	ministry_platform	\N	\N	f	\N	apollos_demo	campus
---
> ea30c956-8763-4e1a-b2b7-3e3795159ec3	UT						\N	\N	\N	\N	Campus	4	ministry_platform	\N	\N	f	c157be44-da49-456f-828f-bedfc6354626	apollos_demo	campus
1451c1451
< IMAGE	https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png	9ea5d1d4-af63-43c1-a4f9-9a77f81129d7	Community	https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png	planning_center	edaf32f0-c674-4344-a76c-5da6d0fbcc7a	ImageMedia	\N	\N	{}	apollos_demo	media
---
> IMAGE	https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png	9ea5d1d4-af63-43c1-a4f9-9a77f81129d7	Community	https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png	planning_center	edaf32f0-c674-4344-a76c-5da6d0fbcc7a	ImageMedia	\N	\N	{"width": 1280, "height": 720}	apollos_demo	media
1869c1869
< IMAGE	https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb	f75c1aef-bbd6-4415-8ef0-e948020b5043	Campus	campusimage-71	rock	c157be44-da49-456f-828f-bedfc6354626	IMAGE	\N	\N	{"width": 183, "height": 183}	apollos_demo	media
---
> IMAGE	https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb	0e011141-7158-4f32-8413-cad64af875ec	Campus	campusimage-71	rock	c157be44-da49-456f-828f-bedfc6354626	IMAGE	\N	\N	{"width": 183, "height": 183}	apollos_demo	media

## 3-changes-5fbb4d3fdfcf2b6b04291e1b938adf232d44146d.csv

          
            table_name
            changed_fields
            client_query
            action
            row_data

            
              media
              "metadata"=>"{}"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type, metadata) VALUES ('ImageMedia','2024-05-19T20:08:46.901808+00:00'::timestamptz,'2024-05-19T20:08:46.901808+00:00'::timestamptz,NULL,NULL,'IMAGE','https://rock.apollos.app/GetImage.ashx?guid=8ee5a840-0a10-44e2-9dbe-214af27c234b',13,'rock','{}') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url, metadata = excluded.metadata
              U
              "id"=>"44dc32d7-16c0-44fa-aaad-181c03389d16","url"=>"https://rock.apollos.app/GetImage.ashx?guid=8ee5a840-0a10-44e2-9dbe-214af27c234b","type"=>"IMAGE","node_id"=>NULL,"metadata"=>"{\"audio\": {\"codec\": \"ISO/IEC 14496-3 AAC\", \"channels\": 2, \"lossless\": false, \"dataformat\": \"mp4\", \"channelmode\": \"stereo\", \"sample_rate\": 48000, \"bits_per_sample\": 16}, \"sizes\": {}, \"width\": 426, \"height\": 240, \"length\": 488, \"duration\": 488, \"filesize\": 13138402, \"mime_type\": \"video/mp4\", \"dataformat\": \"quicktime\", \"fileformat\": \"mp4\", \"length_formatted\": \"8:08\", \"created_timestamp\": 1613140927}","node_type"=>NULL,"origin_id"=>"13","apollos_id"=>"ImageMedia:44dc32d7-16c0-44fa-aaad-181c03389d16","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"ImageMedia"

            
              media
              "metadata"=>"{}"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type, metadata) VALUES ('ImageMedia','2024-05-19T20:08:46.901808+00:00'::timestamptz,'2024-05-19T20:08:46.901808+00:00'::timestamptz,NULL,NULL,'IMAGE','https://rock.apollos.app/GetImage.ashx?guid=5047381d-0ca9-49f7-9894-699c296baab6',18,'rock','{}') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url, metadata = excluded.metadata
              U
              "id"=>"415a59eb-cf75-4d6b-a497-df6d7558dcb8","url"=>"https://rock.apollos.app/GetImage.ashx?guid=5047381d-0ca9-49f7-9894-699c296baab6","type"=>"IMAGE","node_id"=>NULL,"metadata"=>"{\"width\": 960, \"height\": 180}","node_type"=>NULL,"origin_id"=>"18","apollos_id"=>"ImageMedia:415a59eb-cf75-4d6b-a497-df6d7558dcb8","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"ImageMedia"

            
              media
              "metadata"=>"{}"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type, metadata) VALUES ('ImageMedia','2024-05-19T20:08:46.901808+00:00'::timestamptz,'2024-05-19T20:08:46.901808+00:00'::timestamptz,NULL,NULL,'IMAGE','https://rock.apollos.app/GetImage.ashx?guid=d00fceaa-2d16-40bf-9ba4-352d42605e28',10,'rock','{}') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url, metadata = excluded.metadata
              U
              "id"=>"45354681-34a7-45d0-bc1b-54eae06e1dc9","url"=>"https://rock.apollos.app/GetImage.ashx?guid=d00fceaa-2d16-40bf-9ba4-352d42605e28","type"=>"IMAGE","node_id"=>NULL,"metadata"=>"{\"width\": 960, \"height\": 180}","node_type"=>NULL,"origin_id"=>"10","apollos_id"=>"ImageMedia:45354681-34a7-45d0-bc1b-54eae06e1dc9","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"ImageMedia"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"775e6759-a791-42b1-b7fe-0b3d8bc8abc8","event_id"=>"d7198d20-df97-4131-9a7f-e05ad5cb3a67","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"8ef0f598-b6d5-4cd7-ba2a-a4696b9c0d39","event_id"=>"0f7aecb6-451a-4e4b-936a-9205672ae078","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"8ef0f598-b6d5-4cd7-ba2a-a4696b9c0d39","event_id"=>"d7198d20-df97-4131-9a7f-e05ad5cb3a67","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"8ef0f598-b6d5-4cd7-ba2a-a4696b9c0d39","event_id"=>"f7ea278c-fb3e-468e-bd0f-15d5ec39ab3f","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"04a5fa29-8411-418b-a76b-8cc543fea49d","event_id"=>"0f7aecb6-451a-4e4b-936a-9205672ae078","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"04a5fa29-8411-418b-a76b-8cc543fea49d","event_id"=>"d7198d20-df97-4131-9a7f-e05ad5cb3a67","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"04a5fa29-8411-418b-a76b-8cc543fea49d","event_id"=>"f7ea278c-fb3e-468e-bd0f-15d5ec39ab3f","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"1e52624d-7fee-4c6e-bd56-2c948e4732f2","event_id"=>"f7ea278c-fb3e-468e-bd0f-15d5ec39ab3f","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"6ad05b0e-0c4f-4c3f-92b4-0581f52f2bf2","event_id"=>"0f7aecb6-451a-4e4b-936a-9205672ae078","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"6ad05b0e-0c4f-4c3f-92b4-0581f52f2bf2","event_id"=>"d7198d20-df97-4131-9a7f-e05ad5cb3a67","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-148' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^2(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"8ef0f598-b6d5-4cd7-ba2a-a4696b9c0d39","event_id"=>"0f7aecb6-451a-4e4b-936a-9205672ae078","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-151' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^2(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"6ad05b0e-0c4f-4c3f-92b4-0581f52f2bf2","event_id"=>"0f7aecb6-451a-4e4b-936a-9205672ae078","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-24' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^2(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"04a5fa29-8411-418b-a76b-8cc543fea49d","event_id"=>"0f7aecb6-451a-4e4b-936a-9205672ae078","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-148' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^3(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"8ef0f598-b6d5-4cd7-ba2a-a4696b9c0d39","event_id"=>"d7198d20-df97-4131-9a7f-e05ad5cb3a67","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-151' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^3(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"6ad05b0e-0c4f-4c3f-92b4-0581f52f2bf2","event_id"=>"d7198d20-df97-4131-9a7f-e05ad5cb3a67","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-152' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^3(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"775e6759-a791-42b1-b7fe-0b3d8bc8abc8","event_id"=>"d7198d20-df97-4131-9a7f-e05ad5cb3a67","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-24' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^3(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"04a5fa29-8411-418b-a76b-8cc543fea49d","event_id"=>"d7198d20-df97-4131-9a7f-e05ad5cb3a67","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-148' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^4(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"8ef0f598-b6d5-4cd7-ba2a-a4696b9c0d39","event_id"=>"f7ea278c-fb3e-468e-bd0f-15d5ec39ab3f","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-24' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^4(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"04a5fa29-8411-418b-a76b-8cc543fea49d","event_id"=>"f7ea278c-fb3e-468e-bd0f-15d5ec39ab3f","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-147' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^4(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"1e52624d-7fee-4c6e-bd56-2c948e4732f2","event_id"=>"f7ea278c-fb3e-468e-bd0f-15d5ec39ab3f","church_slug"=>"apollos_demo"

            
              media
              "metadata"=>"{\"audio\": {\"codec\": \"ISO/IEC 14496-3 AAC\", \"channels\": 2, \"lossless\": false, \"dataformat\": \"mp4\", \"channelmode\": \"stereo\", \"sample_rate\": 48000, \"bits_per_sample\": 16}, \"sizes\": {}, \"width\": 426, \"height\": 240, \"length\": 488, \"duration\": 488, \"filesize\": 13138402, \"mime_type\": \"video/mp4\", \"dataformat\": \"quicktime\", \"fileformat\": \"mp4\", \"length_formatted\": \"8:08\", \"created_timestamp\": 1613140927}"
              
            UPDATE
                media
            SET
                metadata = metadata::jsonb || '{"filesize": 13138402,"mime_type": "video/mp4","length": 488,"length_formatted": "8:08","width": 426,"height": 240,"fileformat": "mp4","dataformat": "quicktime","audio": {"dataformat": "mp4","codec": "ISO/IEC 14496-3 AAC","sample_rate": 48000,"channels": 2,"bits_per_sample": 16,"lossless": false,"channelmode": "stereo"},"created_timestamp": 1613140927,"sizes": {},"duration": 488}'::jsonb
            WHERE
                origin_id = '13'
        
              U
              "id"=>"44dc32d7-16c0-44fa-aaad-181c03389d16","url"=>"https://rock.apollos.app/GetImage.ashx?guid=8ee5a840-0a10-44e2-9dbe-214af27c234b","type"=>"IMAGE","node_id"=>NULL,"metadata"=>"{}","node_type"=>NULL,"origin_id"=>"13","apollos_id"=>"ImageMedia:44dc32d7-16c0-44fa-aaad-181c03389d16","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"ImageMedia"

            
              media
              "metadata"=>"{\"width\": 960, \"height\": 180}"
              
                            UPDATE
                                media
                            SET
                                metadata = metadata || '{"width": 960,"height": 180}'::jsonb
                            WHERE
                                id = '45354681-34a7-45d0-bc1b-54eae06e1dc9'::uuid
                                
              U
              "id"=>"45354681-34a7-45d0-bc1b-54eae06e1dc9","url"=>"https://rock.apollos.app/GetImage.ashx?guid=d00fceaa-2d16-40bf-9ba4-352d42605e28","type"=>"IMAGE","node_id"=>NULL,"metadata"=>"{}","node_type"=>NULL,"origin_id"=>"10","apollos_id"=>"ImageMedia:45354681-34a7-45d0-bc1b-54eae06e1dc9","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"ImageMedia"

            
              media
              "metadata"=>"{\"width\": 960, \"height\": 180}"
              
                            UPDATE
                                media
                            SET
                                metadata = metadata || '{"width": 960,"height": 180}'::jsonb
                            WHERE
                                id = '415a59eb-cf75-4d6b-a497-df6d7558dcb8'::uuid
                                
              U
              "id"=>"415a59eb-cf75-4d6b-a497-df6d7558dcb8","url"=>"https://rock.apollos.app/GetImage.ashx?guid=5047381d-0ca9-49f7-9894-699c296baab6","type"=>"IMAGE","node_id"=>NULL,"metadata"=>"{}","node_type"=>NULL,"origin_id"=>"18","apollos_id"=>"ImageMedia:415a59eb-cf75-4d6b-a497-df6d7558dcb8","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"ImageMedia"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('3a7454a1-3699-45eb-8ba3-2b09d4bbcff0')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"554e1286-794b-4878-8959-df18045c0bb6","church_slug"=>"apollos_demo","content_item_id"=>"3a7454a1-3699-45eb-8ba3-2b09d4bbcff0"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('3a7454a1-3699-45eb-8ba3-2b09d4bbcff0','2024-05-19T20:09:15.796022+00:00'::timestamptz,'554e1286-794b-4878-8959-df18045c0bb6','2024-05-19T20:09:15.796022+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"554e1286-794b-4878-8959-df18045c0bb6","church_slug"=>"apollos_demo","content_item_id"=>"3a7454a1-3699-45eb-8ba3-2b09d4bbcff0"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('2980bc1a-9ca8-4906-a872-6274e5081208','57f2e6ce-57e3-4d64-8f93-448cf798373a','d7241638-95e4-481d-9413-8a7c55297d95','eb30ea93-b676-4814-97fa-4bea081dbc38','344bb9ad-6d3c-4488-bee1-9dcd9f1f2a87')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"b4ea0f0c-9214-4e79-ab71-1adb94ae4987","church_slug"=>"apollos_demo","content_item_id"=>"2980bc1a-9ca8-4906-a872-6274e5081208"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('2980bc1a-9ca8-4906-a872-6274e5081208','57f2e6ce-57e3-4d64-8f93-448cf798373a','d7241638-95e4-481d-9413-8a7c55297d95','eb30ea93-b676-4814-97fa-4bea081dbc38','344bb9ad-6d3c-4488-bee1-9dcd9f1f2a87')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"b4ea0f0c-9214-4e79-ab71-1adb94ae4987","church_slug"=>"apollos_demo","content_item_id"=>"eb30ea93-b676-4814-97fa-4bea081dbc38"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('2980bc1a-9ca8-4906-a872-6274e5081208','57f2e6ce-57e3-4d64-8f93-448cf798373a','d7241638-95e4-481d-9413-8a7c55297d95','eb30ea93-b676-4814-97fa-4bea081dbc38','344bb9ad-6d3c-4488-bee1-9dcd9f1f2a87')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"f319461a-1b40-40cc-939b-83e8f72bf86f","church_slug"=>"apollos_demo","content_item_id"=>"2980bc1a-9ca8-4906-a872-6274e5081208"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('2980bc1a-9ca8-4906-a872-6274e5081208','57f2e6ce-57e3-4d64-8f93-448cf798373a','d7241638-95e4-481d-9413-8a7c55297d95','eb30ea93-b676-4814-97fa-4bea081dbc38','344bb9ad-6d3c-4488-bee1-9dcd9f1f2a87')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"fa119e7d-6a86-4bcb-a342-4ea189fc02f4","church_slug"=>"apollos_demo","content_item_id"=>"eb30ea93-b676-4814-97fa-4bea081dbc38"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('2980bc1a-9ca8-4906-a872-6274e5081208','2024-05-19T20:09:15.796022+00:00'::timestamptz,'b4ea0f0c-9214-4e79-ab71-1adb94ae4987','2024-05-19T20:09:15.796022+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"b4ea0f0c-9214-4e79-ab71-1adb94ae4987","church_slug"=>"apollos_demo","content_item_id"=>"2980bc1a-9ca8-4906-a872-6274e5081208"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('2980bc1a-9ca8-4906-a872-6274e5081208','2024-05-19T20:09:15.796022+00:00'::timestamptz,'f319461a-1b40-40cc-939b-83e8f72bf86f','2024-05-19T20:09:15.796022+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"f319461a-1b40-40cc-939b-83e8f72bf86f","church_slug"=>"apollos_demo","content_item_id"=>"2980bc1a-9ca8-4906-a872-6274e5081208"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('eb30ea93-b676-4814-97fa-4bea081dbc38','2024-05-19T20:09:15.796022+00:00'::timestamptz,'b4ea0f0c-9214-4e79-ab71-1adb94ae4987','2024-05-19T20:09:15.796022+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"b4ea0f0c-9214-4e79-ab71-1adb94ae4987","church_slug"=>"apollos_demo","content_item_id"=>"eb30ea93-b676-4814-97fa-4bea081dbc38"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('eb30ea93-b676-4814-97fa-4bea081dbc38','2024-05-19T20:09:15.796022+00:00'::timestamptz,'fa119e7d-6a86-4bcb-a342-4ea189fc02f4','2024-05-19T20:09:15.796022+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"fa119e7d-6a86-4bcb-a342-4ea189fc02f4","church_slug"=>"apollos_demo","content_item_id"=>"eb30ea93-b676-4814-97fa-4bea081dbc38"

            
              media
              "node_id"=>"0e011141-7158-4f32-8413-cad64af875ec"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-19T20:07:54.164316+00:00'::timestamptz,'2024-05-19T20:07:54.164316+00:00'::timestamptz,'0e011141-7158-4f32-8413-cad64af875ec','Campus','IMAGE','https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb','campusimage-71','rock') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url
              U
              "id"=>"c157be44-da49-456f-828f-bedfc6354626","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"ea30c956-8763-4e1a-b2b7-3e3795159ec3","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:c157be44-da49-456f-828f-bedfc6354626","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              campus
              "image_id"=>"c157be44-da49-456f-828f-bedfc6354626"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '686d6e59-c657-4342-b960-9a97d398de32' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"686d6e59-c657-4342-b960-9a97d398de32","city"=>"","name"=>"Friends","state"=>"","active"=>"f","digital"=>NULL,"street1"=>"","street2"=>"","image_id"=>NULL,"latitude"=>NULL,"image_url"=>NULL,"longitude"=>NULL,"origin_id"=>"2","apollos_id"=>"Campus:686d6e59-c657-4342-b960-9a97d398de32","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"

            
              campus
              "image_id"=>"c157be44-da49-456f-828f-bedfc6354626"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = 'ea30c956-8763-4e1a-b2b7-3e3795159ec3' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"ea30c956-8763-4e1a-b2b7-3e3795159ec3","city"=>"","name"=>"UT","state"=>"","active"=>"f","digital"=>NULL,"street1"=>"","street2"=>"","image_id"=>NULL,"latitude"=>NULL,"image_url"=>NULL,"longitude"=>NULL,"origin_id"=>"4","apollos_id"=>"Campus:ea30c956-8763-4e1a-b2b7-3e3795159ec3","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"

            
              campus
              "image_id"=>"c157be44-da49-456f-828f-bedfc6354626"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '0e011141-7158-4f32-8413-cad64af875ec' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"0e011141-7158-4f32-8413-cad64af875ec","city"=>"LaFollette","name"=>"Campbell","state"=>"TN","active"=>"f","digital"=>NULL,"street1"=>"2301 Jacksboro Pike Suite 3","street2"=>NULL,"image_id"=>NULL,"latitude"=>"36.34487","image_url"=>NULL,"longitude"=>"-84.161683","origin_id"=>"5","apollos_id"=>"Campus:0e011141-7158-4f32-8413-cad64af875ec","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"37766","apollos_type"=>"Campus"

            
              node_slug
              "node_id"=>"7e86e08e-1377-42b1-96cc-4e3dd614678b"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', 'giving', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '56'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"152bad59-1612-40ef-9a7e-749743a25dd1","slug"=>"giving","node_id"=>"89309afb-0326-41cd-a895-2f2eb1669514","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"89309afb-0326-41cd-a895-2f2eb1669514"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', 'giving', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '55'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"152bad59-1612-40ef-9a7e-749743a25dd1","slug"=>"giving","node_id"=>"7e86e08e-1377-42b1-96cc-4e3dd614678b","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"2f6472ce-f951-404b-b6f0-96c5aeece874"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', 'at-the-movies', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '45'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"057c0547-0c2f-412d-82d7-3e4a552d21fe","slug"=>"at-the-movies","node_id"=>"b98c74ff-4451-48db-a8e1-c583fa9a661d","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"59f12d80-bbba-48a8-ba1f-e89950b0ee50"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', '1x8', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '44'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"79dbef06-48a2-43b5-9011-78742a9dcf10","slug"=>"1x8","node_id"=>"2a7aa98a-429c-4b87-a119-7a47ea433134","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"7b35697a-6e27-4559-b393-18b4531d0718"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', 'potential', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '43'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"89e87268-fe56-492b-9b44-b0ecb65216ef","slug"=>"potential","node_id"=>"93389aa3-6a4e-4ac8-a4e6-a72eb2043fe8","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"1ad729dd-fb05-4bac-9786-48bd186eeeae"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', 'arrival', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '41'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"db4d6e0b-2d1a-42c2-bee9-8327a45b2465","slug"=>"arrival","node_id"=>"01d50354-2ef7-403a-9c15-b9c4bfaf8dc7","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"b98c74ff-4451-48db-a8e1-c583fa9a661d"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', 'at-the-movies', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '29'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"057c0547-0c2f-412d-82d7-3e4a552d21fe","slug"=>"at-the-movies","node_id"=>"2f6472ce-f951-404b-b6f0-96c5aeece874","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"2a7aa98a-429c-4b87-a119-7a47ea433134"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', '1x8', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '28'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"79dbef06-48a2-43b5-9011-78742a9dcf10","slug"=>"1x8","node_id"=>"59f12d80-bbba-48a8-ba1f-e89950b0ee50","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"93389aa3-6a4e-4ac8-a4e6-a72eb2043fe8"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', 'potential', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '27'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"89e87268-fe56-492b-9b44-b0ecb65216ef","slug"=>"potential","node_id"=>"7b35697a-6e27-4559-b393-18b4531d0718","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"01d50354-2ef7-403a-9c15-b9c4bfaf8dc7"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-19 20:08:13.807419+00:00', '2024-05-19 20:08:13.807419+00:00', 'arrival', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '25'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"db4d6e0b-2d1a-42c2-bee9-8327a45b2465","slug"=>"arrival","node_id"=>"1ad729dd-fb05-4bac-9786-48bd186eeeae","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              content_tag
              
              
                DELETE
                FROM content_tag
                WHERE
                    content_item_id = '20a51df2-a39a-439c-9636-127926633b80'
                    AND tag_id IN ('75961663-9714-4385-9bd2-dda472bfed15', '688643fe-99e0-4bdb-b481-92d279f0d541', '2bb3de62-a1d6-49cc-8fed-7f0bb156943f', 'c4fa1e6b-3027-49d1-81d8-931b2739f195', '14a2f40f-7acc-4fbb-9240-2d15411a1993', '2235b875-8cda-4899-a67a-c5dc0ddc8a04', '7a8181de-f01d-44f8-95e3-504a8258c662')
                
              D
              "tag_id"=>"688643fe-99e0-4bdb-b481-92d279f0d541","church_slug"=>"apollos_demo","content_item_id"=>"20a51df2-a39a-439c-9636-127926633b80"

            
              content_tag
              
              
                    INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
                    VALUES ('688643fe-99e0-4bdb-b481-92d279f0d541', '20a51df2-a39a-439c-9636-127926633b80', NOW(), NOW())
                    
              I
              "tag_id"=>"688643fe-99e0-4bdb-b481-92d279f0d541","church_slug"=>"apollos_demo","content_item_id"=>"20a51df2-a39a-439c-9636-127926633b80"

            
              media
              "metadata"=>"{\"width\": 1280, \"height\": 720}"
              
                            UPDATE
                                media
                            SET
                                metadata = metadata || '{"width": 1280,"height": 720}'::jsonb
                            WHERE
                                id = 'edaf32f0-c674-4344-a76c-5da6d0fbcc7a'::uuid
                                
              U
              "id"=>"edaf32f0-c674-4344-a76c-5da6d0fbcc7a","url"=>"https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png","type"=>"IMAGE","node_id"=>"9ea5d1d4-af63-43c1-a4f9-9a77f81129d7","metadata"=>"{}","node_type"=>"Community","origin_id"=>"https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png","apollos_id"=>"ImageMedia:edaf32f0-c674-4344-a76c-5da6d0fbcc7a","church_slug"=>"apollos_demo","origin_type"=>"planning_center","apollos_type"=>"ImageMedia"

            
              media
              "node_id"=>"1963524d-d0fd-46ef-97b3-f7ce5e3f065a"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-19T20:07:54.164316+00:00'::timestamptz,'2024-05-19T20:07:54.164316+00:00'::timestamptz,'1963524d-d0fd-46ef-97b3-f7ce5e3f065a','Campus','IMAGE','https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb','campusimage-71','rock') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url
              U
              "id"=>"c157be44-da49-456f-828f-bedfc6354626","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"f75c1aef-bbd6-4415-8ef0-e948020b5043","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:c157be44-da49-456f-828f-bedfc6354626","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"686d6e59-c657-4342-b960-9a97d398de32"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-19T20:07:54.164316+00:00'::timestamptz,'2024-05-19T20:07:54.164316+00:00'::timestamptz,'686d6e59-c657-4342-b960-9a97d398de32','Campus','IMAGE','https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb','campusimage-71','rock') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url
              U
              "id"=>"c157be44-da49-456f-828f-bedfc6354626","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"1963524d-d0fd-46ef-97b3-f7ce5e3f065a","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:c157be44-da49-456f-828f-bedfc6354626","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"ea30c956-8763-4e1a-b2b7-3e3795159ec3"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-19T20:07:54.164316+00:00'::timestamptz,'2024-05-19T20:07:54.164316+00:00'::timestamptz,'ea30c956-8763-4e1a-b2b7-3e3795159ec3','Campus','IMAGE','https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb','campusimage-71','rock') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url
              U
              "id"=>"c157be44-da49-456f-828f-bedfc6354626","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"686d6e59-c657-4342-b960-9a97d398de32","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:c157be44-da49-456f-828f-bedfc6354626","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"
	30c30
	< 0e011141-7158-4f32-8413-cad64af875ec Campbell 2301 Jacksboro Pike Suite 3 \N LaFollette TN 37766 36.34487 -84.161683 \N \N Campus 5 ministry_platform \N \N f \N apollos_demo campus
	---
	> 0e011141-7158-4f32-8413-cad64af875ec Campbell 2301 Jacksboro Pike Suite 3 \N LaFollette TN 37766 36.34487 -84.161683 \N \N Campus 5 ministry_platform \N \N f c157be44-da49-456f-828f-bedfc6354626 apollos_demo campus
	41c41
	< 686d6e59-c657-4342-b960-9a97d398de32 Friends \N \N \N \N Campus 2 ministry_platform \N \N f \N apollos_demo campus
	---
	> 686d6e59-c657-4342-b960-9a97d398de32 Friends \N \N \N \N Campus 2 ministry_platform \N \N f c157be44-da49-456f-828f-bedfc6354626 apollos_demo campus
	55c55
	< ea30c956-8763-4e1a-b2b7-3e3795159ec3 UT \N \N \N \N Campus 4 ministry_platform \N \N f \N apollos_demo campus
	---
	> ea30c956-8763-4e1a-b2b7-3e3795159ec3 UT \N \N \N \N Campus 4 ministry_platform \N \N f c157be44-da49-456f-828f-bedfc6354626 apollos_demo campus
	1451c1451
	< IMAGE https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png 9ea5d1d4-af63-43c1-a4f9-9a77f81129d7 Community https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png planning_center edaf32f0-c674-4344-a76c-5da6d0fbcc7a ImageMedia \N \N {} apollos_demo media
	---
	> IMAGE https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png 9ea5d1d4-af63-43c1-a4f9-9a77f81129d7 Community https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png planning_center edaf32f0-c674-4344-a76c-5da6d0fbcc7a ImageMedia \N \N {"width": 1280, "height": 720} apollos_demo media
	1869c1869
	< IMAGE https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb f75c1aef-bbd6-4415-8ef0-e948020b5043 Campus campusimage-71 rock c157be44-da49-456f-828f-bedfc6354626 IMAGE \N \N {"width": 183, "height": 183} apollos_demo media
	---
	> IMAGE https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb 0e011141-7158-4f32-8413-cad64af875ec Campus campusimage-71 rock c157be44-da49-456f-828f-bedfc6354626 IMAGE \N \N {"width": 183, "height": 183} apollos_demo media