Skip to content

Instantly share code, notes, and snippets.

View vinnyjth's full-sized avatar
:shipit:
🛳️🚢🛳️🚢🚢🚢 🛳️

Vincent Wilson vinnyjth

:shipit:
🛳️🚢🛳️🚢🚢🚢 🛳️
22 followers · 15 following
  • Cincinnati
View GitHub Profile
@vinnyjth
vinnyjth / PUBKEY
Created August 3, 2020 16:59
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQDy0Hf2e+NgruyWAd9XCAHq2YuU4U1/NNuD8hzWPFr6j2k9oVHqVSMU06KQY145qiGY3CKZWDT2PYiPlDIUF1Lm/2lcVQpCOI15HpheoHkaQGIQ7Jm2ntGxz3XT4yXRDfgkV/0aiTPszCa2EiDxcLKcUVtfV4oJML4P3y1p8IbObEYCmjcbWCvEHWjEvPUg3G8nfNxNWpcKkW6gEr45nMBdPoVcEBRsWUIOtApBzleIgh22oQRaADqRZiLDR/0Uc1+VdYSxX42EFd7+ftDLD8VRS9afkr1IUYg190mqkfemcfxDJgqjh9SAIR9HHOyXLXeQY4aAER1rQ9y4Wj6Nvs/eszLLsOnD7eW0SHOw4mZRiDVYdwU3Z+eY8JIO91Kh5yA49wLusfXWHBFLr0iBL5c4jT4urbYxLDyw+Cgkxe4bpULxlOwcS8XeOZD5azrLg1TAd+zgcdc6f2h/uCet+q7V/McCUvEupOzpufainazGcBdFIRLBp+3zyfRu/6CMeUhUOcpt2+oV5VoSvUp71k0kmh8r7782JEz2KhbpcVecLBhMLCn7r0mCAVLml9VS9PxomINer+fqQgMYddC4qZcj64MvFuaylmc6t/4aWPKCxe4C89oi7noqSORh7JStdTl1my37Nq6JhoWghE5iWk3oXsNX4M9LqoFqT9GLFMZQow== vince@classyh.at
@vinnyjth
vinnyjth / diff.md
Last active August 24, 2023 02:35
table_name changed_fields client_query action row_data
media "metadata"=>"{"width": 3824, "height": 1514}" UPDATE 
                            media
                        SET
                            metadata = metadata || '{"width": 3824, "height": 1514}'::jsonb
                        WHERE
                            id = 'bd69009d-27a0-4867-b242-f9d87a1d9f7b'::uuid | U | "id"=>"bd69009d-27a0-4867-b242-f9d87a1d9f7b", "url"=>"https://rock.apollos.app/GetImage.ashx?guid=83f8498b-ce43-47ea-ae84-0f0efde22b57", "type"=>"IMAGE", "node_id"=>"b4a0a6b7-4b73-4c57-b51e-ad78e8f2043a", "metadata"=>"{}", "node_type"=>"ContentItem", "origin_id"=>"77/5491", "apollos_id"=>"ImageMedia:bd69009d-27a0-4867-b242-f9d87a1d9f7b", "church_slug"=>"apollos_demo", "origin_type"=>"rock", "apollos_type"=>"ImageMedia"

media | "metadata"=>"{"width": null, "height": null}" | UPDATE media

