Alex Richards ajtrichards

## Find different between dates in mysql.sql
SELECT id, TIMEDIFF(ended_at, started_at) as timediff FROM ...

## gist:b918565b0c32c13ab25a63df4795e42c
### Keybase proof

I hereby claim:

  * I am ajtrichards on github.
  * I am alexrichards (https://keybase.io/alexrichards) on keybase.
  * I have a public key ASDv_Nt0itWm_BtpceiaxDWHtvVxEmNbt-THZBG5DSQDkgo

To claim this, I am signing this object:

## example-log-entry.sh
 Feb 3 19:27:50 user-api-*-* user-api WARNING [03-Feb-2018 19:27:50] WARNING: [pool www] child 958 said into stderr: "[2018-02-03 19:27:50] lumen.DEBUG: user.api.view.user.error.user-details {"action":"user.api.view.user.error.user-details","userData":{"forename":"Alex","surname":"Richards","fullname":"Alex Richards","email":"emailaddress@hidden.com","username":"emailaddress@hidden.com","enabled":true,"earn":"earn:user/users:A-UUID-4"}} []"

## byte_to_str.go
func BytesToString(data []byte) string {
  return string(data[:])
}

## clean-deleted-branches.sh
git branch --merged | egrep -v "(^\*|master|dev)" | xargs git branch -d

## sample-nginx.conf
daemon off;
pid /tmp/nginx.pid;
error_log /dev/stderr info;
worker_processes auto;

events {
    worker_connections 1024;
}

http {

## lumen-query-log.php
/**
 * You must enable to Query Log when using Lumen.
 */
DB::connection()->enableQueryLog();

$queries 	= DB::getQueryLog();
$last_query = end($queries);

## sql-date-query.sql
SELECT * FROM tablename WHERE date <= UNIX_TIMESTAMP(STR_TO_DATE('Apr 07 2015 09:00AM', '%M %e %Y %h:%i%p'))

## color-bash.sh
NORMAL=$(tput sgr0)
GREEN=$(tput setaf 2; tput bold)
YELLOW=$(tput setaf 3)
RED=$(tput setaf 1)

function red() {
    echo -e "$RED$*$NORMAL"
}

function green() {

## client.html
<script type="text/javascript" src="http://localhost:8000/faye/client.js"></script>
<script type="text/javascript">

		/*
		**	Script to handle notifications
		*/
		var client = new Faye.Client('http://localhost:8000/faye',{
			timeout: 120
		});
	### Keybase proof

	I hereby claim:

	* I am ajtrichards on github.
	* I am alexrichards (https://keybase.io/alexrichards) on keybase.
	* I have a public key ASDv_Nt0itWm_BtpceiaxDWHtvVxEmNbt-THZBG5DSQDkgo

	To claim this, I am signing this object:
	func BytesToString(data []byte) string {
	return string(data[:])
	}
	daemon off;
	pid /tmp/nginx.pid;
	error_log /dev/stderr info;
	worker_processes auto;

	events {
	worker_connections 1024;
	}

	http {
	/**
	* You must enable to Query Log when using Lumen.
	*/
	DB::connection()->enableQueryLog();

	$queries = DB::getQueryLog();
	$last_query = end($queries);
	NORMAL=$(tput sgr0)
	GREEN=$(tput setaf 2; tput bold)
	YELLOW=$(tput setaf 3)
	RED=$(tput setaf 1)

	function red() {
	echo -e "$RED$*$NORMAL"
	}

	function green() {
	<script type="text/javascript" src="http://localhost:8000/faye/client.js"></script>
	<script type="text/javascript">

	/*
	** Script to handle notifications
	*/
	var client = new Faye.Client('http://localhost:8000/faye',{
	timeout: 120
	});