Skip to content

Instantly share code, notes, and snippets.

@vinnyjth
Created June 11, 2024 18:26
Show Gist options
  • Save vinnyjth/338690f4f7b110f81fb2a2dee6fb52a6 to your computer and use it in GitHub Desktop.
Save vinnyjth/338690f4f7b110f81fb2a2dee6fb52a6 to your computer and use it in GitHub Desktop.

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.

30c30
< 1fffa650-41e2-4775-8b6e-e330deed77d2 UT \N \N \N \N Campus 4 ministry_platform \N \N f \N apollos_demo campus
---
> 1fffa650-41e2-4775-8b6e-e330deed77d2 UT \N \N \N \N Campus 4 ministry_platform \N \N f e9841236-d50e-4a18-9cfa-c2b1f6b2a96a apollos_demo campus
39c39
< 6e3a74bb-292b-40fb-b0de-9f41e2ff53b1 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
---
> 6e3a74bb-292b-40fb-b0de-9f41e2ff53b1 Campbell 2301 Jacksboro Pike Suite 3 \N LaFollette TN 37766 36.34487 -84.161683 \N \N Campus 5 ministry_platform \N \N f e9841236-d50e-4a18-9cfa-c2b1f6b2a96a apollos_demo campus
46c46
< acef156b-ad06-4104-b5ff-ecbdecd980ac Friends \N \N \N \N Campus 2 ministry_platform \N \N f \N apollos_demo campus
---
> acef156b-ad06-4104-b5ff-ecbdecd980ac Friends \N \N \N \N Campus 2 ministry_platform \N \N f e9841236-d50e-4a18-9cfa-c2b1f6b2a96a apollos_demo campus
1452c1452
< IMAGE https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png 5f112eea-38a1-44f2-93be-2824aee44214 Community https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png planning_center bce0d7bd-b3f4-4946-9114-b861f0e4fc94 ImageMedia \N \N {} apollos_demo media
---
> IMAGE https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png 5f112eea-38a1-44f2-93be-2824aee44214 Community https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png planning_center bce0d7bd-b3f4-4946-9114-b861f0e4fc94 ImageMedia \N \N {"width": 1280, "height": 720} apollos_demo media
1876c1876
< IMAGE https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb f8d73518-bda6-49ba-9ef4-dc9805c3a376 Campus campusimage-71 rock e9841236-d50e-4a18-9cfa-c2b1f6b2a96a IMAGE \N \N {"width": 183, "height": 183} apollos_demo media
---
> IMAGE https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb 6e3a74bb-292b-40fb-b0de-9f41e2ff53b1 Campus campusimage-71 rock e9841236-d50e-4a18-9cfa-c2b1f6b2a96a IMAGE \N \N {"width": 183, "height": 183} apollos_demo media
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-06-11T18:23:06.351880+00:00'::timestamptz,'2024-06-11T18:23:06.351880+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"=>"d4bc51f0-6edb-4830-9a6b-f17a4df474e6","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:d4bc51f0-6edb-4830-9a6b-f17a4df474e6","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-06-11T18:23:06.351880+00:00'::timestamptz,'2024-06-11T18:23:06.351880+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"=>"267a4ac8-7f24-4e11-b17f-88497717e370","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:267a4ac8-7f24-4e11-b17f-88497717e370","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-06-11T18:23:06.351880+00:00'::timestamptz,'2024-06-11T18:23:06.351880+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"=>"fd74a715-584a-45e4-a219-127dd1318e7f","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:fd74a715-584a-45e4-a219-127dd1318e7f","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"=>"ae8f65a0-aa69-420c-85eb-a9e2edd0437b","event_id"=>"bc2fe78b-444b-49fe-9ff5-4fd5ef925b86","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"=>"4a8190e6-44d6-483e-9064-1d8be4ab5e86","event_id"=>"c87654ab-4406-41e9-a8a3-1719d65fc587","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"=>"4a8190e6-44d6-483e-9064-1d8be4ab5e86","event_id"=>"bc2fe78b-444b-49fe-9ff5-4fd5ef925b86","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"=>"4a8190e6-44d6-483e-9064-1d8be4ab5e86","event_id"=>"59196603-959c-4e89-8786-3639c2bb6afb","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"=>"4bff48f2-a220-4335-b14e-85babb590bba","event_id"=>"c87654ab-4406-41e9-a8a3-1719d65fc587","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"=>"4bff48f2-a220-4335-b14e-85babb590bba","event_id"=>"bc2fe78b-444b-49fe-9ff5-4fd5ef925b86","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"=>"4bff48f2-a220-4335-b14e-85babb590bba","event_id"=>"59196603-959c-4e89-8786-3639c2bb6afb","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"=>"e5fc4598-4535-4c30-9db7-e2e1b70a2e22","event_id"=>"59196603-959c-4e89-8786-3639c2bb6afb","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"=>"8d56b5da-1c18-418c-af26-f731aac2b979","event_id"=>"c87654ab-4406-41e9-a8a3-1719d65fc587","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"=>"8d56b5da-1c18-418c-af26-f731aac2b979","event_id"=>"bc2fe78b-444b-49fe-9ff5-4fd5ef925b86","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"=>"4a8190e6-44d6-483e-9064-1d8be4ab5e86","event_id"=>"c87654ab-4406-41e9-a8a3-1719d65fc587","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"=>"8d56b5da-1c18-418c-af26-f731aac2b979","event_id"=>"c87654ab-4406-41e9-a8a3-1719d65fc587","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"=>"4bff48f2-a220-4335-b14e-85babb590bba","event_id"=>"c87654ab-4406-41e9-a8a3-1719d65fc587","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"=>"4a8190e6-44d6-483e-9064-1d8be4ab5e86","event_id"=>"bc2fe78b-444b-49fe-9ff5-4fd5ef925b86","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"=>"8d56b5da-1c18-418c-af26-f731aac2b979","event_id"=>"bc2fe78b-444b-49fe-9ff5-4fd5ef925b86","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"=>"ae8f65a0-aa69-420c-85eb-a9e2edd0437b","event_id"=>"bc2fe78b-444b-49fe-9ff5-4fd5ef925b86","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"=>"4bff48f2-a220-4335-b14e-85babb590bba","event_id"=>"bc2fe78b-444b-49fe-9ff5-4fd5ef925b86","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"=>"4a8190e6-44d6-483e-9064-1d8be4ab5e86","event_id"=>"59196603-959c-4e89-8786-3639c2bb6afb","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"=>"4bff48f2-a220-4335-b14e-85babb590bba","event_id"=>"59196603-959c-4e89-8786-3639c2bb6afb","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"=>"e5fc4598-4535-4c30-9db7-e2e1b70a2e22","event_id"=>"59196603-959c-4e89-8786-3639c2bb6afb","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"=>"d4bc51f0-6edb-4830-9a6b-f17a4df474e6","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:d4bc51f0-6edb-4830-9a6b-f17a4df474e6","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 = 'fd74a715-584a-45e4-a219-127dd1318e7f'::uuid U "id"=>"fd74a715-584a-45e4-a219-127dd1318e7f","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:fd74a715-584a-45e4-a219-127dd1318e7f","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 = '267a4ac8-7f24-4e11-b17f-88497717e370'::uuid U "id"=>"267a4ac8-7f24-4e11-b17f-88497717e370","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:267a4ac8-7f24-4e11-b17f-88497717e370","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 ('062cd349-8985-45d6-ad38-778b1e693732') 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"=>"427cf513-16a8-4d35-a8b0-ec4bb859ff04","church_slug"=>"apollos_demo","content_item_id"=>"062cd349-8985-45d6-ad38-778b1e693732"
content_tag INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('062cd349-8985-45d6-ad38-778b1e693732','2024-06-11T18:23:39.381553+00:00'::timestamptz,'427cf513-16a8-4d35-a8b0-ec4bb859ff04','2024-06-11T18:23:39.381553+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"=>"427cf513-16a8-4d35-a8b0-ec4bb859ff04","church_slug"=>"apollos_demo","content_item_id"=>"062cd349-8985-45d6-ad38-778b1e693732"
content_tag DELETE from content_tag USING tag WHERE content_tag.content_item_id in ('5b9b6e74-9177-4850-81fb-68ba86c3c9de','d692edba-35ad-4102-b134-114f1aa40f85','c280bef8-7a34-400f-afc5-d864f7d7ee46','3f41d46d-e878-4469-963b-a4633c3033e3','f12f1f5e-0072-46cd-95a1-e0cc231b31c5') 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"=>"32034f45-8743-48a8-9e56-e33306300ef8","church_slug"=>"apollos_demo","content_item_id"=>"3f41d46d-e878-4469-963b-a4633c3033e3"
content_tag DELETE from content_tag USING tag WHERE content_tag.content_item_id in ('5b9b6e74-9177-4850-81fb-68ba86c3c9de','d692edba-35ad-4102-b134-114f1aa40f85','c280bef8-7a34-400f-afc5-d864f7d7ee46','3f41d46d-e878-4469-963b-a4633c3033e3','f12f1f5e-0072-46cd-95a1-e0cc231b31c5') 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"=>"32034f45-8743-48a8-9e56-e33306300ef8","church_slug"=>"apollos_demo","content_item_id"=>"5b9b6e74-9177-4850-81fb-68ba86c3c9de"
content_tag DELETE from content_tag USING tag WHERE content_tag.content_item_id in ('5b9b6e74-9177-4850-81fb-68ba86c3c9de','d692edba-35ad-4102-b134-114f1aa40f85','c280bef8-7a34-400f-afc5-d864f7d7ee46','3f41d46d-e878-4469-963b-a4633c3033e3','f12f1f5e-0072-46cd-95a1-e0cc231b31c5') 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"=>"00090ef9-13a7-45bf-9d66-7402b26a9663","church_slug"=>"apollos_demo","content_item_id"=>"5b9b6e74-9177-4850-81fb-68ba86c3c9de"
content_tag DELETE from content_tag USING tag WHERE content_tag.content_item_id in ('5b9b6e74-9177-4850-81fb-68ba86c3c9de','d692edba-35ad-4102-b134-114f1aa40f85','c280bef8-7a34-400f-afc5-d864f7d7ee46','3f41d46d-e878-4469-963b-a4633c3033e3','f12f1f5e-0072-46cd-95a1-e0cc231b31c5') 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"=>"881ad187-7eff-4b06-95a8-dc13c531f5e7","church_slug"=>"apollos_demo","content_item_id"=>"3f41d46d-e878-4469-963b-a4633c3033e3"
content_tag INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('5b9b6e74-9177-4850-81fb-68ba86c3c9de','2024-06-11T18:23:39.381553+00:00'::timestamptz,'32034f45-8743-48a8-9e56-e33306300ef8','2024-06-11T18:23:39.381553+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"=>"32034f45-8743-48a8-9e56-e33306300ef8","church_slug"=>"apollos_demo","content_item_id"=>"5b9b6e74-9177-4850-81fb-68ba86c3c9de"
content_tag INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('5b9b6e74-9177-4850-81fb-68ba86c3c9de','2024-06-11T18:23:39.381553+00:00'::timestamptz,'00090ef9-13a7-45bf-9d66-7402b26a9663','2024-06-11T18:23:39.381553+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"=>"00090ef9-13a7-45bf-9d66-7402b26a9663","church_slug"=>"apollos_demo","content_item_id"=>"5b9b6e74-9177-4850-81fb-68ba86c3c9de"
content_tag INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('3f41d46d-e878-4469-963b-a4633c3033e3','2024-06-11T18:23:39.381553+00:00'::timestamptz,'32034f45-8743-48a8-9e56-e33306300ef8','2024-06-11T18:23:39.381553+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"=>"32034f45-8743-48a8-9e56-e33306300ef8","church_slug"=>"apollos_demo","content_item_id"=>"3f41d46d-e878-4469-963b-a4633c3033e3"
content_tag INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('3f41d46d-e878-4469-963b-a4633c3033e3','2024-06-11T18:23:39.381553+00:00'::timestamptz,'881ad187-7eff-4b06-95a8-dc13c531f5e7','2024-06-11T18:23:39.381553+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"=>"881ad187-7eff-4b06-95a8-dc13c531f5e7","church_slug"=>"apollos_demo","content_item_id"=>"3f41d46d-e878-4469-963b-a4633c3033e3"
node_slug "node_id"=>"7e093b6b-178e-4371-b159-911da4446be2" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"4084030d-ea59-4b96-8e93-0602e7f83555","slug"=>"1x8","node_id"=>"9a764468-8aa2-4fb7-bb51-091e2528b843","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
node_slug "node_id"=>"c4ce9dab-a7cd-46bf-9028-83c441f2f76d" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"42019161-e94a-48ee-b3ea-7e33cf81e7cb","slug"=>"potential","node_id"=>"fc727555-4a05-44be-9d18-d0398d59b40f","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
node_slug "node_id"=>"02d77172-e1ef-486f-a03d-ce859ad2c683" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"c36f1ca4-41cd-4e61-bfee-f9d5e4ca4d9f","slug"=>"arrival","node_id"=>"6b04821e-3d30-4e52-9746-31804c279fa5","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
node_slug "node_id"=>"cec6fe8b-428c-4d65-9ed1-f95b2df3d9d2" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"aa0f2b98-ddbe-443c-bfb3-755e5bc2b90b","slug"=>"at-the-movies","node_id"=>"1d85eb2d-bbcb-426d-979c-fca6cf9b32a7","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
node_slug "node_id"=>"9a764468-8aa2-4fb7-bb51-091e2528b843" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"4084030d-ea59-4b96-8e93-0602e7f83555","slug"=>"1x8","node_id"=>"7e093b6b-178e-4371-b159-911da4446be2","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
node_slug "node_id"=>"fc727555-4a05-44be-9d18-d0398d59b40f" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"42019161-e94a-48ee-b3ea-7e33cf81e7cb","slug"=>"potential","node_id"=>"c4ce9dab-a7cd-46bf-9028-83c441f2f76d","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
node_slug "node_id"=>"6b04821e-3d30-4e52-9746-31804c279fa5" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"c36f1ca4-41cd-4e61-bfee-f9d5e4ca4d9f","slug"=>"arrival","node_id"=>"02d77172-e1ef-486f-a03d-ce859ad2c683","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
content_tag DELETE FROM content_tag WHERE content_item_id = '3757a855-4956-4994-a8bb-a2cb6abc0f4c' AND tag_id IN ('63f72f6e-12ff-404d-808e-7a622b4507ed', 'ec350dca-db60-4072-8f58-b9c705fe4a3a', 'ce883b88-9b52-4326-b61e-a7f6ad9ae68f', 'b0d18427-5457-4e4a-b6e8-22d513ff4d76', '7b6b34ce-9d5d-4190-b31c-b06a59ef837b', '56a34d7c-48d7-4bc7-9f79-75a5f18d8b81', '9db0003b-39b0-4197-a023-733f9dffbc25') D "tag_id"=>"ec350dca-db60-4072-8f58-b9c705fe4a3a","church_slug"=>"apollos_demo","content_item_id"=>"3757a855-4956-4994-a8bb-a2cb6abc0f4c"
content_tag INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at) VALUES ('ec350dca-db60-4072-8f58-b9c705fe4a3a', '3757a855-4956-4994-a8bb-a2cb6abc0f4c', NOW(), NOW()) I "tag_id"=>"ec350dca-db60-4072-8f58-b9c705fe4a3a","church_slug"=>"apollos_demo","content_item_id"=>"3757a855-4956-4994-a8bb-a2cb6abc0f4c"
content_tag DELETE FROM content_tag WHERE content_item_id = '79378d37-f882-4f0d-9b9b-3567d14b9afb' AND tag_id IN ('63f72f6e-12ff-404d-808e-7a622b4507ed', 'ec350dca-db60-4072-8f58-b9c705fe4a3a', 'ce883b88-9b52-4326-b61e-a7f6ad9ae68f', 'b0d18427-5457-4e4a-b6e8-22d513ff4d76', '7b6b34ce-9d5d-4190-b31c-b06a59ef837b', '56a34d7c-48d7-4bc7-9f79-75a5f18d8b81', '9db0003b-39b0-4197-a023-733f9dffbc25') D "tag_id"=>"ec350dca-db60-4072-8f58-b9c705fe4a3a","church_slug"=>"apollos_demo","content_item_id"=>"79378d37-f882-4f0d-9b9b-3567d14b9afb"
content_tag INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at) VALUES ('ec350dca-db60-4072-8f58-b9c705fe4a3a', '79378d37-f882-4f0d-9b9b-3567d14b9afb', NOW(), NOW()) I "tag_id"=>"ec350dca-db60-4072-8f58-b9c705fe4a3a","church_slug"=>"apollos_demo","content_item_id"=>"79378d37-f882-4f0d-9b9b-3567d14b9afb"
media "metadata"=>"{\"width\": 1280, \"height\": 720}" UPDATE media SET metadata = metadata || '{"width": 1280,"height": 720}'::jsonb WHERE id = 'bce0d7bd-b3f4-4946-9114-b861f0e4fc94'::uuid U "id"=>"bce0d7bd-b3f4-4946-9114-b861f0e4fc94","url"=>"https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png","type"=>"IMAGE","node_id"=>"5f112eea-38a1-44f2-93be-2824aee44214","metadata"=>"{}","node_type"=>"Community","origin_id"=>"https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png","apollos_id"=>"ImageMedia:bce0d7bd-b3f4-4946-9114-b861f0e4fc94","church_slug"=>"apollos_demo","origin_type"=>"planning_center","apollos_type"=>"ImageMedia"
media "node_id"=>"6e3a74bb-292b-40fb-b0de-9f41e2ff53b1" INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-06-11T18:22:00.668337+00:00'::timestamptz,'2024-06-11T18:22:00.668337+00:00'::timestamptz,'6e3a74bb-292b-40fb-b0de-9f41e2ff53b1','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"=>"e9841236-d50e-4a18-9cfa-c2b1f6b2a96a","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"1fffa650-41e2-4775-8b6e-e330deed77d2","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:e9841236-d50e-4a18-9cfa-c2b1f6b2a96a","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"
campus "image_id"=>"e9841236-d50e-4a18-9cfa-c2b1f6b2a96a" UPDATE campus SET image_id = media.id FROM media WHERE campus.id = 'acef156b-ad06-4104-b5ff-ecbdecd980ac' AND media.origin_id = 'campusimage-71' U "id"=>"acef156b-ad06-4104-b5ff-ecbdecd980ac","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:acef156b-ad06-4104-b5ff-ecbdecd980ac","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"
campus "image_id"=>"e9841236-d50e-4a18-9cfa-c2b1f6b2a96a" UPDATE campus SET image_id = media.id FROM media WHERE campus.id = '1fffa650-41e2-4775-8b6e-e330deed77d2' AND media.origin_id = 'campusimage-71' U "id"=>"1fffa650-41e2-4775-8b6e-e330deed77d2","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:1fffa650-41e2-4775-8b6e-e330deed77d2","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"
campus "image_id"=>"e9841236-d50e-4a18-9cfa-c2b1f6b2a96a" UPDATE campus SET image_id = media.id FROM media WHERE campus.id = '6e3a74bb-292b-40fb-b0de-9f41e2ff53b1' AND media.origin_id = 'campusimage-71' U "id"=>"6e3a74bb-292b-40fb-b0de-9f41e2ff53b1","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:6e3a74bb-292b-40fb-b0de-9f41e2ff53b1","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"37766","apollos_type"=>"Campus"
node_slug "node_id"=>"b761557f-58c5-4d6c-a3f7-2c95e8df7e65" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"49f03bbc-ef56-4321-9363-0a97051a3710","slug"=>"giving","node_id"=>"82fcd40f-9c82-4689-bb68-e47c2d5e1132","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
node_slug "node_id"=>"82fcd40f-9c82-4689-bb68-e47c2d5e1132" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"49f03bbc-ef56-4321-9363-0a97051a3710","slug"=>"giving","node_id"=>"b761557f-58c5-4d6c-a3f7-2c95e8df7e65","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
node_slug "node_id"=>"1d85eb2d-bbcb-426d-979c-fca6cf9b32a7" INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id) SELECT '2024-06-11 18:22:21.348125+00:00', '2024-06-11 18:22:21.348125+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"=>"aa0f2b98-ddbe-443c-bfb3-755e5bc2b90b","slug"=>"at-the-movies","node_id"=>"cec6fe8b-428c-4d65-9ed1-f95b2df3d9d2","node_type"=>"ContentItem","church_slug"=>"apollos_demo"
media "node_id"=>"e141ce61-c2e2-4b20-b8b2-0de948ba13cf" INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-06-11T18:22:00.668337+00:00'::timestamptz,'2024-06-11T18:22:00.668337+00:00'::timestamptz,'e141ce61-c2e2-4b20-b8b2-0de948ba13cf','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"=>"e9841236-d50e-4a18-9cfa-c2b1f6b2a96a","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"f8d73518-bda6-49ba-9ef4-dc9805c3a376","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:e9841236-d50e-4a18-9cfa-c2b1f6b2a96a","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"
media "node_id"=>"acef156b-ad06-4104-b5ff-ecbdecd980ac" INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-06-11T18:22:00.668337+00:00'::timestamptz,'2024-06-11T18:22:00.668337+00:00'::timestamptz,'acef156b-ad06-4104-b5ff-ecbdecd980ac','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"=>"e9841236-d50e-4a18-9cfa-c2b1f6b2a96a","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"e141ce61-c2e2-4b20-b8b2-0de948ba13cf","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:e9841236-d50e-4a18-9cfa-c2b1f6b2a96a","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"
media "node_id"=>"1fffa650-41e2-4775-8b6e-e330deed77d2" INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-06-11T18:22:00.668337+00:00'::timestamptz,'2024-06-11T18:22:00.668337+00:00'::timestamptz,'1fffa650-41e2-4775-8b6e-e330deed77d2','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"=>"e9841236-d50e-4a18-9cfa-c2b1f6b2a96a","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"acef156b-ad06-4104-b5ff-ecbdecd980ac","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:e9841236-d50e-4a18-9cfa-c2b1f6b2a96a","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment