skwashd

Import Data from JSON File to Aurora PostgreSQL

This script loads data from a PostreSQL JSON dump file into an Aurora PostgreSQL database using the RDS Data API.

Update the values in the COLUMN_TYPES dictionary to match your schema. Map your column data types to the supported field types. You can cast a string to a custom type by appending :type to the field type.

Run Script

To run the script you need boto3 installed. Then run the script like so:

skwashd

EventBridge Event Replay Module

Amazon EventBridge Archive ignores replayed events. The archive rule is a managed rule and so there is no way to remove this restriction. This limitation can be frustrating when standing up a new bus.

This Terraform module configures an AWS Step Functions Express workflow that handles replayed events from an EventBridge bus. Events with a replay-name property are sent directly to the workflow and reinjected into the same bus with the replay marker removed.

Flow

1. EventBridge rule captures events with replay-name property
2. Events are routed directly to a Step Function

skwashd

"""
Map lego entity IDs to BrickLink part numbers and colour code. Output them
as BrickLink XML. Copy and paste the output into your wish list.

This script only uses core Python, with no external dependencies.
"""
import http.client
import random
import re
import time

skwashd

const footerHeight = 800;

let pos = 0,
  pageHeight = document.body.offsetHeight,
  winHeight = window.innerHeight,
  maxPos = pageHeight - winHeight - footerHeight;

function scrollWin() {
  if (pos >= maxPos) {
    console.log(`We're done at ${pos}`);

skwashd

[user]
	name = Dave Hall
	email = skwashd@example.com
	signingkey = GPG-KEY-FINGERPRINT # follow these instructions to setup https://andrewmatveychuk.com/how-to-sign-you-commits-with-gpg-git-and-yubikey/

[core]
	editor = vim # no debate
	excludesfile = ~/.gitignore_global # Generated using https://www.gitignore.io/api/diff,patch,go,vim,macos,python,pycharm,webstorm,archives,phpstorm,drupal,node

[commit]

skwashd

#!/usr/bin/env python3

import base64
import os

import requests


token = os.environ.get("GITHUB_TOKEN")
org = os.environ.get("GITHUB_ORG")

skwashd

#!/usr/bin/env python3

import json
import os

import requests


token = os.environ.get("GITHUB_TOKEN")
org = os.environ.get("GITHUB_ORG")

skwashd

This Python (3.6+) script is for migrating Amazon AWS System Manager (SSM) Parameter Store keys from one path to another.

Quick Start

To install the script do the following:

• Configure your AWS credentials
• Grab the code from this gist
• Make it executable (chmod +x /path/to/copy-ssm-ps-path.py)
• pip install boto3 (if you don't have it installed already)

skwashd

This script removes all external collaborators in a GitHub organisation. Collaborators look like a good idea when you have a small organisation and you don't want to start managing a lot of teams. Once your organisation grows collaborators are a nightmare to manage. There is little or no context about why they have access, they're often missed when auditing user access and they get forgotten about.

Setup

• Run pip install requests to install the one and only dependency
• Configure the GITHUB_ORG and GITHUB_TOKEN environment variables

Running

Run the script like so python3 ./remove-collaborators.py. The output should look like this:

skwashd

Purge GitHub Invites

Large organisations invite new users to GitHub all the time. Some times the user never accepts the invite. GitHub invites never expire. Long after the user has been forgotten they can still accept the invite. This is a potential security issue.

Back in September 2015 I asked GitHub to expose invite information via their API. In December 2016 GitHub launched their new Organization Memberships APIs, which included an endpoint for pending invitations. The initial implementation lacked information of when the invite was sent. GitHub added this property after I asked for it.

I created a script that uses this new API that checks for any invites which have been pending more than a week. If they exist they're pruged. I hope someone else finds this usef