Skip to content

Instantly share code, notes, and snippets.

Ben New leftclickben

Block or report user

Report or block leftclickben

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
@leftclickben
leftclickben / cleanup-providence-database-after-relationship-generator-integration-test.sql
Created May 14, 2014
cleanup-providence-database-after-relationship-generator-integration-test.sql
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.
-- NOTE YOU WILL NEED TO MODIFY SOME OF THE HARDCODED VALUES IN HERE TO SUIT YOUR CURRENT 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
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
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
<?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
#!/bin/bash
# http://nigel.mcnie.name/blog/removing-the-referer-part-of-php-error-messagse-from-apache-logs
perl -pe 's/\s+\[\:error\]\s+\[pid\s+\d+\]\s+\[client\s+.*?\]//; s/, referer:.*//'
@leftclickben
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
#!/usr/bin/php
<?php
// This is the input array.
$values = array(
array(
'title' => 'First item (1,1)',
'categoryID' => 1,
'storeID' => 1
),
@leftclickben
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>
<html>
<head>
<title>Knockout Date Selector</title>
</head>
<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>
<p>
@leftclickben
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 Leftclick.com.au
* 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
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
#!/bin/bash
curl -sL https://deb.nodesource.com/setup_5.x | 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
leftclickben / git-update
Last active Jul 29, 2016
Pull down latest from git remote and remove dead branches
View git-update
#!/bin/bash
#
# 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 Leftclick.com.au
# License: MIT
@leftclickben
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: https://gist.github.com/spencermefford/bc73812f216e0e254ad1
module.exports = function (server, callback) {
var ACL = server.models.ACL,
User = server.models.User,
Role = server.models.Role,
RoleMapping = server.models.RoleMapping;
You can’t perform that action at this time.