coolgarifTech

# Part of BORIS BOARD Project
# Visit http://www.borisboard.com for more details
#
# By Coolgarif Tech Ltd
# Author: Richie Barter
# 21 Aug 2013
# Sample script for parsing a CSV into JSON for data vis
# Underlying DataSet
# Available here: http://data.london.gov.uk/datastore/package/street-trees-borough

coolgarifTech

if __name__ == '__main__':
	app.debug = True
	app.run()

coolgarifTech

from neo4jrestclient.client import GraphDatabase
from neo4jrestclient.constants import RAW
from neo4jrestclient.client import Node 

from urlparse import urlparse
import re, json

from flask import Flask, Response, json, jsonify, request, Blueprint, render_template

app = Flask(__name__)

coolgarifTech

$ python hydraGraph.py


# Navigate to this URL
http://127.0.0.1:5000/_api/hydraGraph?callback=khjsdbkjn


# FINAL JSON END POINT RESPONSE!!
# (Note the callback wrapper at the front!)

coolgarifTech

callbackWrapper = callbackArguments + "(" + result + ")"

resp = Response(callbackWrapper, status = 200, mimetype = 'application/json') 
return resp

coolgarifTech

result = {
	'nodes' : nodes,
	'rels' : rels}

result = json.dumps(result)

coolgarifTech

for rel in querySquenceObject:
	r = rel.pop()
	start = r.get('start')
	end = r.get('end')
		
	start = urlparse(start)
	end = urlparse(end)
		
	startNode = doRegEX(start)
	endNode = doRegEX(end)

coolgarifTech

q = "START n=node(*) MATCH (n)-[r]->() RETURN r"
params = {}
querySquenceObject = db.query(q, params=params, returns=RAW)

coolgarifTech

nodeJSON.append(createNodeJSON(name, uid, description))


def createNodeJSON(name, uid, description):	
	JSONObject = {
		'name': name,
		'id' : uid,
		'description' : description
	}
	return JSONObject

coolgarifTech

def doRegEX(urlString):
	regex = re.compile("([^/]*)$")
	stripedURLComponent = regex.search(urlString.path)
	return stripedURLComponent.group(0)