Skip to content

Instantly share code, notes, and snippets.

🍵
418 I'm a teapot

Tim Abell timabell

🍵
418 I'm a teapot
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
View heresy.c
//
// Compile with:
// gcc -std=c99 heresy.c
//
// Run with:
// ./a.out
//
// It outputs:
// 0
//
View docker-compose.yml
# multi-repo setup for DfE BAT Find
# https://github.com/webreactor/docker-project
version: "3.2"
volumes:
dbdata:
services:
scdb:
image: postgres:9.6-alpine
# To preserve data between runs of docker-compose, we mount a folder from the host machine.
volumes:
View provider-merge.rb
old_provider = Provider.find_by(provider_code: '1QQ')
new_provider = Provider.find_by(provider_code: '28Y')
old_provider.sites.each { |site| site.provider = new_provider; site.save }
old_provider.courses.each { |course| course.provider = new_provider; course.save }
old_provider.organisations = []
old_provider.enrichments.each { |enrichment| enrichment.destroy }
old_provider.destroy
@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",
You can’t perform that action at this time.