Skip to content

Instantly share code, notes, and snippets.

SELECT s.*
FROM stats s
INNER JOIN players p ON p.id = s.player_id
INNER JOIN years y ON y.id = s.years_id
WHERE
p.espnID = ? AND y.year = ?

Keybase proof

I hereby claim:

  • I am djktno on github.
  • I am djktno (https://keybase.io/djktno) on keybase.
  • I have a public key whose fingerprint is 8E85 8277 2A28 7074 0BB8 1DBB 2429 9618 AEC0 F3ED

To claim this, I am signing this object:

@djktno
djktno / gist:1038381
Created June 21, 2011 17:27
Odd behavior registering query with percolator.
##Consider the following query...
{
"query": {
"span_near": {
"clauses": [
{
"span_term": {
"content": {
"term": "007",
@djktno
djktno / example_worker.rb
Created April 4, 2011 22:42
Integrating MongoDB/Mongoid with SimpleWorker
require 'simple_worker'
require 'mongoid'
class ExampleWorker < SimpleWorker::Base
#Not sure if this is necessary (according to the docs), but
#it stopped complaining when I did it.
merge File.join(File.dirname("__FILE__"), "..", "models", "user.rb")
attr_accessor :user_id, :mongodb_settings
@djktno
djktno / DefaultMongoDocument.java
Created November 11, 2010 06:52
Example of a MongoDocument implementation for cascading.mongodb in sink mode.
package cascading.mongodb.document;
import cascading.mongodb.MongoDocument;
import cascading.tuple.Fields;
import cascading.tuple.Tuple;
import cascading.tuple.TupleEntry;
import com.mongodb.BasicDBObject;
import com.mongodb.MongoException;
import java.util.Iterator;