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-55217d13d8aedbdb9bc9207239b7bc52e613bfc3.diff
45c45
< 74e0eb83-a7d1-40f8-969c-964d12b0c5cb	Friends						\N	\N	\N	\N	Campus	2	ministry_platform	\N	\N	f	\N	apollos_demo	campus
---
> 74e0eb83-a7d1-40f8-969c-964d12b0c5cb	Friends						\N	\N	\N	\N	Campus	2	ministry_platform	\N	\N	f	a2d2ee93-9ef5-462d-b217-6b2bb64afd4e	apollos_demo	campus
48c48
< 7f756f73-3e5c-478e-a2a4-86e80adb9914	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
---
> 7f756f73-3e5c-478e-a2a4-86e80adb9914	Campbell	2301 Jacksboro Pike Suite 3	\N	LaFollette	TN	37766	36.34487	-84.161683	\N	\N	Campus	5	ministry_platform	\N	\N	f	a2d2ee93-9ef5-462d-b217-6b2bb64afd4e	apollos_demo	campus
55c55
< fac6c5ce-e3a3-46f4-848d-7928ec81f77e	UT						\N	\N	\N	\N	Campus	4	ministry_platform	\N	\N	f	\N	apollos_demo	campus
---
> fac6c5ce-e3a3-46f4-848d-7928ec81f77e	UT						\N	\N	\N	\N	Campus	4	ministry_platform	\N	\N	f	a2d2ee93-9ef5-462d-b217-6b2bb64afd4e	apollos_demo	campus
1450c1450
< IMAGE	https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png	a46655a9-f837-4636-a019-b79084856ddb	Community	https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png	planning_center	988486fe-02d2-4e7f-9c54-2bb635d6557d	ImageMedia	\N	\N	{}	apollos_demo	media
---
> IMAGE	https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png	a46655a9-f837-4636-a019-b79084856ddb	Community	https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png	planning_center	988486fe-02d2-4e7f-9c54-2bb635d6557d	ImageMedia	\N	\N	{"width": 1280, "height": 720}	apollos_demo	media
1867c1867
< IMAGE	https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb	5ab41342-d3f7-4dbf-82d9-daf62de8a0de	Campus	campusimage-71	rock	a2d2ee93-9ef5-462d-b217-6b2bb64afd4e	IMAGE	\N	\N	{"width": 183, "height": 183}	apollos_demo	media
---
> IMAGE	https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb	7f756f73-3e5c-478e-a2a4-86e80adb9914	Campus	campusimage-71	rock	a2d2ee93-9ef5-462d-b217-6b2bb64afd4e	IMAGE	\N	\N	{"width": 183, "height": 183}	apollos_demo	media

