Dave Hall skwashd

Update Python Dependencies with GitHub Copilot CLI

Dependabot is great, but it is tedious when you have a multiple pyproject.toml files to update. Multiple updates often mean dealing with merge conflicts.

This script solves that. It uses GitHub Copilot CLI to process all dependencies and update them.

Setup

Create a directory to store the files in (ie ~/prompts/ghcli)
Copy the 2 files below into the new directory
Make the shell script executable - chmod +x ~/prompts/ghcli/bump-deps.sh

Random Name Picker

At the AWS Canberra User Group meeting on 23 July 2025, our panel discussed Responsible AI.

After the panel I used vibe code mode in Kiro to create a script for picking random attendees to win AWS vouchers. I wanted to show off Kiro in a fun way.

The prompt I used was deliberately short. Here it is:

Create a Python script to pick people at random from a CSV file. The names are contained in the first column of the file. Draw one name, then prompt if another name is needed. Ensure a name can only be drawn once. Do not use external libraries.

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

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

	#!/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")