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 schema-explorer-parameters.json
{
"$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentParameters.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"resourceEnvironmentName": {
"value": ""
},
"customHostName": {
"value": ""
},
@timabell
timabell / schema-explorer-parameters.json
Last active Nov 11, 2019
simple azure ARM template for schema explorer docker image. Newer version: https://gist.github.com/timabell/ad51ef7ab1525ad2c4d929f427c535df
View schema-explorer-parameters.json
{
"$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentParameters.json#",
"contentVersion": "1.0.0.0",
"parameters": {
"containerName": {
"value": "s121d01-schema-explorer-test"
},
"location": {
"value": "westeurope"
},
View show.sh
#!/bin/bash -v
# local version of:
# http://deckdown.org/deck?theme=solarized&src=https://gist.githubusercontent.com/timabell/55ebbab29ea123c17f192bdbdec5aa44/raw/whats-a-db.md#/2
pushd .
cd ~/repo/deckdown
PORT=3002 node deckdown.js &
pid[0]=$!
popd
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).
You can’t perform that action at this time.