Skip to content

Instantly share code, notes, and snippets.


Ben New leftclickben

View GitHub Profile
leftclickben / cleanup-providence-database-after-relationship-generator-integration-test.sql
Created May 14, 2014
View cleanup-providence-database-after-relationship-generator-integration-test.sql
-- Cleans up any data that might be remnant after a run of the RelationshipGeneratorPluginIntegrationTest,
-- particularly if the run fails for some reason, it might not execute its tearDown() and can leave remnant
-- data in the database.
-- Alternatively this could probably be improved to use more of the "code like '%...%'" and less of the "id > X" style
delete from ca.ca_attribute_values where value_id > 14;
delete from ca.ca_attributes where table_num = 57 and element_id = 70 and row_id > 46;
leftclickben / nestedRenameSpacesToUnderscores
Last active Aug 29, 2015
Rename whitespace in files to underscores, with any level of nesting
View nestedRenameSpacesToUnderscores
maxdepth=`find . -printf '%d\\n' | sort -n | tail -1` && for depth in `seq 1 $maxdepth`; do find -mindepth 1 -maxdepth $depth -exec bash -c 'f=`echo "{}" | sed -r s:\\\s+:_:g` ; if [ "$f" != "{}" ]; then mv "{}" "$f"; fi' \; ; done
leftclickben / describeScreen.php
Last active Aug 29, 2015
(CollectiveAccess) Retrieve CSV of placements for a given screen, with labels
View describeScreen.php
#!/usr/bin/env php
$screen = 35; // modify as required
$locale = 'en_AU';
$pdo = new PDO('mysql:host=wamcmisdb01-staging;dbname=cmis', 'cmis', 'uhkdv5Uwhkk7pmv');
$placements = $pdo->query('select * from ca_editor_ui_bundle_placements where screen_id = ' . $screen . ' order by rank asc')->fetchAll();
foreach ($placements as $placement) {
$settings = unserialize(base64_decode($placement['settings']));
View strip-referer
perl -pe 's/\s+\[\:error\]\s+\[pid\s+\d+\]\s+\[client\s+.*?\]//; s/, referer:.*//'
leftclickben / testUnsort
Created Sep 6, 2013
Take an array of items and "unsort" them so that the items sharing similar properties are separated as much as possible. This code is not highly optimised and is not recommended for large data sets.
View testUnsort
// This is the input array.
$values = array(
'title' => 'First item (1,1)',
'categoryID' => 1,
'storeID' => 1
leftclickben / knockoutDateSelector
Last active Dec 24, 2015
Knockout date selector - use three `<select>` elements and compute a date, also restrict date within certain range
View knockoutDateSelector
<!doctype html>
<title>Knockout Date Selector</title>
<body style="background-color:#eee;font-family:sans-serif;">
<article style="width:600px;background-color:#fff;margin:1em auto;border:1px solid #000;padding:1em;">
<h1>Knockout Date Selector</h1>
leftclickben / loadtest.js
Last active Dec 28, 2015
Simple website load tester written in Node.js
View loadtest.js
/*jslint node: true, white: true, nomen: true, plusplus: true*/
/*globals require: true, process: true*/
* Generic load tester
* Copyright (c) 2013
* MIT License, or whatever.
* Author assumes no liability for damage, loss, etc.
* Configuration is passed as a command-line argument when running node, e.g.
leftclickben / ubuntu-node-setup-5.x
Created Jan 22, 2016
Complete instructions for installing node 5.x on Ubuntu via apt (should work for other versions, just change `5.x`)
View ubuntu-node-setup-5.x
curl -sL | sudo -E bash -
sudo apt-get install nodejs
sudo chown -R $USER /usr/lib/node_modules/
sudo chgrp $USER /usr/bin
sudo chmod g+w /usr/bin
leftclickben / git-update
Last active Jul 29, 2016
Pull down latest from git remote and remove dead branches
View git-update
# git-update
# Pull down latest from git remote and remove dead branches
# To create an alias to `git update`, put this on your path, then:
# git config --global alias.update '!git-update'
# Copyright (c) 2016
# License: MIT
leftclickben / admin-access.js
Last active Jul 4, 2018 — forked from spencermefford/0-model-override.js
An alternative to extending Loopback's built-in models: use a boot script to enhance the built-in model
View admin-access.js
(function () {
'use strict';
// Relevant resource:
module.exports = function (server, callback) {
var ACL = server.models.ACL,
User = server.models.User,
Role = server.models.Role,
RoleMapping = server.models.RoleMapping;