Skip to content

Instantly share code, notes, and snippets.

Avatar

Colin Webb cjwebb

View GitHub Profile
@cjwebb
cjwebb / EPL-2013-2014.clj
Last active Aug 29, 2015
English Premier League results for the 2013-2014 season
View EPL-2013-2014.clj
({: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
View product-s3.json
{
"id": "s3",
"name": "BLT",
"image": "img/sandwich/s3.jpg"
}
View article-a1.json
{
"id": "a1",
"title": "Top 3 Sandwiches",
"content": "They all contain bacon.",
"product_list": [
"s1", "s2", "s3"
]
}
View product-s1.json
{
"id": "s1",
"name": "Club Sandwich",
"image": "img/sandwich/s1.jpg"
}
View product-s2.json
{
"id": "s2",
"name": "Chicken & Bacon",
"image": "img/sandwich/s2.jpg"
}
@cjwebb
cjwebb / country-codes.txt
Created Aug 18, 2014
Valid ISO 316601 2 Letter Country Codes
View country-codes.txt
AC
AD
AE
AF
AG
AI
AL
AM
AN
AO
@cjwebb
cjwebb / irclogger.go
Created Nov 20, 2014
Log into IRC and display chat
View irclogger.go
package main
import (
"net"
"net/textproto"
"fmt"
"log"
"bufio"
)
@cjwebb
cjwebb / cassandra-cqlsh-errors.txt
Created Dec 2, 2014
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.
View cassandra-cqlsh-errors.txt
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 Aug 25, 2015
Cypher to import BBC Food recipes into Neo4J
View recipes.cypher
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";
View ingredients.txt
acorn squash
ale
alfalfa sprouts
allspice
almond
almond extract
almonds
amaretti
amaretto
anchovies