View Find different between dates in mysql.sql
SELECT id, TIMEDIFF(ended_at, started_at) as timediff FROM ... |
View 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: |
View 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"}} []" |
View byte_to_str.go
func BytesToString(data []byte) string { | |
return string(data[:]) | |
} |
View clean-deleted-branches.sh
git branch --merged | egrep -v "(^\*|master|dev)" | xargs git branch -d |
View sample-nginx.conf
daemon off; | |
pid /tmp/nginx.pid; | |
error_log /dev/stderr info; | |
worker_processes auto; | |
events { | |
worker_connections 1024; | |
} | |
http { |
View lumen-query-log.php
/** | |
* You must enable to Query Log when using Lumen. | |
*/ | |
DB::connection()->enableQueryLog(); | |
$queries = DB::getQueryLog(); | |
$last_query = end($queries); |
View 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')) |
View 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() { |
View 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 | |
}); | |