Skip to content

Instantly share code, notes, and snippets.

View philihp's full-sized avatar
👨‍💻
Turning caffeine into code

‮Philihp Busby philihp

👨‍💻
Turning caffeine into code
View GitHub Profile
@philihp
philihp / gist:8023422
Last active December 31, 2015 17:59
query for aaron
select c.name, m.serialnumber,
first_value(l.username) over (order by l.timestamp desc) as username
from machines m
inner join computersmachine cm on (m.id=cm.machineid)
inner join computers c on (cm.computerid=c.id)
left join logins l on (l.machineid=m.id)
libname frc 'u:\public\frc';
data frc.records(keep=team_id opponent_id result);
set frc.results;
array red(1:3) red1-red3;
array blue(1:3) blue1-blue3;
select;
when(redScore > blueScore) result = 2;
when(redScore < blueScore) result = 0;
when(redScore = blueScore) result = 1;
end;
package sos;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Map.Entry;
import java.util.Set;
/***
Calculating the odds of the 3-strike game on The Price Is Right
***/
data trials(keep=outcome j strikes);
outcome = 0;
do i=1 to 10000000;
bag = 8;
strikes = 3;
@philihp
philihp / Authenticate.java
Created April 5, 2012 18:33
Facebook OAuth with Scribe in Struts 1
import org.apache.struts.action.*;
import com.google.gson.*;
import org.scribe.builder.*;
import org.scribe.builder.api.*;
import org.scribe.model.*;
import org.scribe.oauth.*;
public class Authenticate extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
@philihp
philihp / java7stringswitch.java
Created January 23, 2012 04:12
Java 7 switching on a String
switch(suit) {
case "club":
case "diamond":
trickValue = 20;
break;
case "heart":
case "spade":
trickValue = 30;
break;
case "no-trump":