MattHealy

def merge(r):

    if '{{LESSOR}}' in r.text:
        r.text = r.text.replace('{{LESSOR}}', 'my name')
    if '{{LESSORADDRESS}}' in r.text:
        r.text = r.text.replace('{{LESSORADDRESS}}', 'my address')


from docx import Document

MattHealy

def convert(minutes):

    if isinstance(minutes, int):
        return str(minutes/24/60) + " day, " + \
               str(minutes/60 % 24) + " hours, " + \
               str(minutes % 60) + " minutes"
    else:
        return "0 days, 0 hours, 0 minutes"

MattHealy

Description: API Gateway to JSON payloads and send to SQS
Outputs:
  ApiEndpoint:
    Description: Endpoint for this stage of the api
    Value: !Join
      - ''
      - - https://
        - !Ref 'SQSProxy'
        - .execute-api.ap-southeast-2.amazonaws.com/
        - prod

MattHealy

" Display a red column 80 chars in .py files (to assist with line length)
" set colorcolumn=80
autocmd FileType python setlocal colorcolumn=80

" Return to last edit position when opening files
autocmd BufReadPost *
     \ if line("'\"") > 0 && line("'\"") <= line("$") |
     \   exe "normal! g`\"" |
     \ endif

MattHealy

#!/bin/bash
BRANCH=`git rev-parse --abbrev-ref HEAD`

if [[ "$BRANCH" == "master" ]]; then
    ./deploy.sh
fi

MattHealy

#!/usr/bin/env python3
import subprocess
import zipfile
import os

dirs = next(os.walk('.'))[1]

for d in dirs:

    print("Preparing {} ZIP archive".format(d))

MattHealy

import boto3
import argparse

parser = argparse.ArgumentParser()

parser.add_argument(
    '--repo', metavar='repo', type=str,
    help='Optionally filter by repository')

args = parser.parse_args()

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

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

#!/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 = '';