Skip to content

Instantly share code, notes, and snippets.

🍵
418 I'm a teapot

Tim Abell timabell

Block or report user

Report or block timabell

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@timabell
timabell / test-ucas-endpoint.py
Last active Mar 12, 2019
Quick script for test the provider/course api exposed by https://github.com/DFE-Digital/manage-courses-backend/
View test-ucas-endpoint.py
#!/usr/bin/env python
# iterate through providers
# usage, env vars to override defaults:
# token=authtoken urlbase="http://someserver/" endpoint="api/v1/2019/providers" startat="?changed_since=2019-03-11T15%3A47%3A57.548105Z&per_page=100" ./test-ucas-endpoint.py
# https://gist.github.com/timabell/16926c828ca33a178f0f0adc5dae4f76
# MIT License
View fix-seq.sql
ALTER SEQUENCE mc_organisation_id_seq RENAME TO organisation_id_seq;
ALTER TABLE organisation ALTER id SET DEFAULT nextval('organisation_id_seq'::regclass);
ALTER SEQUENCE mc_organisation_institution_id_seq RENAME TO organisation_provider_id_seq;
ALTER TABLE organisation_provider ALTER id SET DEFAULT nextval('organisation_provider_id_seq'::regclass);
ALTER SEQUENCE mc_organisation_user_id_seq RENAME TO organisation_user_id_seq;
ALTER TABLE organisation_user ALTER id SET DEFAULT nextval('organisation_user_id_seq'::regclass);
ALTER SEQUENCE "UcasInstitutions_Id_seq" RENAME TO provider_id_seq;
@timabell
timabell / make-fks.sql
Created Feb 10, 2019
magic up foreign keys for sql server based on naming heuristics
@timabell
timabell / peek-config.txt
Last active Jan 23, 2019
An idea for a default peek configuration for http://schemaexplorer.io/
View peek-config.txt
# http://schemaexplorer.io/
# This file configures which columns will be loaded from the other side of a foreign key.
# Place this file next the schema explorer executable and name it peek-config.txt
# Lines starting with # will be ignored along with blank lines.
# Each line is a golang regex https://golang.org/pkg/regexp/ that will be matched against schema.table.column, (table.column for sqlite)
# schema/table/column names are converted to lower-case before comparing with the below regexes
# Customise this file to suit your database (but make sure you keep your copy when upgrading schema explorer).
View cloudSettings
{"lastUpload":"2019-02-07T15:29:46.603Z","extensionVersion":"v3.2.4"}
View manage-courses-test-users.sql
-- https://gist.github.com/timabell/b501a4ef5c6fddebe629c15f002cc649
-- for the database generated by https://github.com/DFE-Digital/manage-courses-api
SELECT * FROM mc_user WHERE email like '%abell%';
SELECT * FROM mc_organisation_user WHERE email like '%abell%';
-- all the related tables
select u.email, ui.inst_full, *
from mc_user u, mc_organisation_user ou, mc_organisation_institution oi, ucas_institution ui
where
--ou.org_id = '5606'
@timabell
timabell / assoc.ps1
Last active Feb 11, 2019
set windows file associations
View assoc.ps1
# https://gist.github.com/timabell/bc90e0808ec1cda173ca09225a16e194
# MIT license
$exts=@(
"csv",
"csproj",
"json",
"log",
"md",
"patch",
"sql",
@timabell
timabell / fix-metro.sh
Created Apr 3, 2018
metro bank export to ynab import converter
View fix-metro.sh
#!/bin/bash
IFS='\n'
for x in *.csv; do
echo "$x"
cp "$x" "$x.orig"
sed -i '1c Date,Payee,Memo,Money In, Money Out,Balance' "$x"
# remove stupid date from start of tx description. fucking idiots.
sed -i 's/,[0-9][0-9] [A-Z][A-Z][A-Z] [0-9][0-9] /,/g' "$x"
done
@timabell
timabell / backup-vm.sh
Last active Apr 25, 2019
tar+lz4 backup with progress
View backup-vm.sh
#!/bin/bash -v
# backing up a vm
cd /media/tim/WD6/
base="/home/tim/VirtualBox VMs"
src=win10-2018
mv $src.tar.lz4 $src.tar.lz4.old
@timabell
timabell / LICENSE
Last active Feb 27, 2017
azure dev vm base
View LICENSE
The MIT License (MIT)
Copyright (c) 2015 Microsoft Azure
Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:
You can’t perform that action at this time.