@vinnyjth
vinnyjth / diff-Thu Aug 24 2023 02:43:47 GMT+0000 (Coordinated Universal Time).csv
Created August 24, 2023 02:43
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
table_name,changed_fields,client_query,action,row_data
media,"""metadata""=>""{\""width\"": 3824, \""height\"": 1514}""","
UPDATE
media
SET
metadata = metadata || '{""width"": 3824, ""height"": 1514}'::jsonb
WHERE
id = '2b815416-1de6-4bd8-9368-a22b4a943b80'::uuid
",U,"""id""=>""2b815416-1de6-4bd8-9368-a22b4a943b80"", ""url""=>""https://rock.apollos.app/GetImage.ashx?guid=83f8498b-ce43-47ea-ae84-0f0efde22b57"", ""type""=>""IMAGE"", ""node_id""=>""9e85a2ee-119f-4424-9340-6575885931ff"", ""metadata""=>""{}"", ""node_type""=>""ContentItem"", ""origin_id""=>""77/5491"", ""apollos_id""=>""ImageMedia:2b815416-1de6-4bd8-9368-a22b4a943b80"", ""church_slug""=>""apollos_demo"", ""origin_type""=>""rock"", ""apollos_type""=>""ImageMedia"""
media,"""metadata""=>""{\""width\"": null, \""height\"": null}""","
@vinnyjth
vinnyjth / diff-e11c8c837a21171e49a8ed891cde93538e1f4841.csv
Created August 24, 2023 03:02
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
table_name,changed_fields,client_query,action,row_data
media,"""metadata""=>""{\""width\"": 3824, \""height\"": 1514}""","
UPDATE
media
SET
metadata = metadata || '{""width"": 3824, ""height"": 1514}'::jsonb
WHERE
id = '6bd8ebcd-d82b-44d1-9440-443c6cb54c02'::uuid
",U,"""id""=>""6bd8ebcd-d82b-44d1-9440-443c6cb54c02"", ""url""=>""https://rock.apollos.app/GetImage.ashx?guid=83f8498b-ce43-47ea-ae84-0f0efde22b57"", ""type""=>""IMAGE"", ""node_id""=>""9957a3d6-c891-4a50-ab29-5c2952e57954"", ""metadata""=>""{}"", ""node_type""=>""ContentItem"", ""origin_id""=>""77/5491"", ""apollos_id""=>""ImageMedia:6bd8ebcd-d82b-44d1-9440-443c6cb54c02"", ""church_slug""=>""apollos_demo"", ""origin_type""=>""rock"", ""apollos_type""=>""ImageMedia"""
media,"""metadata""=>""{\""width\"": null, \""height\"": null}""","
@vinnyjth
vinnyjth / changes-8b03c73daf87e71f8624cc2918df2e67453927cf.csv
Last active August 24, 2023 13:38
table_name changed_fields client_query action row_data
content_item "summary"=>"FART" INSERT INTO content_item (active, apollos_type, created_at, expire_at, html_content, origin_id, origin_type, priority, publish_at, summary, title, updated_at) VALUES (true,'UniversalContentItem','2023-08-24T13:33:47.072587+00:00'::timestamptz,NULL,'Week 1',80,'rock',0,'2023-08-15T00:00:00-04:00'::timestamptz,'FART','Week 1','2023-08-24T13:33:47.072587+00:00'::timestamptz) ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET active = excluded.active, apollos_type = excluded.apollos_type, created_at = excluded.created_at, expire_at = excluded.expire_at, html_content = excluded.html_content, priority = excluded.priority, publish_at = excluded.publish_at, summary = excluded.summary, title = excluded.title, updated_at = excluded.updated_at U "id"=>"e3512761-c567-418f-9290-2398998bd44e","title"=>"Week 1","active"=>"t","summary"=>"Week 1","priority"=>"0","expire_at"=>NULL,"origin_id
@vinnyjth
vinnyjth / changes-dbee743aad3f9b29d7ebe4dc56fe07663b48eb33.csv
Created August 24, 2023 13:42
table_name changed_fields client_query action row_data
content_item "summary"=>"FART" INSERT INTO content_item (active, apollos_type, created_at, expire_at, html_content, origin_id, origin_type, priority, publish_at, summary, title, updated_at) VALUES (true,'UniversalContentItem','2023-08-24T13:42:06.729923+00:00'::timestamptz,NULL,'Week 1',80,'rock',0,'2023-08-15T00:00:00-04:00'::timestamptz,'FART','Week 1','2023-08-24T13:42:06.729923+00:00'::timestamptz) ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET active = excluded.active, apollos_type = excluded.apollos_type, created_at = excluded.created_at, expire_at = excluded.expire_at, html_content = excluded.html_content, priority = excluded.priority, publish_at = excluded.publish_at, summary = excluded.summary, title = excluded.title, updated_at = excluded.updated_at U "id"=>"b4394c21-b40c-4317-a2bd-1b86e0beef8b","title"=>"Week 1","active"=>"t","summary"=>"Week 1","priority"=>"0","expire_at"=>NULL,"origin_id
@vinnyjth
vinnyjth / changes-9e9d77271905c85bafd46c211102d1ea8feebde5.csv
Created August 24, 2023 14:04
table_name changed_fields client_query action row_data
content_item "summary"=>"FART" INSERT INTO content_item (active, apollos_type, created_at, expire_at, html_content, origin_id, origin_type, priority, publish_at, summary, title, updated_at) VALUES (true,'UniversalContentItem','2023-08-24T14:03:31.843834+00:00'::timestamptz,NULL,'Week 1',80,'rock',0,'2023-08-15T00:00:00-04:00'::timestamptz,'FART','Week 1','2023-08-24T14:03:31.843834+00:00'::timestamptz) ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET active = excluded.active, apollos_type = excluded.apollos_type, created_at = excluded.created_at, expire_at = excluded.expire_at, html_content = excluded.html_content, priority = excluded.priority, publish_at = excluded.publish_at, summary = excluded.summary, title = excluded.title, updated_at = excluded.updated_at U "id"=>"4642264c-378f-45a0-8813-b48f5cbf6368","title"=>"Week 1","active"=>"t","summary"=>"Week 1","priority"=>"0","expire_at"=>NULL,"origin_id
@vinnyjth
vinnyjth / 1-summary.md
Created August 24, 2023 14:11

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.

@vinnyjth
vinnyjth / 1-summary.md
Created August 24, 2023 14:15

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.

@vinnyjth
vinnyjth / 1-summary.md
Created August 24, 2023 14:58

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.