Navigation Menu

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 / 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 / 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 / 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 / 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 / niceDate.php
Last active May 27, 2020 17:02
Format mySql timestamp/date field values into many different variations
<?php
/**
* Convert a mySql timestamp / date value to a nice looking date
*
* @param string $date - mySql Database timestamp / date field value
* @param num/bol $layout - Date Layout values 1 to 7 for different styles:
* [1] eg. 01.Jan.1970, 00:10:01
* [2] eg. 01.01.1970
* [3] eg. 00:10
* [4] eg. 01 January 1970