|
node_slug |
"node_id"=>"a49c40b0-0101-44e6-9114-63ece0865ff6" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"816ed685-f45e-4f63-b012-21dfa0a833b3","slug"=>"giving","node_id"=>"404beeab-5a43-46e7-a618-179167562074","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"404beeab-5a43-46e7-a618-179167562074" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"816ed685-f45e-4f63-b012-21dfa0a833b3","slug"=>"giving","node_id"=>"a49c40b0-0101-44e6-9114-63ece0865ff6","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"9dfca62c-472f-4758-8ab2-712aae9aad85" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"35cb7884-15e9-488b-ab1c-c29c9b89b9c5","slug"=>"at-the-movies","node_id"=>"db0486b7-434f-42d1-b644-f6133ddc39dd","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"5c15f22c-5695-4b7e-ae1a-9336565cc9da" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"e5e8629f-6f11-46cd-a25e-8f1e524ec162","slug"=>"1x8","node_id"=>"89aab395-87f9-45ba-b94b-a0f83f3a07c2","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"b453a93e-e738-4faf-ba86-d238e10e3115" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"b0fe26f9-0f80-4151-951d-9eb883741dce","slug"=>"potential","node_id"=>"abd18fe2-5a5e-4b9f-b789-3c67abef1ac6","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"f74de4a1-1acb-4135-8379-ac6c6750cd68" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"50ccd21c-3c7c-4f3d-9f20-b77461a201df","slug"=>"arrival","node_id"=>"e8123fc7-8812-4465-9eb6-7a537e0c5b17","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"db0486b7-434f-42d1-b644-f6133ddc39dd" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"35cb7884-15e9-488b-ab1c-c29c9b89b9c5","slug"=>"at-the-movies","node_id"=>"9dfca62c-472f-4758-8ab2-712aae9aad85","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"89aab395-87f9-45ba-b94b-a0f83f3a07c2" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"e5e8629f-6f11-46cd-a25e-8f1e524ec162","slug"=>"1x8","node_id"=>"5c15f22c-5695-4b7e-ae1a-9336565cc9da","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"abd18fe2-5a5e-4b9f-b789-3c67abef1ac6" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"b0fe26f9-0f80-4151-951d-9eb883741dce","slug"=>"potential","node_id"=>"b453a93e-e738-4faf-ba86-d238e10e3115","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
node_slug |
"node_id"=>"e8123fc7-8812-4465-9eb6-7a537e0c5b17" |
INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
SELECT '2024-07-27 01:55:56.840915+00:00', '2024-07-27 01:55:56.840915+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"=>"50ccd21c-3c7c-4f3d-9f20-b77461a201df","slug"=>"arrival","node_id"=>"f74de4a1-1acb-4135-8379-ac6c6750cd68","node_type"=>"ContentItem","church_slug"=>"apollos_demo" |
|
content_tag |
|
DELETE
FROM content_tag
WHERE
content_item_id = 'ec4d8651-0361-4487-8561-0777dce6e595'
AND tag_id IN ('decf2739-b61a-45fe-a331-4fc01d257332', '4c2628d8-393f-4255-8614-86980f393208', 'bf97287d-186b-4255-99e7-ac9b39642a9e', 'ef0b0246-cadc-45ed-ad48-1ef2cc301335', '403468d8-da3a-4715-8938-0ca03efc9fe0', '423d0292-ad8f-4ce3-90ac-e755224e9c49', '7938e843-52b2-403c-982c-6ad1f696a3f0')
|
D |
"tag_id"=>"decf2739-b61a-45fe-a331-4fc01d257332","church_slug"=>"apollos_demo","content_item_id"=>"ec4d8651-0361-4487-8561-0777dce6e595" |
|
content_tag |
|
INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
VALUES ('decf2739-b61a-45fe-a331-4fc01d257332', 'ec4d8651-0361-4487-8561-0777dce6e595', NOW(), NOW())
|
I |
"tag_id"=>"decf2739-b61a-45fe-a331-4fc01d257332","church_slug"=>"apollos_demo","content_item_id"=>"ec4d8651-0361-4487-8561-0777dce6e595" |
|
content_tag |
|
DELETE
FROM content_tag
WHERE
content_item_id = '9f5dbc47-8ac7-43d7-84cb-9c1116171e38'
AND tag_id IN ('decf2739-b61a-45fe-a331-4fc01d257332', '4c2628d8-393f-4255-8614-86980f393208', 'bf97287d-186b-4255-99e7-ac9b39642a9e', 'ef0b0246-cadc-45ed-ad48-1ef2cc301335', '403468d8-da3a-4715-8938-0ca03efc9fe0', '423d0292-ad8f-4ce3-90ac-e755224e9c49', '7938e843-52b2-403c-982c-6ad1f696a3f0')
|
D |
"tag_id"=>"decf2739-b61a-45fe-a331-4fc01d257332","church_slug"=>"apollos_demo","content_item_id"=>"9f5dbc47-8ac7-43d7-84cb-9c1116171e38" |
|
content_tag |
|
INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
VALUES ('decf2739-b61a-45fe-a331-4fc01d257332', '9f5dbc47-8ac7-43d7-84cb-9c1116171e38', NOW(), NOW())
|
I |
"tag_id"=>"decf2739-b61a-45fe-a331-4fc01d257332","church_slug"=>"apollos_demo","content_item_id"=>"9f5dbc47-8ac7-43d7-84cb-9c1116171e38" |
|
content_tag |
|
DELETE FROM content_tag ct
USING content_item c, tag t
WHERE t.type = 'Persona'
AND t.id = ct.tag_id
AND c.id = ct.content_item_id;
|
D |
"tag_id"=>"03fbb16d-20cd-4088-baf7-4b87b4a9af7f","church_slug"=>"apollos_demo","content_item_id"=>"80e2dd68-87a5-4f44-9520-4c245eb8b0ac" |
|
content_tag |
|
INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
SELECT t.id,
i.id,
NOW(),
NOW()
FROM tag t,
content_item i
WHERE t.data ->> 'guid' = '2509783b-f0d4-4492-a4bc-747cfcc9b1f8'
AND i.origin_id = '73'
ON CONFLICT (tag_id, content_item_id) DO NOTHING
|
I |
"tag_id"=>"03fbb16d-20cd-4088-baf7-4b87b4a9af7f","church_slug"=>"apollos_demo","content_item_id"=>"80e2dd68-87a5-4f44-9520-4c245eb8b0ac" |
|
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-07-27T01:56:49.826287+00:00'::timestamptz,'2024-07-27T01:56:49.826287+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"=>"bdf3b26d-d1a7-4c6b-9b5b-1e6032287ba0","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:bdf3b26d-d1a7-4c6b-9b5b-1e6032287ba0","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-07-27T01:56:49.826287+00:00'::timestamptz,'2024-07-27T01:56:49.826287+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"=>"200b7322-9977-4c64-98c5-feb9a33daaf9","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:200b7322-9977-4c64-98c5-feb9a33daaf9","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-07-27T01:56:49.826287+00:00'::timestamptz,'2024-07-27T01:56:49.826287+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"=>"e04b6fd0-6aac-479c-9e0e-bba02005d3d1","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:e04b6fd0-6aac-479c-9e0e-bba02005d3d1","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"=>"935b371f-0252-412c-93eb-bd06efc98652","event_id"=>"04a07b08-0fad-4e29-9a5d-bb72bc3d1889","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"=>"6ddfcb36-13ad-47f3-b0c8-0987e65e70b1","event_id"=>"04a07b08-0fad-4e29-9a5d-bb72bc3d1889","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"=>"c55530a3-33c6-4251-84fb-67c335a789a6","event_id"=>"04a07b08-0fad-4e29-9a5d-bb72bc3d1889","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"=>"935b371f-0252-412c-93eb-bd06efc98652","event_id"=>"85b1c36d-29a5-4ed0-82a5-0d7b3740f132","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"=>"6ddfcb36-13ad-47f3-b0c8-0987e65e70b1","event_id"=>"85b1c36d-29a5-4ed0-82a5-0d7b3740f132","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"=>"1ecaa292-fef0-4ca6-9b71-2f289f35969c","event_id"=>"85b1c36d-29a5-4ed0-82a5-0d7b3740f132","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"=>"c55530a3-33c6-4251-84fb-67c335a789a6","event_id"=>"85b1c36d-29a5-4ed0-82a5-0d7b3740f132","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"=>"935b371f-0252-412c-93eb-bd06efc98652","event_id"=>"e2c50452-8fb7-4bb9-8a00-40427a48b4c7","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"=>"c55530a3-33c6-4251-84fb-67c335a789a6","event_id"=>"e2c50452-8fb7-4bb9-8a00-40427a48b4c7","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"=>"6ddae538-7e63-4764-b7ef-1bff96cab7ee","event_id"=>"e2c50452-8fb7-4bb9-8a00-40427a48b4c7","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"=>"935b371f-0252-412c-93eb-bd06efc98652","event_id"=>"04a07b08-0fad-4e29-9a5d-bb72bc3d1889","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"=>"6ddfcb36-13ad-47f3-b0c8-0987e65e70b1","event_id"=>"04a07b08-0fad-4e29-9a5d-bb72bc3d1889","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"=>"c55530a3-33c6-4251-84fb-67c335a789a6","event_id"=>"04a07b08-0fad-4e29-9a5d-bb72bc3d1889","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"=>"935b371f-0252-412c-93eb-bd06efc98652","event_id"=>"85b1c36d-29a5-4ed0-82a5-0d7b3740f132","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"=>"6ddfcb36-13ad-47f3-b0c8-0987e65e70b1","event_id"=>"85b1c36d-29a5-4ed0-82a5-0d7b3740f132","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"=>"1ecaa292-fef0-4ca6-9b71-2f289f35969c","event_id"=>"85b1c36d-29a5-4ed0-82a5-0d7b3740f132","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"=>"c55530a3-33c6-4251-84fb-67c335a789a6","event_id"=>"85b1c36d-29a5-4ed0-82a5-0d7b3740f132","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"=>"935b371f-0252-412c-93eb-bd06efc98652","event_id"=>"e2c50452-8fb7-4bb9-8a00-40427a48b4c7","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"=>"c55530a3-33c6-4251-84fb-67c335a789a6","event_id"=>"e2c50452-8fb7-4bb9-8a00-40427a48b4c7","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"=>"6ddae538-7e63-4764-b7ef-1bff96cab7ee","event_id"=>"e2c50452-8fb7-4bb9-8a00-40427a48b4c7","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"=>"bdf3b26d-d1a7-4c6b-9b5b-1e6032287ba0","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:bdf3b26d-d1a7-4c6b-9b5b-1e6032287ba0","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 = 'e04b6fd0-6aac-479c-9e0e-bba02005d3d1'::uuid
|
U |
"id"=>"e04b6fd0-6aac-479c-9e0e-bba02005d3d1","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:e04b6fd0-6aac-479c-9e0e-bba02005d3d1","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 = '200b7322-9977-4c64-98c5-feb9a33daaf9'::uuid
|
U |
"id"=>"200b7322-9977-4c64-98c5-feb9a33daaf9","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:200b7322-9977-4c64-98c5-feb9a33daaf9","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 ('b4935e9b-8394-4b7c-822e-797ecc2fbaa8')
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"=>"a9539f1c-6e51-4bc9-908e-332b65c787b7","church_slug"=>"apollos_demo","content_item_id"=>"b4935e9b-8394-4b7c-822e-797ecc2fbaa8" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('b4935e9b-8394-4b7c-822e-797ecc2fbaa8','2024-07-27T01:57:24.420954+00:00'::timestamptz,'a9539f1c-6e51-4bc9-908e-332b65c787b7','2024-07-27T01:57:24.420954+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"=>"a9539f1c-6e51-4bc9-908e-332b65c787b7","church_slug"=>"apollos_demo","content_item_id"=>"b4935e9b-8394-4b7c-822e-797ecc2fbaa8" |
|
content_tag |
|
DELETE from content_tag
USING tag
WHERE content_tag.content_item_id in ('f4c2f65d-6482-45ce-bd09-2a6698f75c4e','bf0a129d-2638-4861-a4f4-d2d5e48fefb9','73bf89e5-be39-43e3-818e-63978f593617','0e3ef47e-4469-41a5-bc1c-d48b60280c33','c1b39831-5e68-4d1b-93ca-bac308149f18')
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"=>"26bec7e3-0c04-4898-ace2-d06dce60e558","church_slug"=>"apollos_demo","content_item_id"=>"0e3ef47e-4469-41a5-bc1c-d48b60280c33" |
|
content_tag |
|
DELETE from content_tag
USING tag
WHERE content_tag.content_item_id in ('f4c2f65d-6482-45ce-bd09-2a6698f75c4e','bf0a129d-2638-4861-a4f4-d2d5e48fefb9','73bf89e5-be39-43e3-818e-63978f593617','0e3ef47e-4469-41a5-bc1c-d48b60280c33','c1b39831-5e68-4d1b-93ca-bac308149f18')
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"=>"26bec7e3-0c04-4898-ace2-d06dce60e558","church_slug"=>"apollos_demo","content_item_id"=>"f4c2f65d-6482-45ce-bd09-2a6698f75c4e" |
|
content_tag |
|
DELETE from content_tag
USING tag
WHERE content_tag.content_item_id in ('f4c2f65d-6482-45ce-bd09-2a6698f75c4e','bf0a129d-2638-4861-a4f4-d2d5e48fefb9','73bf89e5-be39-43e3-818e-63978f593617','0e3ef47e-4469-41a5-bc1c-d48b60280c33','c1b39831-5e68-4d1b-93ca-bac308149f18')
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"=>"47690ce4-5bd8-417e-aa17-19a95354c9b8","church_slug"=>"apollos_demo","content_item_id"=>"f4c2f65d-6482-45ce-bd09-2a6698f75c4e" |
|
content_tag |
|
DELETE from content_tag
USING tag
WHERE content_tag.content_item_id in ('f4c2f65d-6482-45ce-bd09-2a6698f75c4e','bf0a129d-2638-4861-a4f4-d2d5e48fefb9','73bf89e5-be39-43e3-818e-63978f593617','0e3ef47e-4469-41a5-bc1c-d48b60280c33','c1b39831-5e68-4d1b-93ca-bac308149f18')
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"=>"2597b675-afe7-43e1-bf3e-00fab135002d","church_slug"=>"apollos_demo","content_item_id"=>"0e3ef47e-4469-41a5-bc1c-d48b60280c33" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('f4c2f65d-6482-45ce-bd09-2a6698f75c4e','2024-07-27T01:57:24.420954+00:00'::timestamptz,'26bec7e3-0c04-4898-ace2-d06dce60e558','2024-07-27T01:57:24.420954+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"=>"26bec7e3-0c04-4898-ace2-d06dce60e558","church_slug"=>"apollos_demo","content_item_id"=>"f4c2f65d-6482-45ce-bd09-2a6698f75c4e" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('f4c2f65d-6482-45ce-bd09-2a6698f75c4e','2024-07-27T01:57:24.420954+00:00'::timestamptz,'47690ce4-5bd8-417e-aa17-19a95354c9b8','2024-07-27T01:57:24.420954+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"=>"47690ce4-5bd8-417e-aa17-19a95354c9b8","church_slug"=>"apollos_demo","content_item_id"=>"f4c2f65d-6482-45ce-bd09-2a6698f75c4e" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('0e3ef47e-4469-41a5-bc1c-d48b60280c33','2024-07-27T01:57:24.420954+00:00'::timestamptz,'26bec7e3-0c04-4898-ace2-d06dce60e558','2024-07-27T01:57:24.420954+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"=>"26bec7e3-0c04-4898-ace2-d06dce60e558","church_slug"=>"apollos_demo","content_item_id"=>"0e3ef47e-4469-41a5-bc1c-d48b60280c33" |
|
content_tag |
|
INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('0e3ef47e-4469-41a5-bc1c-d48b60280c33','2024-07-27T01:57:24.420954+00:00'::timestamptz,'2597b675-afe7-43e1-bf3e-00fab135002d','2024-07-27T01:57:24.420954+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"=>"2597b675-afe7-43e1-bf3e-00fab135002d","church_slug"=>"apollos_demo","content_item_id"=>"0e3ef47e-4469-41a5-bc1c-d48b60280c33" |
|
media |
"node_id"=>"4f9eed7e-98a8-42e3-b21d-e61baade0a53" |
INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-07-27T01:55:34.404957+00:00'::timestamptz,'2024-07-27T01:55:34.404957+00:00'::timestamptz,'4f9eed7e-98a8-42e3-b21d-e61baade0a53','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"=>"1c275c84-cc83-4cc5-94ee-b918f15166df","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"378e36e7-5781-44d5-bebf-b7ffc05a8e7e","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:1c275c84-cc83-4cc5-94ee-b918f15166df","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE" |
|
media |
"node_id"=>"c85915c7-2d3e-4be3-a372-52b6459f26e5" |
INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-07-27T01:55:34.404957+00:00'::timestamptz,'2024-07-27T01:55:34.404957+00:00'::timestamptz,'c85915c7-2d3e-4be3-a372-52b6459f26e5','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"=>"1c275c84-cc83-4cc5-94ee-b918f15166df","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"4f9eed7e-98a8-42e3-b21d-e61baade0a53","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:1c275c84-cc83-4cc5-94ee-b918f15166df","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE" |
|
media |
"node_id"=>"045d43e6-1ba2-452a-85d6-0a55a0b791bd" |
INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-07-27T01:55:34.404957+00:00'::timestamptz,'2024-07-27T01:55:34.404957+00:00'::timestamptz,'045d43e6-1ba2-452a-85d6-0a55a0b791bd','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"=>"1c275c84-cc83-4cc5-94ee-b918f15166df","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"c85915c7-2d3e-4be3-a372-52b6459f26e5","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:1c275c84-cc83-4cc5-94ee-b918f15166df","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE" |
|
media |
"node_id"=>"378e36e7-5781-44d5-bebf-b7ffc05a8e7e" |
INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2024-07-27T01:55:34.404957+00:00'::timestamptz,'2024-07-27T01:55:34.404957+00:00'::timestamptz,'378e36e7-5781-44d5-bebf-b7ffc05a8e7e','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"=>"1c275c84-cc83-4cc5-94ee-b918f15166df","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"045d43e6-1ba2-452a-85d6-0a55a0b791bd","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:1c275c84-cc83-4cc5-94ee-b918f15166df","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE" |