Skip to content

Instantly share code, notes, and snippets.

@cjwebb
cjwebb / EPL-2013-2014.clj
Last active August 29, 2015 13:59
English Premier League results for the 2013-2014 season
({:date Monday 31 March 2014, :location Stadium of Light, :away-team West Ham, :score 1 - 2, :home-team Sunderland, :time 20:00}
{:date Sunday 30 March 2014, :location Anfield, :away-team Spurs, :score 4 - 0, :home-team Liverpool, :time 16:00}
{:date Sunday 30 March 2014, :location Craven Cottage, :away-team Everton, :score 1 - 3, :home-team Fulham, :time 13:30}
{:date Saturday 29 March 2014, :location Emirates Stadium, :away-team Man City, :score 1 - 1, :home-team Arsenal, :time 17:30}
{:date Saturday 29 March 2014, :location Selhurst Park, :away-team Chelsea, :score 1 - 0, :home-team Crystal Palace, :time 15:00}
{:date Saturday 29 March 2014, :location St. Mary's Stadium, :away-team Newcastle, :score 4 - 0, :home-team Southampton, :time 15:00}
{:date Saturday 29 March 2014, :location Britannia Stadium, :away-team Hull, :score 1 - 0, :home-team Stoke, :time 15:00}
{:date Saturday 29 March 2014, :location Liberty Stadium, :away-team Norwich, :score 3 - 0, :home-team Swansea, :time 15:00}
{:date Saturday 29 Ma
@cjwebb
cjwebb / article-a1.json
Created June 8, 2014 09:49
GET /article/a1
{
"id": "a1",
"title": "Top 3 Sandwiches",
"content": "They all contain bacon.",
"product_list": [
"s1", "s2", "s3"
]
}
@cjwebb
cjwebb / product-s1.json
Created June 8, 2014 09:51
GET /product/s1
{
"id": "s1",
"name": "Club Sandwich",
"image": "img/sandwich/s1.jpg"
}
@cjwebb
cjwebb / product-s2.json
Created June 8, 2014 09:52
GET /product/s2
{
"id": "s2",
"name": "Chicken & Bacon",
"image": "img/sandwich/s2.jpg"
}
@cjwebb
cjwebb / product-s3.json
Created June 8, 2014 09:52
GET /product/s3
{
"id": "s3",
"name": "BLT",
"image": "img/sandwich/s3.jpg"
}
@cjwebb
cjwebb / country-codes.txt
Created August 18, 2014 09:47
Valid ISO 316601 2 Letter Country Codes
AC
AD
AE
AF
AG
AI
AL
AM
AN
AO
@cjwebb
cjwebb / irclogger.go
Created November 20, 2014 20:04
Log into IRC and display chat
package main
import (
"net"
"net/textproto"
"fmt"
"log"
"bufio"
)
@cjwebb
cjwebb / cassandra-cqlsh-errors.txt
Created December 2, 2014 16:55
Creating a table with a timestamp column, and then inserting data with a massive timestamp results in CQLSH errors when trying to remove the inserted data.
Creating a table with a timestamp column, and then inserting data with a massive timestamp results in CQLSH errors when trying to remove the inserted data.
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 2.1.0 | CQL spec 3.2.0 | Native protocol v3]
cqlsh> create keyspace test WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 };
cqlsh> use test;
cqlsh:test> create table test.table1 (id int, time timestamp, primary key (id));
clqsh:test> insert into table1(id, time) values (1, 1000000000000000) ;
cqlsh:test> select * from table1;
@cjwebb
cjwebb / recipes.cypher
Created August 25, 2015 14:44
Cypher to import BBC Food recipes into Neo4J
This file has been truncated, but you can view the full file.
MERGE (f:Food:Recipe {id: "e02e63be-2b7c-4bfe-a1a0-7d6153f24673", name: "Bread sauce", source_url: "http://www.bbc.co.uk/food/recipes/breadsauce_84755", source_name: "BBC Food", image_url: "http://ichef.bbci.co.uk/food/ic/food_16x9_448/recipes/breadsauce_84755_16x9.jpg", description: "This crowd-pleasing bread sauce recipe by Nigella Lawson is an easy extra for Christmas Day and is just as good served cold with leftovers. The recipe appears in Nigella's book Feast, published by Chatto & Windus."});
MERGE (f:Food{ name:"1 day-old loaf unsliced white bread"}) ON CREATE SET f.id = "d744762e-2351-480a-84fb-878d53b72992";
MATCH (r:Recipe {id: "e02e63be-2b7c-4bfe-a1a0-7d6153f24673"}),(f:Food{id:"d744762e-2351-480a-84fb-878d53b72992"}) CREATE (r)-[:CONTAINS]->(f);
MERGE (f:Food{ name:"1 litre/2 pints full-fat milk"}) ON CREATE SET f.id = "8840ab8d-61f4-4c7a-bcbe-cd607be10772";
MATCH (r:Recipe {id: "e02e63be-2b7c-4bfe-a1a0-7d6153f24673"}),(f:Food{id:"8840ab8d-61f4-4c7a-bcbe-cd607be10772"}) CREATE (r)-[:CONTAINS]-
acorn squash
ale
alfalfa sprouts
allspice
almond
almond extract
almonds
amaretti
amaretto
anchovies