|
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-17T01:10:05.819789+00:00'::timestamptz,'2024-05-17T01:10:05.819789+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"=>"c51e3d97-1359-4820-b28c-b80471b14e7a","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:c51e3d97-1359-4820-b28c-b80471b14e7a","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-17T01:10:05.819789+00:00'::timestamptz,'2024-05-17T01:10:05.819789+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"=>"56d21215-03fc-4d16-8fe4-a99a943a4ca6","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:56d21215-03fc-4d16-8fe4-a99a943a4ca6","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-17T01:10:05.819789+00:00'::timestamptz,'2024-05-17T01:10:05.819789+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"=>"8157443a-08f9-4f71-a76c-d11273854bff","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:8157443a-08f9-4f71-a76c-d11273854bff","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"=>"a456b1e1-9482-48fe-bb45-48802b47c383","event_id"=>"ac805a7a-2190-41f2-adeb-445b324f2106","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"=>"fdd5ee90-2dd4-49dc-96fa-07c17c3e667c","event_id"=>"5d9b3676-3dbc-46c3-9bb8-2d1e0547802e","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"=>"fdd5ee90-2dd4-49dc-96fa-07c17c3e667c","event_id"=>"ac805a7a-2190-41f2-adeb-445b324f2106","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"=>"fdd5ee90-2dd4-49dc-96fa-07c17c3e667c","event_id"=>"e0f04cac-573e-4e3d-9635-96907b2b5ace","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"=>"6a9d42e5-97a8-4c6e-ae60-582abba407e0","event_id"=>"5d9b3676-3dbc-46c3-9bb8-2d1e0547802e","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"=>"6a9d42e5-97a8-4c6e-ae60-582abba407e0","event_id"=>"ac805a7a-2190-41f2-adeb-445b324f2106","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"=>"6a9d42e5-97a8-4c6e-ae60-582abba407e0","event_id"=>"e0f04cac-573e-4e3d-9635-96907b2b5ace","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"=>"aadc1671-1c1d-4289-bbd3-957a809ff1ad","event_id"=>"e0f04cac-573e-4e3d-9635-96907b2b5ace","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"=>"8d160202-f726-498b-8030-50ce03217160","event_id"=>"5d9b3676-3dbc-46c3-9bb8-2d1e0547802e","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"=>"8d160202-f726-498b-8030-50ce03217160","event_id"=>"ac805a7a-2190-41f2-adeb-445b324f2106","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"=>"fdd5ee90-2dd4-49dc-96fa-07c17c3e667c","event_id"=>"5d9b3676-3dbc-46c3-9bb8-2d1e0547802e","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"=>"8d160202-f726-498b-8030-50ce03217160","event_id"=>"5d9b3676-3dbc-46c3-9bb8-2d1e0547802e","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"=>"6a9d42e5-97a8-4c6e-ae60-582abba407e0","event_id"=>"5d9b3676-3dbc-46c3-9bb8-2d1e0547802e","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"=>"fdd5ee90-2dd4-49dc-96fa-07c17c3e667c","event_id"=>"ac805a7a-2190-41f2-adeb-445b324f2106","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"=>"8d160202-f726-498b-8030-50ce03217160","event_id"=>"ac805a7a-2190-41f2-adeb-445b324f2106","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"=>"a456b1e1-9482-48fe-bb45-48802b47c383","event_id"=>"ac805a7a-2190-41f2-adeb-445b324f2106","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"=>"6a9d42e5-97a8-4c6e-ae60-582abba407e0","event_id"=>"ac805a7a-2190-41f2-adeb-445b324f2106","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"=>"fdd5ee90-2dd4-49dc-96fa-07c17c3e667c","event_id"=>"e0f04cac-573e-4e3d-9635-96907b2b5ace","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"=>"6a9d42e5-97a8-4c6e-ae60-582abba407e0","event_id"=>"e0f04cac-573e-4e3d-9635-96907b2b5ace","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"=>"aadc1671-1c1d-4289-bbd3-957a809ff1ad","event_id"=>"e0f04cac-573e-4e3d-9635-96907b2b5ace","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"=>"c51e3d97-1359-4820-b28c-b80471b14e7a","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:c51e3d97-1359-4820-b28c-b80471b14e7a","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 = '8157443a-08f9-4f71-a76c-d11273854bff'::uuid
|
U |
"id"=>"8157443a-08f9-4f71-a76c-d11273854bff","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:8157443a-08f9-4f71-a76c-d11273854bff","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 = '56d21215-03fc-4d16-8fe4-a99a943a4ca6'::uuid
|
U |
"id"=>"56d21215-03fc-4d16-8fe4-a99a943a4ca6","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:56d21215-03fc-4d16-8fe4-a99a943a4ca6","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 ('feec1da0-ddaa-417d-8472-108bcebf9c28')
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"=>"4eed491b-5b75-4e35-8fd3-4e93e4d10345","church_slug"=>"apollos_demo","content_item_id"=>"feec1da0-ddaa-417d-8472-108bcebf9c28" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('feec1da0-ddaa-417d-8472-108bcebf9c28','2024-05-17T01:10:39.478239+00:00'::timestamptz,'4eed491b-5b75-4e35-8fd3-4e93e4d10345','2024-05-17T01:10:39.478239+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"=>"4eed491b-5b75-4e35-8fd3-4e93e4d10345","church_slug"=>"apollos_demo","content_item_id"=>"feec1da0-ddaa-417d-8472-108bcebf9c28" |
|
content_tag |
|
DELETE from content_tag
USING tag
WHERE content_tag.content_item_id in ('4c233be8-fc80-411c-8033-f8dd01d083a9','d34f4945-e6a7-42a2-9ff2-1fa1609ef44b','50e1ffce-7a57-496d-9eb7-7641cb840447','f307a9bb-c3dd-4f52-a87e-0727258cb8ad','ba8993d9-89ed-4c51-8c61-05423570bb20')
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"=>"f3291724-7910-4f8f-be20-ee1cee229482","church_slug"=>"apollos_demo","content_item_id"=>"4c233be8-fc80-411c-8033-f8dd01d083a9" |
|
content_tag |
|
DELETE from content_tag
USING tag
WHERE content_tag.content_item_id in ('4c233be8-fc80-411c-8033-f8dd01d083a9','d34f4945-e6a7-42a2-9ff2-1fa1609ef44b','50e1ffce-7a57-496d-9eb7-7641cb840447','f307a9bb-c3dd-4f52-a87e-0727258cb8ad','ba8993d9-89ed-4c51-8c61-05423570bb20')
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"=>"f3291724-7910-4f8f-be20-ee1cee229482","church_slug"=>"apollos_demo","content_item_id"=>"f307a9bb-c3dd-4f52-a87e-0727258cb8ad" |
|
content_tag |
|
DELETE from content_tag
USING tag
WHERE content_tag.content_item_id in ('4c233be8-fc80-411c-8033-f8dd01d083a9','d34f4945-e6a7-42a2-9ff2-1fa1609ef44b','50e1ffce-7a57-496d-9eb7-7641cb840447','f307a9bb-c3dd-4f52-a87e-0727258cb8ad','ba8993d9-89ed-4c51-8c61-05423570bb20')
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"=>"3e944746-7edb-4b13-970e-dbd704bb4a76","church_slug"=>"apollos_demo","content_item_id"=>"4c233be8-fc80-411c-8033-f8dd01d083a9" |
|
content_tag |
|
DELETE from content_tag
USING tag
WHERE content_tag.content_item_id in ('4c233be8-fc80-411c-8033-f8dd01d083a9','d34f4945-e6a7-42a2-9ff2-1fa1609ef44b','50e1ffce-7a57-496d-9eb7-7641cb840447','f307a9bb-c3dd-4f52-a87e-0727258cb8ad','ba8993d9-89ed-4c51-8c61-05423570bb20')
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"=>"ce070ffd-b775-43f1-9d93-9dde21bf6bc2","church_slug"=>"apollos_demo","content_item_id"=>"f307a9bb-c3dd-4f52-a87e-0727258cb8ad" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('4c233be8-fc80-411c-8033-f8dd01d083a9','2024-05-17T01:10:39.478239+00:00'::timestamptz,'f3291724-7910-4f8f-be20-ee1cee229482','2024-05-17T01:10:39.478239+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"=>"f3291724-7910-4f8f-be20-ee1cee229482","church_slug"=>"apollos_demo","content_item_id"=>"4c233be8-fc80-411c-8033-f8dd01d083a9" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('4c233be8-fc80-411c-8033-f8dd01d083a9','2024-05-17T01:10:39.478239+00:00'::timestamptz,'3e944746-7edb-4b13-970e-dbd704bb4a76','2024-05-17T01:10:39.478239+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"=>"3e944746-7edb-4b13-970e-dbd704bb4a76","church_slug"=>"apollos_demo","content_item_id"=>"4c233be8-fc80-411c-8033-f8dd01d083a9" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('f307a9bb-c3dd-4f52-a87e-0727258cb8ad','2024-05-17T01:10:39.478239+00:00'::timestamptz,'f3291724-7910-4f8f-be20-ee1cee229482','2024-05-17T01:10:39.478239+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"=>"f3291724-7910-4f8f-be20-ee1cee229482","church_slug"=>"apollos_demo","content_item_id"=>"f307a9bb-c3dd-4f52-a87e-0727258cb8ad" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('f307a9bb-c3dd-4f52-a87e-0727258cb8ad','2024-05-17T01:10:39.478239+00:00'::timestamptz,'ce070ffd-b775-43f1-9d93-9dde21bf6bc2','2024-05-17T01:10:39.478239+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"=>"ce070ffd-b775-43f1-9d93-9dde21bf6bc2","church_slug"=>"apollos_demo","content_item_id"=>"f307a9bb-c3dd-4f52-a87e-0727258cb8ad" |
|
campus |
"image_id"=>"61f3b79d-96c1-4dd0-8bec-31918d9db629" |
UPDATE campus
SET image_id = media.id
FROM media
WHERE campus.id = '259a7062-2eb2-4d0b-bcb5-977061657d91' AND media.origin_id = 'campusimage-71'
|
U |
"id"=>"259a7062-2eb2-4d0b-bcb5-977061657d91","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:259a7062-2eb2-4d0b-bcb5-977061657d91","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"37766","apollos_type"=>"Campus" |
|
node_slug |
"node_id"=>"a49eea3a-9531-4b3c-b710-2fea42de5d54" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"3d53ee04-c8f4-4e86-af3f-799a45b3d1bb","slug"=>"giving","node_id"=>"9a9c3917-afbd-466f-bf59-83da18f31db9","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"9a9c3917-afbd-466f-bf59-83da18f31db9" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"3d53ee04-c8f4-4e86-af3f-799a45b3d1bb","slug"=>"giving","node_id"=>"a49eea3a-9531-4b3c-b710-2fea42de5d54","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"5e37895d-557f-458c-8963-3132b56686d8" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"10b820aa-5ca2-421d-8850-66e812717c9e","slug"=>"at-the-movies","node_id"=>"89ba313c-210f-4983-87b0-9313c7d7df04","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"5537594b-2186-4476-a62f-5cbef06071ba" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"334eb64a-3b83-4199-9705-d1b626b452c1","slug"=>"1x8","node_id"=>"ee510597-f440-4d4e-8e2a-626b483ca1f9","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"e9ab7a6e-946c-49d3-9fd7-7a75231bafc0" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"d7024788-b4ab-4b16-bec7-20b8e1257584","slug"=>"potential","node_id"=>"41cdbd6a-5054-44da-8c93-92f0b4c1107e","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"1c97f31e-5135-4039-8a76-37fc26e0fc6f" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"2069ed9d-a22b-4239-9bb2-8f14f1b0579c","slug"=>"arrival","node_id"=>"affc09c9-87c7-4489-91a4-bc714a739998","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"89ba313c-210f-4983-87b0-9313c7d7df04" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"10b820aa-5ca2-421d-8850-66e812717c9e","slug"=>"at-the-movies","node_id"=>"5e37895d-557f-458c-8963-3132b56686d8","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"ee510597-f440-4d4e-8e2a-626b483ca1f9" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"334eb64a-3b83-4199-9705-d1b626b452c1","slug"=>"1x8","node_id"=>"5537594b-2186-4476-a62f-5cbef06071ba","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"41cdbd6a-5054-44da-8c93-92f0b4c1107e" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"d7024788-b4ab-4b16-bec7-20b8e1257584","slug"=>"potential","node_id"=>"e9ab7a6e-946c-49d3-9fd7-7a75231bafc0","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"affc09c9-87c7-4489-91a4-bc714a739998" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-05-17 01:09:19.565355+00:00', '2024-05-17 01:09:19.565355+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"=>"2069ed9d-a22b-4239-9bb2-8f14f1b0579c","slug"=>"arrival","node_id"=>"1c97f31e-5135-4039-8a76-37fc26e0fc6f","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
content_tag |
|
DELETE
FROM content_tag
WHERE
content_item_id = '1b7c7fb2-9129-47d2-88db-2edbf29e820d'
AND tag_id IN ('32ed3d7a-c848-4002-95ca-2ddf69e5645f', '21cc0413-190e-40b4-8fc5-01fc7524e5b5', '3facf3ec-4400-4da0-82bd-73b6b6dab616', '73ea0144-5a5e-4851-a60c-214f5b922fdf', '78de12be-c9ad-470c-912c-ec27642cb725', '6fbd4820-04c9-4cda-8b5c-25f807165835', '66c5ab86-8156-4807-b061-b814e5f638d9')
|
D |
"tag_id"=>"21cc0413-190e-40b4-8fc5-01fc7524e5b5","church_slug"=>"apollos_demo","content_item_id"=>"1b7c7fb2-9129-47d2-88db-2edbf29e820d" |
|
content_tag |
|
INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
VALUES ('21cc0413-190e-40b4-8fc5-01fc7524e5b5', '1b7c7fb2-9129-47d2-88db-2edbf29e820d', NOW(), NOW())
|
I |
"tag_id"=>"21cc0413-190e-40b4-8fc5-01fc7524e5b5","church_slug"=>"apollos_demo","content_item_id"=>"1b7c7fb2-9129-47d2-88db-2edbf29e820d" |
|
media |
"metadata"=>"{\"width\": 1280, \"height\": 720}" |
UPDATE
media
SET
metadata = metadata || '{"width": 1280,"height": 720}'::jsonb
WHERE
id = 'd84a2f8c-c7d2-497f-9734-883dec79ecfc'::uuid
|
U |
"id"=>"d84a2f8c-c7d2-497f-9734-883dec79ecfc","url"=>"https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png","type"=>"IMAGE","node_id"=>"70d084f3-2ef8-4dd8-8167-3ef519e8a877","metadata"=>"{}","node_type"=>"Community","origin_id"=>"https://groups-production.s3.amazonaws.com/uploads/group/header_image/defaults/3.png","apollos_id"=>"ImageMedia:d84a2f8c-c7d2-497f-9734-883dec79ecfc","church_slug"=>"apollos_demo","origin_type"=>"planning_center","apollos_type"=>"ImageMedia" |
|
media |
"node_id"=>"4cb6c38f-36fb-4b30-9a6d-5087a5a4b46b" |
INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-17T01:08:58.046421+00:00'::timestamptz,'2024-05-17T01:08:58.046421+00:00'::timestamptz,'4cb6c38f-36fb-4b30-9a6d-5087a5a4b46b','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"=>"61f3b79d-96c1-4dd0-8bec-31918d9db629","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"a32e00de-abb8-4922-9d7c-08672b18d791","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:61f3b79d-96c1-4dd0-8bec-31918d9db629","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE" |
|
media |
"node_id"=>"a1130cd9-aae2-49f3-abe2-2412f8d94241" |
INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-17T01:08:58.046421+00:00'::timestamptz,'2024-05-17T01:08:58.046421+00:00'::timestamptz,'a1130cd9-aae2-49f3-abe2-2412f8d94241','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"=>"61f3b79d-96c1-4dd0-8bec-31918d9db629","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"4cb6c38f-36fb-4b30-9a6d-5087a5a4b46b","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:61f3b79d-96c1-4dd0-8bec-31918d9db629","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE" |
|
media |
"node_id"=>"d153ceaf-5f27-4741-ae0f-47f05eb45b23" |
INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-17T01:08:58.046421+00:00'::timestamptz,'2024-05-17T01:08:58.046421+00:00'::timestamptz,'d153ceaf-5f27-4741-ae0f-47f05eb45b23','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"=>"61f3b79d-96c1-4dd0-8bec-31918d9db629","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"a1130cd9-aae2-49f3-abe2-2412f8d94241","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:61f3b79d-96c1-4dd0-8bec-31918d9db629","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE" |
|
media |
"node_id"=>"259a7062-2eb2-4d0b-bcb5-977061657d91" |
INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-05-17T01:08:58.046421+00:00'::timestamptz,'2024-05-17T01:08:58.046421+00:00'::timestamptz,'259a7062-2eb2-4d0b-bcb5-977061657d91','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"=>"61f3b79d-96c1-4dd0-8bec-31918d9db629","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"d153ceaf-5f27-4741-ae0f-47f05eb45b23","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:61f3b79d-96c1-4dd0-8bec-31918d9db629","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE" |
|
campus |
"image_id"=>"61f3b79d-96c1-4dd0-8bec-31918d9db629" |
UPDATE campus
SET image_id = media.id
FROM media
WHERE campus.id = 'a1130cd9-aae2-49f3-abe2-2412f8d94241' AND media.origin_id = 'campusimage-71'
|
U |
"id"=>"a1130cd9-aae2-49f3-abe2-2412f8d94241","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:a1130cd9-aae2-49f3-abe2-2412f8d94241","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus" |
|
campus |
"image_id"=>"61f3b79d-96c1-4dd0-8bec-31918d9db629" |
UPDATE campus
SET image_id = media.id
FROM media
WHERE campus.id = 'd153ceaf-5f27-4741-ae0f-47f05eb45b23' AND media.origin_id = 'campusimage-71'
|
U |
"id"=>"d153ceaf-5f27-4741-ae0f-47f05eb45b23","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:d153ceaf-5f27-4741-ae0f-47f05eb45b23","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus" |