import sqlite3 import urllib import tempfile import json import scraperwiki scraperwiki.cache(True) temp = tempfile.NamedTemporaryFile() contents = urllib.urlopen( "http://seagrass.goatchurch.org.uk/~julian/uusaves/kforgecavedatastations" ).read() open(temp.name, "wb").write(contents) conn = sqlite3.connect(temp.name) c = conn.cursor() data = c.execute( """SELECT coalesce(eqfrom.eto, sfrom) AS cfrom, stfrom.x, stfrom.y, coalesce(eqto.eto, sto) AS cto, stto.x, stto.y FROM legs LEFT JOIN equates AS eqfrom ON eqfrom.efrom = sfrom LEFT JOIN equates AS eqto ON eqto.efrom = sto LEFT JOIN stations AS stfrom ON cfrom = stfrom.station LEFT JOIN stations AS stto ON cto = stto.station""") jcode = """ window.onload = function() { var paper = Raphael(10, 50, 320, 200); var d = %s;
import sqlite3 import urllib import tempfile import json import scraperwiki import math scraperwiki.cache(False) temp = tempfile.NamedTemporaryFile() contents = urllib.urlopen( "http://seagrass.goatchurch.org.uk/~julian/uusaves/kforgecavedata").read() open(temp.name, "wb").write(contents) conn = sqlite3.connect(temp.name) c = conn.cursor() stationlegs = {} for leg in c.execute(""" SELECT coalesce(eqfrom.eto, sfrom), coalesce(eqto.eto, sto), tape, compass, clino FROM legs LEFT JOIN equates AS eqfrom ON eqfrom.efrom = sfrom LEFT JOIN equates as eqto on eqto.efrom = sto"""): stationlegs.setdefault(leg[0], []).append(leg) stationlegs.setdefault(leg[1], []).append(leg) station = (stationlegs.keys())[0] stationpos = {station: (0.0, 0.0, 0.0)} # first position lstations = [station] while lstations: station = lstations.pop(0) for leg in stationlegs[station]: ostation = (station == leg[0] and leg[1] or leg[0]) if ostation in stationpos:
import sqlite3 import urllib import tempfile import json import scraperwiki scraperwiki.cache(True) temp = tempfile.NamedTemporaryFile() contents = urllib.urlopen("http://seagrass.goatchurch.org.uk/~julian/uusaves/kforgecavedatastations").read() open(temp.name, "wb").write(contents) conn = sqlite3.connect(temp.name) c = conn.cursor() data = c.execute("""SELECT coalesce(eqfrom.eto, sfrom) AS cfrom, stfrom.x, stfrom.y, coalesce(eqto.eto, sto) AS cto, stto.x, stto.y FROM legs LEFT JOIN equates AS eqfrom ON eqfrom.efrom = sfrom LEFT JOIN equates AS eqto ON eqto.efrom = sto LEFT JOIN stations AS stfrom ON cfrom = stfrom.station LEFT JOIN stations AS stto ON cto = stto.station""") jcode = """ window.onload = function() { var paper = Raphael("rrr", 400, 400); var d = %s; function h(x) { return (x+70)*2 }; function v(x) { return 350-(x+70)*2 };
import sqlite3 import urllib import tempfile import json import scraperwiki import math scraperwiki.cache(False) temp = tempfile.NamedTemporaryFile() contents = urllib.urlopen("http://seagrass.goatchurch.org.uk/~julian/uusaves/kforgecavedata").read() open(temp.name, "wb").write(contents) conn = sqlite3.connect(temp.name) c = conn.cursor() stationlegs = { } for leg in c.execute(""" SELECT coalesce(eqfrom.eto, sfrom), coalesce(eqto.eto, sto), tape, compass, clino FROM legs LEFT JOIN equates AS eqfrom ON eqfrom.efrom = sfrom LEFT JOIN equates as eqto on eqto.efrom = sto"""): stationlegs.setdefault(leg[0], []).append(leg) stationlegs.setdefault(leg[1], []).append(leg) station = (stationlegs.keys())[0] stationpos = {station:(0.0, 0.0, 0.0)} # first position lstations = [ station ] while lstations: station = lstations.pop(0) for leg in stationlegs[station]: ostation = (station == leg[0] and leg[1] or leg[0]) if ostation in stationpos: