Dave Hall skwashd

This is the Step Function definition used in my Summarising Support Tickets with Amazon Nova Lite post.

Replace the following tokens in the file:

{{ACCOUNT_ID}} - the ID of your AWS account
{{REGION}} - the region you are running the Step Function in

This state machine workflow depends on the PicoFun Zendesk example project to generate the Lambda functions for the Zendesk API endpoints.

Flow

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:

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

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

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)

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:

	"""
	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

	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}`);

	[user]
	name = Dave Hall
	email = [email protected]
	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]

	#!/usr/bin/env python3

	import base64
	import os

	import requests


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

	#!/usr/bin/env python3

	import json
	import os

	import requests


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