MattHealy

import boto3
import csv
import calendar
from datetime import date, datetime, timedelta
from collections import OrderedDict

client = boto3.client('apigateway')


endDate = date(year=2023, month=3, day=31)

MattHealy

import boto3
import csv

client = boto3.client('route53domains', region_name='us-east-1')

fieldnames = [
    'Domain Name',
    'Domain Registrar',
    'Expiration Date',
    'Auto-Renewal',

MattHealy

import boto3
import csv


client = boto3.client('ec2')
regions = [region['RegionName'] for region in client.describe_regions()['Regions']]

fieldnames = [
    'Certificate',
    'Common Name',

MattHealy

import boto3
from datetime import date, timedelta

endDate = date.today()
startDate = endDate - timedelta(days=7)
tempDate = startDate

days = []
while tempDate <= endDate:
    days.append(tempDate)

MattHealy

#!/bin/bash
ADDRESS=`aws ec2 describe-instances --filters 'Name=tag:Name,Values=WebServer' --output text --query 'Reservations[*].Instances[*].PrivateIpAddress'`
ssh ec2-user@$ADDRESS

MattHealy

<?php

// HMAC-SHA512 signing

function get_signature($event, $orderid, $listing_id) {

    // Hashing algorithm to use
    $algo = 'sha512';

    // Shared key used for signing payloads

MattHealy

vpn() {
    # Usage: "vpn uk" to connect to UK VPN
    # Usage: "vpn" to connect to AU VPN
    REGION="${1:-au}"
    sudo killall openvpn
    if [ $REGION == "uk" ]; then
        sudo openvpn --daemon --config ~/ovpn/vaultre-uk-matthealy.ovpn
    else
        sudo openvpn --daemon --config ~/ovpn/vaultre-matthealy.ovpn
    fi

MattHealy

#!/usr/bin/perl

use File::Slurp;  # not strictly needed, but nice to have
use Data::Dumper;
use JSON;
use LWP::UserAgent;
use HTTP::Request::Common;

my $key = '';
my $token = '';

MattHealy

watch -n 60 "curl -s \
    --url 'https://www.amazon.com.au/Thermos-THERMOcafe-Vacuum-Insulated-BOL750R6AUS/dp/B07DHGBNM9' \
    --compressed | grep 'priceblock_ourprice' | grep 'priceBlockBuyingPriceString' >> /tmp/amazon.log"

MattHealy

To kill stuck processes

select group_concat(concat('KILL ',id,';') separator ' ')
from information_schema.processlist
where Time>'100' and Info like 'select %';

To kill sleeping processes and allow alter table to occur

select group_concat(concat('KILL ',id,';') separator ' ')
from information_schema.processlist