## 3-changes-55217d13d8aedbdb9bc9207239b7bc52e613bfc3.csv

          
            table_name
            changed_fields
            client_query
            action
            row_data

            
              media
              "node_id"=>"fe579753-6a16-407d-affd-0f68596c1a85"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-14T19:17:06.810789+00:00'::timestamptz,'2024-05-14T19:17:06.810789+00:00'::timestamptz,'fe579753-6a16-407d-affd-0f68596c1a85','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"=>"a2d2ee93-9ef5-462d-b217-6b2bb64afd4e","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"5ab41342-d3f7-4dbf-82d9-daf62de8a0de","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:a2d2ee93-9ef5-462d-b217-6b2bb64afd4e","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"74e0eb83-a7d1-40f8-969c-964d12b0c5cb"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-14T19:17:06.810789+00:00'::timestamptz,'2024-05-14T19:17:06.810789+00:00'::timestamptz,'74e0eb83-a7d1-40f8-969c-964d12b0c5cb','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"=>"a2d2ee93-9ef5-462d-b217-6b2bb64afd4e","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"fe579753-6a16-407d-affd-0f68596c1a85","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:a2d2ee93-9ef5-462d-b217-6b2bb64afd4e","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"fac6c5ce-e3a3-46f4-848d-7928ec81f77e"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-14T19:17:06.810789+00:00'::timestamptz,'2024-05-14T19:17:06.810789+00:00'::timestamptz,'fac6c5ce-e3a3-46f4-848d-7928ec81f77e','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"=>"a2d2ee93-9ef5-462d-b217-6b2bb64afd4e","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"74e0eb83-a7d1-40f8-969c-964d12b0c5cb","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:a2d2ee93-9ef5-462d-b217-6b2bb64afd4e","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"7f756f73-3e5c-478e-a2a4-86e80adb9914"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-14T19:17:06.810789+00:00'::timestamptz,'2024-05-14T19:17:06.810789+00:00'::timestamptz,'7f756f73-3e5c-478e-a2a4-86e80adb9914','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"=>"a2d2ee93-9ef5-462d-b217-6b2bb64afd4e","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"fac6c5ce-e3a3-46f4-848d-7928ec81f77e","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:a2d2ee93-9ef5-462d-b217-6b2bb64afd4e","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              campus
              "image_id"=>"a2d2ee93-9ef5-462d-b217-6b2bb64afd4e"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '74e0eb83-a7d1-40f8-969c-964d12b0c5cb' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"74e0eb83-a7d1-40f8-969c-964d12b0c5cb","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:74e0eb83-a7d1-40f8-969c-964d12b0c5cb","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"

            
              campus
              "image_id"=>"a2d2ee93-9ef5-462d-b217-6b2bb64afd4e"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = 'fac6c5ce-e3a3-46f4-848d-7928ec81f77e' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"fac6c5ce-e3a3-46f4-848d-7928ec81f77e","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:fac6c5ce-e3a3-46f4-848d-7928ec81f77e","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"

            
              campus
              "image_id"=>"a2d2ee93-9ef5-462d-b217-6b2bb64afd4e"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '7f756f73-3e5c-478e-a2a4-86e80adb9914' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"7f756f73-3e5c-478e-a2a4-86e80adb9914","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:7f756f73-3e5c-478e-a2a4-86e80adb9914","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"37766","apollos_type"=>"Campus"

            
              node_slug
              "node_id"=>"24be3be4-c68f-45f7-a65c-0edb5f7b6d21"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"0bb9b858-1fee-4992-b1a0-be8ba9464fd9","slug"=>"giving","node_id"=>"75f0bdd3-4ca3-4e30-82a2-1ce3d90b4178","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"75f0bdd3-4ca3-4e30-82a2-1ce3d90b4178"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"0bb9b858-1fee-4992-b1a0-be8ba9464fd9","slug"=>"giving","node_id"=>"24be3be4-c68f-45f7-a65c-0edb5f7b6d21","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"a67f2237-7359-4f4c-92e2-edba92ff4237"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"1c085a27-751e-41b2-9389-be38648ad493","slug"=>"at-the-movies","node_id"=>"dd8e0789-7421-40c3-bb24-f4205e0d0468","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"dcd059a1-fff5-4283-8b44-de4293cc867d"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"6d1f9aee-7bfd-4b3b-bb16-66d35114ac68","slug"=>"1x8","node_id"=>"5b400c54-71b1-463d-b7b0-27cb19dada30","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"e0615bbf-66e0-4611-88c6-498b274a1934"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"e9657089-4f4e-474b-9d1d-e0df574f3747","slug"=>"potential","node_id"=>"3f159178-b765-4ffc-b461-e51df6fe2f34","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"5e004d09-b101-443c-b29e-304a31762188"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"bfd9a8c2-57da-409a-bda8-51a4e56d72fd","slug"=>"arrival","node_id"=>"7df1565f-ee60-4be2-9998-777a40b252f8","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"dd8e0789-7421-40c3-bb24-f4205e0d0468"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"1c085a27-751e-41b2-9389-be38648ad493","slug"=>"at-the-movies","node_id"=>"a67f2237-7359-4f4c-92e2-edba92ff4237","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"5b400c54-71b1-463d-b7b0-27cb19dada30"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"6d1f9aee-7bfd-4b3b-bb16-66d35114ac68","slug"=>"1x8","node_id"=>"dcd059a1-fff5-4283-8b44-de4293cc867d","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"3f159178-b765-4ffc-b461-e51df6fe2f34"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"e9657089-4f4e-474b-9d1d-e0df574f3747","slug"=>"potential","node_id"=>"e0615bbf-66e0-4611-88c6-498b274a1934","node_type"=>"ContentItem","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"=>"c4df1073-6541-4cee-81b5-8d25dda4f16f","event_id"=>"76c6335b-a9b6-4051-9206-3c8263f4ae94","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"7df1565f-ee60-4be2-9998-777a40b252f8"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2024-05-14 19:17:26.069410+00:00', '2024-05-14 19:17:26.069410+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"=>"bfd9a8c2-57da-409a-bda8-51a4e56d72fd","slug"=>"arrival","node_id"=>"5e004d09-b101-443c-b29e-304a31762188","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              content_tag
              
              
                DELETE
                FROM content_tag
                WHERE
                    content_item_id = '582c8250-2c40-42c3-b866-7bc1dd361781'
                    AND tag_id IN ('e8bc34fc-b3aa-4987-a274-47e5685cfed1', '0dc17860-811c-4d7a-a7ca-6a937ab46979', 'ec46cc2f-bf4c-4b6d-ab21-0077f5b78f4a', 'aac52961-71f5-4f40-a6ec-4fa3666eea46', 'f0ade07d-a6c8-4623-99a2-36a2e0546f05', 'de537d15-025d-4182-a764-f7d4818b239c', '50f07d2d-3a1a-4bb7-ae4a-2a910b15261d')
                
              D
              "tag_id"=>"ec46cc2f-bf4c-4b6d-ab21-0077f5b78f4a","church_slug"=>"apollos_demo","content_item_id"=>"582c8250-2c40-42c3-b866-7bc1dd361781"

            
              content_tag
              
              
                    INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
                    VALUES ('ec46cc2f-bf4c-4b6d-ab21-0077f5b78f4a', '582c8250-2c40-42c3-b866-7bc1dd361781', NOW(), NOW())
                    
              I
              "tag_id"=>"ec46cc2f-bf4c-4b6d-ab21-0077f5b78f4a","church_slug"=>"apollos_demo","content_item_id"=>"582c8250-2c40-42c3-b866-7bc1dd361781"

            
              media
              "metadata"=>"{\"width\": 1280, \"height\": 720}"
              
                            UPDATE
                                media
                            SET
                                metadata = metadata || '{"width": 1280,"height": 720}'::jsonb
                            WHERE
                                id = '988486fe-02d2-4e7f-9c54-2bb635d6557d'::uuid
                                
              U
              "id"=>"988486fe-02d2-4e7f-9c54-2bb635d6557d","url"=>"https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png","type"=>"IMAGE","node_id"=>"a46655a9-f837-4636-a019-b79084856ddb","metadata"=>"{}","node_type"=>"Community","origin_id"=>"https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png","apollos_id"=>"ImageMedia:988486fe-02d2-4e7f-9c54-2bb635d6557d","church_slug"=>"apollos_demo","origin_type"=>"planning_center","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-14T19:17:58.208114+00:00'::timestamptz,'2024-05-14T19:17:58.208114+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"=>"01537ff9-71b9-4b9c-8943-fbc95052c9b3","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:01537ff9-71b9-4b9c-8943-fbc95052c9b3","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-14T19:17:58.208114+00:00'::timestamptz,'2024-05-14T19:17:58.208114+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"=>"beb5efeb-4d07-4310-a23a-68e1cb140ae5","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:beb5efeb-4d07-4310-a23a-68e1cb140ae5","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-14T19:17:58.208114+00:00'::timestamptz,'2024-05-14T19:17:58.208114+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"=>"8f67f90c-4194-4b3d-ac05-49139a635db0","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:8f67f90c-4194-4b3d-ac05-49139a635db0","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"=>"a1678d02-e5e2-44d5-a896-eddf316ec7ac","event_id"=>"76c6335b-a9b6-4051-9206-3c8263f4ae94","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"=>"c4df1073-6541-4cee-81b5-8d25dda4f16f","event_id"=>"9141cac3-7948-4cb5-9ff9-7529b2613aee","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"=>"c4df1073-6541-4cee-81b5-8d25dda4f16f","event_id"=>"d7015f31-7398-4a18-9f76-f98a03f51658","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"=>"3094a221-f36c-4bbc-b767-cb34cc6d6474","event_id"=>"76c6335b-a9b6-4051-9206-3c8263f4ae94","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"=>"3094a221-f36c-4bbc-b767-cb34cc6d6474","event_id"=>"9141cac3-7948-4cb5-9ff9-7529b2613aee","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"=>"3094a221-f36c-4bbc-b767-cb34cc6d6474","event_id"=>"d7015f31-7398-4a18-9f76-f98a03f51658","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"=>"3ab0c0b9-4ea4-4fff-9b0c-6e4abbf62b11","event_id"=>"9141cac3-7948-4cb5-9ff9-7529b2613aee","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"=>"dbfbac1e-ef60-4bf8-9497-4fe4ef769a72","event_id"=>"76c6335b-a9b6-4051-9206-3c8263f4ae94","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"=>"dbfbac1e-ef60-4bf8-9497-4fe4ef769a72","event_id"=>"d7015f31-7398-4a18-9f76-f98a03f51658","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"=>"c4df1073-6541-4cee-81b5-8d25dda4f16f","event_id"=>"d7015f31-7398-4a18-9f76-f98a03f51658","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"=>"dbfbac1e-ef60-4bf8-9497-4fe4ef769a72","event_id"=>"d7015f31-7398-4a18-9f76-f98a03f51658","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"=>"3094a221-f36c-4bbc-b767-cb34cc6d6474","event_id"=>"d7015f31-7398-4a18-9f76-f98a03f51658","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"=>"c4df1073-6541-4cee-81b5-8d25dda4f16f","event_id"=>"76c6335b-a9b6-4051-9206-3c8263f4ae94","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"=>"dbfbac1e-ef60-4bf8-9497-4fe4ef769a72","event_id"=>"76c6335b-a9b6-4051-9206-3c8263f4ae94","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"=>"a1678d02-e5e2-44d5-a896-eddf316ec7ac","event_id"=>"76c6335b-a9b6-4051-9206-3c8263f4ae94","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"=>"3094a221-f36c-4bbc-b767-cb34cc6d6474","event_id"=>"76c6335b-a9b6-4051-9206-3c8263f4ae94","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"=>"c4df1073-6541-4cee-81b5-8d25dda4f16f","event_id"=>"9141cac3-7948-4cb5-9ff9-7529b2613aee","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"=>"3094a221-f36c-4bbc-b767-cb34cc6d6474","event_id"=>"9141cac3-7948-4cb5-9ff9-7529b2613aee","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"=>"3ab0c0b9-4ea4-4fff-9b0c-6e4abbf62b11","event_id"=>"9141cac3-7948-4cb5-9ff9-7529b2613aee","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"=>"01537ff9-71b9-4b9c-8943-fbc95052c9b3","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:01537ff9-71b9-4b9c-8943-fbc95052c9b3","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 = '8f67f90c-4194-4b3d-ac05-49139a635db0'::uuid
                                
              U
              "id"=>"8f67f90c-4194-4b3d-ac05-49139a635db0","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:8f67f90c-4194-4b3d-ac05-49139a635db0","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 = 'beb5efeb-4d07-4310-a23a-68e1cb140ae5'::uuid
                                
              U
              "id"=>"beb5efeb-4d07-4310-a23a-68e1cb140ae5","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:beb5efeb-4d07-4310-a23a-68e1cb140ae5","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 ('2f92781c-0a43-452c-be05-9638e4bd571e')
                    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"=>"63baa37d-73df-4cef-9de4-54fd5554572d","church_slug"=>"apollos_demo","content_item_id"=>"2f92781c-0a43-452c-be05-9638e4bd571e"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('2f92781c-0a43-452c-be05-9638e4bd571e','2024-05-14T19:18:32.214980+00:00'::timestamptz,'63baa37d-73df-4cef-9de4-54fd5554572d','2024-05-14T19:18:32.214980+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"=>"63baa37d-73df-4cef-9de4-54fd5554572d","church_slug"=>"apollos_demo","content_item_id"=>"2f92781c-0a43-452c-be05-9638e4bd571e"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('1c5de710-b20e-443b-9857-813251ee0925','48cb7b38-81e2-4dca-a7d4-0b39547d3165','3c3c342c-d370-409a-b0ab-8bbb179e03ea','8cd68e83-8132-4b51-9d6d-31678204b99f','35bc82fc-f56b-42c2-a128-1fb862aafe48')
                    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"=>"fc4c9fb5-4c0a-456e-acbb-99e088c7b6d1","church_slug"=>"apollos_demo","content_item_id"=>"1c5de710-b20e-443b-9857-813251ee0925"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('1c5de710-b20e-443b-9857-813251ee0925','48cb7b38-81e2-4dca-a7d4-0b39547d3165','3c3c342c-d370-409a-b0ab-8bbb179e03ea','8cd68e83-8132-4b51-9d6d-31678204b99f','35bc82fc-f56b-42c2-a128-1fb862aafe48')
                    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"=>"fc4c9fb5-4c0a-456e-acbb-99e088c7b6d1","church_slug"=>"apollos_demo","content_item_id"=>"8cd68e83-8132-4b51-9d6d-31678204b99f"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('1c5de710-b20e-443b-9857-813251ee0925','48cb7b38-81e2-4dca-a7d4-0b39547d3165','3c3c342c-d370-409a-b0ab-8bbb179e03ea','8cd68e83-8132-4b51-9d6d-31678204b99f','35bc82fc-f56b-42c2-a128-1fb862aafe48')
                    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"=>"f5eafcea-2666-45ac-b321-c5a217f0a34a","church_slug"=>"apollos_demo","content_item_id"=>"1c5de710-b20e-443b-9857-813251ee0925"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('1c5de710-b20e-443b-9857-813251ee0925','48cb7b38-81e2-4dca-a7d4-0b39547d3165','3c3c342c-d370-409a-b0ab-8bbb179e03ea','8cd68e83-8132-4b51-9d6d-31678204b99f','35bc82fc-f56b-42c2-a128-1fb862aafe48')
                    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"=>"147896b4-f30d-4cc6-981f-b9e238e8b271","church_slug"=>"apollos_demo","content_item_id"=>"8cd68e83-8132-4b51-9d6d-31678204b99f"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('1c5de710-b20e-443b-9857-813251ee0925','2024-05-14T19:18:32.214980+00:00'::timestamptz,'fc4c9fb5-4c0a-456e-acbb-99e088c7b6d1','2024-05-14T19:18:32.214980+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"=>"fc4c9fb5-4c0a-456e-acbb-99e088c7b6d1","church_slug"=>"apollos_demo","content_item_id"=>"1c5de710-b20e-443b-9857-813251ee0925"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('1c5de710-b20e-443b-9857-813251ee0925','2024-05-14T19:18:32.214980+00:00'::timestamptz,'f5eafcea-2666-45ac-b321-c5a217f0a34a','2024-05-14T19:18:32.214980+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"=>"f5eafcea-2666-45ac-b321-c5a217f0a34a","church_slug"=>"apollos_demo","content_item_id"=>"1c5de710-b20e-443b-9857-813251ee0925"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('8cd68e83-8132-4b51-9d6d-31678204b99f','2024-05-14T19:18:32.214980+00:00'::timestamptz,'fc4c9fb5-4c0a-456e-acbb-99e088c7b6d1','2024-05-14T19:18:32.214980+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"=>"fc4c9fb5-4c0a-456e-acbb-99e088c7b6d1","church_slug"=>"apollos_demo","content_item_id"=>"8cd68e83-8132-4b51-9d6d-31678204b99f"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('8cd68e83-8132-4b51-9d6d-31678204b99f','2024-05-14T19:18:32.214980+00:00'::timestamptz,'147896b4-f30d-4cc6-981f-b9e238e8b271','2024-05-14T19:18:32.214980+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"=>"147896b4-f30d-4cc6-981f-b9e238e8b271","church_slug"=>"apollos_demo","content_item_id"=>"8cd68e83-8132-4b51-9d6d-31678204b99f"
	45c45
	< 74e0eb83-a7d1-40f8-969c-964d12b0c5cb Friends \N \N \N \N Campus 2 ministry_platform \N \N f \N apollos_demo campus
	---
	> 74e0eb83-a7d1-40f8-969c-964d12b0c5cb Friends \N \N \N \N Campus 2 ministry_platform \N \N f a2d2ee93-9ef5-462d-b217-6b2bb64afd4e apollos_demo campus
	48c48
	< 7f756f73-3e5c-478e-a2a4-86e80adb9914 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
	---
	> 7f756f73-3e5c-478e-a2a4-86e80adb9914 Campbell 2301 Jacksboro Pike Suite 3 \N LaFollette TN 37766 36.34487 -84.161683 \N \N Campus 5 ministry_platform \N \N f a2d2ee93-9ef5-462d-b217-6b2bb64afd4e apollos_demo campus
	55c55
	< fac6c5ce-e3a3-46f4-848d-7928ec81f77e UT \N \N \N \N Campus 4 ministry_platform \N \N f \N apollos_demo campus
	---
	> fac6c5ce-e3a3-46f4-848d-7928ec81f77e UT \N \N \N \N Campus 4 ministry_platform \N \N f a2d2ee93-9ef5-462d-b217-6b2bb64afd4e apollos_demo campus
	1450c1450
	< IMAGE https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png a46655a9-f837-4636-a019-b79084856ddb Community https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png planning_center 988486fe-02d2-4e7f-9c54-2bb635d6557d ImageMedia \N \N {} apollos_demo media
	---
	> IMAGE https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png a46655a9-f837-4636-a019-b79084856ddb Community https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png planning_center 988486fe-02d2-4e7f-9c54-2bb635d6557d ImageMedia \N \N {"width": 1280, "height": 720} apollos_demo media
	1867c1867
	< IMAGE https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb 5ab41342-d3f7-4dbf-82d9-daf62de8a0de Campus campusimage-71 rock a2d2ee93-9ef5-462d-b217-6b2bb64afd4e IMAGE \N \N {"width": 183, "height": 183} apollos_demo media
	---
	> IMAGE https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb 7f756f73-3e5c-478e-a2a4-86e80adb9914 Campus campusimage-71 rock a2d2ee93-9ef5-462d-b217-6b2bb64afd4e IMAGE \N \N {"width": 183, "height": 183} apollos_demo media