Skip to content

Instantly share code, notes, and snippets.

View brachycera's full-sized avatar

brachycera

5 followers · 1 following
View GitHub Profile
@brachycera
brachycera / multipleCounting.sql
Created September 2, 2015 17:51
Multiple count within one query
SELECT
SUM(CASE WHEN foo = '0' THEN 1 ELSE 0 END) AS bar_count,
SUM(CASE WHEN foo = '1' OR foo = '2' THEN 1 ELSE 0 END) AS baz_count
FROM
database
WHERE
baz = qux
GROUP BY baz
@brachycera
brachycera / countdown.js
Last active October 2, 2015 22:57
/**
*
* Simple Countdown Function
* @param {num} duration - in Milliseconds
* @param {string} elemID - DOM Object ID to show the Countdown
*
*/
function countdown(duration, elemID) {
var start = Date.now( );
@brachycera
brachycera / karma.conf.js
Last active October 11, 2015 22:27
Karma configuration File to run with gulp-karma - This setup is for an AMD project with Angular and RequireJS. The essential part to get Karma working, was to load Angular and requireJS test.config.js files before the project files. Plugins: karma-requireJS, karma-spec-reporter, karma-jasmine, karma-phantomjs-launcher
(function ( module ) {
'use strict';
module.exports = function( config ) {
config.set({
basePath : '../',
urlRoot: '/base/',
@brachycera
brachycera / delete_local_indexedDB.js
Last active October 11, 2015 22:33
Delete all local indexedDB
window.indexedDB.webkitGetDatabaseNames().onsuccess = function(sender,args){
var r = sender.target.result;
for(var i in r)
{
indexedDB.deleteDatabase(r[i]);
}
};
@brachycera
brachycera / outline.css
Created October 23, 2015 17:20
Remove yellow outline in Android Chrome & iOS Safari Browsers
html, body, div, span, applet, object, iframe,
h1, h2, h3, h4, h5, h6, p, blockquote, pre,
a, abbr, acronym, address, big, cite, code,
del, dfn, em, img, ins, kbd, q, s, samp,
small, strike, strong, sub, sup, tt, var,
b, u, i, center,
dl, dt, dd, ol, ul, li,
fieldset, form, label, legend,
table, caption, tbody, tfoot, thead, tr, th, td,
article, aside, canvas, details, embed,
@brachycera
brachycera / errors_tpl.html
Last active December 30, 2015 17:20
Angular 1.3.x Directive to fetch minlength Value from Input Text Field and show the Value in the ng-message for minlength Errors
<small class="error" ng-message="minlength" validate-minlength>Please enter at least {{requiredMinLength}} characters</small>
@brachycera
brachycera / install_gettext.sh
Created January 20, 2016 16:12 — forked from istepanov/install_gettext.sh
Compile and install gettext.so PHP extension for Mac OS X 10.8 Mountain Lion
#!/usr/bin/sh
# Scipt for installing mcrypt.so extension for PHP 5.3.13 (default PHP for OS X 10.8 Mountain Lion)
mkdir /tmp/gettext
cd /tmp/gettext
curl --location --progress-bar http://us.php.net/get/php-5.3.13.tar.gz/from/nl.php.net/mirror | tar -zx
brew update
@brachycera
brachycera / Export each as SVG.js
Created January 26, 2016 14:48 — forked from vieron/Export each as SVG.js
Export each as SVG. Modified some lines from the original by Aaron Beall (http://fireworks.abeall.com/extensions/commands/Export/Export%20SVG.jsf) to export each selected object as a separate SVG file.
// Fireworks JavaScript Command
// Exports current document state as SVG graphics format
// Install by copying to Fireworks/Configuration/Commands/
// Run via the Commands menu in Fireworks
// Aaron Beall 2010-2011
// Version
var VERSION = "0.6.1";
// Params
@brachycera
brachycera / gulpfile.js
Last active March 22, 2017 17:21
Zurb Inky setup with watcher, grunt and minify
module.exports = function (grunt) {
require('matchdep').filterDev('grunt-*').forEach(grunt.loadNpmTasks);
var siphon = require('siphon-media-query');
var fs = require('fs');
var nl_css = fs.readFileSync('PATH/TO/foundation-emails.css').toString();
var mq_css = siphon(nl_css);
// Filename for created template
@brachycera
brachycera / exclude.sh
Last active September 26, 2017 22:33
Exclude development folders like "node_modules" or "vendor" from osX timemachine backups.
find `pwd` -type d -maxdepth 3 -name 'vendor' -o -name 'node_modules'| xargs -n 1 tmutil addexclusion