timabell

# boxstarter script http://boxstarter.org/
# source: https://gist.github.com/timabell/14c15666fa58d3db66aa3411d243967e
# based on: https://gist.github.com/timabell/608fb680bfc920f372ac
# tested on win10 x64

# This is a start of a build of a box I'm using at the moment.
# Fork this to your own gist, then comment/uncomment/add stuff to suit you.

# This for a win 10 machine where development will be done in Hyper-V VMs so
# there's no need for dev tools.

timabell

# output all the colour combinations for text/background
# https://stackoverflow.com/questions/20541456/list-of-all-colors-available-for-powershell/41954792#41954792
$colors = [enum]::GetValues([System.ConsoleColor])
Foreach ($bgcolor in $colors){
	Foreach ($fgcolor in $colors) { Write-Host "$fgcolor|"  -ForegroundColor $fgcolor -BackgroundColor $bgcolor -NoNewLine }
	Write-Host " on $bgcolor"
}

timabell

# customized per-user profile
# https://gist.github.com/timabell/56254968905f9066ef88c1ae774a53d1
# don't forget to start a new powershell after editing this

# useful things:
# install https://github.com/neilpa/cmd-colors-solarized
# regedit /s solarized-light.reg
# install https://github.com/dahlbyk/posh-git
# Install-Module posh-git  # requires PSGet

timabell

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:

timabell

#!/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

#!/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

# https://gist.github.com/timabell/bc90e0808ec1cda173ca09225a16e194
# MIT license
$exts=@(
	"csv",
	"csproj",
	"json",
	"log",
	"md",
	"patch",
	"sql",

timabell

-- 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

{"lastUpload":"2019-02-07T15:29:46.603Z","extensionVersion":"v3.2.4"}

timabell

# http://schemaexplorer.io/
# This file configures which columns will be loaded from the other side of a foreign key.
# Place this file in folder `config` next the schema explorer executable and name it peek-config.txt, or use the `-peek-config-file` option to pass the path to it.

# Lines starting with # will be ignored along with blank lines.
# Names are lowercased before matching so make sure your all your regexes below are entirely lowercase otherwise they won't match.
# 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).