Skip to content

Instantly share code, notes, and snippets.

View truedat101's full-sized avatar

David J. Kordsmeier truedat101

52 followers · 54 following
View GitHub Profile
@truedat101
truedat101 / .gitignore for IDEs
Created June 17, 2009 17:18
# .gitignore for IDE users
#
# .gitignore for eclipse
#
.settings
#
# .gitignore for XCode users
@truedat101
truedat101 / sql-dates-and-fun.sql
Created March 26, 2012 02:09
Some SQL dating
/* Simple query to convert dob (date) into number) */
SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl
/* Simple query to add WHERE clause into above computed field, get all aged above 50 */
select age from (SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl) bar where age > 50;
/* Simple query to add WHERE clause into above computed field, get all aged above 25 and less than 70 */
select age from (SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl) bar
WHERE age > 25
AND age < 70
@truedat101
truedat101 / gist:3883652
Created October 13, 2012 07:22
SMILE Plug load test 1 - 100000 requests with 1000 concurrent requests , server is https://npmjs.org/package/js.js
SMILE Plug is running:
Linux SMILEplug 2.6.35.9-ARCH #7 PREEMPT Wed Sep 19 14:07:47 MDT 2012 armv7l GNU/Linux
root@SMILEplug:~/spdist# cat /proc/cpuinfo
Processor : Marvell PJ4Bv7 Processor�� rev 1 (v7l)
BogoMIPS : 1199.30
Features : swp half thumb fastmult vfp edsp vfpv3 vfpv3d16
CPU implementer : 0x56
CPU architecture: 7
CPU variant : 0x1
CPU part : 0x581
@truedat101
truedat101 / gist:3902091
Last active October 11, 2015 18:38
Graylog2 upstart for webrick
# /etc/init/graylog-webrick.conf
# attribution:
# http://blog.joshsoftware.com/2012/02/14/upstart-scripts-in-ubuntu/
#
# More on upstart for dummies: http://upstart.ubuntu.com/getting-started.html
#
description "graylog2 webrick service"
author "foo"
# used to be: start on startup
@truedat101
truedat101 / pedantically_commented_playbook.yml
Created November 8, 2012 23:22 — forked from phred/pedantically_commented_playbook.yml
Insanely complete Ansible playbook, showing off all the options
---
# ^^^ YAML documents must begin with the document separator "---"
#
#### Example docblock, I like to put a descriptive comment at the top of my
#### playbooks.
#
# Overview: Playbook to bootstrap a new host for configuration management.
# Applies to: production
# Description:
# Ensures that a host is configured for management with Ansible.
@truedat101
truedat101 / LICENSE
Created April 23, 2013 16:32
Licensing SMILE Consortium Software. Instructions: * Place a LICENSE file in the root level of the project * Place a NOTICE file in the root level of the project. Update dates if needed * Add a License/Copyright Header to each code source file (not necessary on build files) * Do not remove any 3rd party licenses or copyrights. * Provide attribut…
Apache License
Version 2.0, January 2004
http://www.apache.org/licenses/
TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
1. Definitions.
"License" shall mean the terms and conditions for use, reproduction,
and distribution as defined by Sections 1 through 9 of this document.
@truedat101
truedat101 / gist:5545773
Last active December 17, 2015 03:48
SMILE Teacher Upload CSV Template: http://smilec.s3.amazonaws.com/sample_smileupload_template.csv
question,choice1,choice2,choice3,choice4,has_image,answers
What color is the sky?,Blue,Green,Yellow,Orange,,choice1
@truedat101
truedat101 / gist:6093671
Created July 27, 2013 04:06
Set up a qq mail account , and then configure imap
Sign up here
http://zc.qq.com/en/index.html
You will be required to provide a valid email to allow you to validate the account. Also annoying, you don't get to choose your email account name, it gets assigned.
Sign in, english: https://en.mail.qq.com/cgi-bin/loginpage
For configuration, I could not get pop3 working. It's unclear why. IMAP did work, using:
@truedat101
truedat101 / gist:6646367
Created September 21, 2013 02:03
iwdev and iwconfig for SMILEPlug
Script started on Thu 29 Aug 2013 03:40:33 PM PDT
root@SMILEplug:~# ip##[Kwpriv wdev0ap0 wpawpa2mode 3
root@SMILEplug:~# iwpriv wdev0ap0 wpawpa2mode 3##[K##[K##[K##[K##[K##[K##[K##[K##[K##[K##[K##[K##[Kpassphrase "wpa2 mysecret"
root@SMILEplug:~# ip##[Kwpriv wdev0ap0 ciphersuite "wpa2 aes-ccmp"
root@SMILEplug:~# w##[Kiwconfig de##[K##[Kwe##[Kdev0ap0 commit
root@SMILEplug:~# iwconfig wdev0ap0 commit
root@SMILEplug:~# iwpriv wdev0ap0 wpawpa2mode 3
lo no private ioctls.
eth0 no private ioctls.
@truedat101
truedat101 / smilequestionsloaded
Last active December 24, 2015 21:09
Sample SMILE JSON data
[
{
"TYPE":"QUESTION",
"IP":"127.0.0.1",
"NAME":"teacher",
"O1":"Person from outer space",
"O2":"Both answers in 3) and 4)",
"O3":"Non-citizen",
"O4":"A first generation of Japanese (Issei) who came to the U.S.A.",
"Q":"When referring to Japanese Americans, what was an Alien?",