Skip to content

Instantly share code, notes, and snippets.

@osullivj
osullivj / xltiingo.py
Last active April 14, 2016 16:22
Tornado based Tiingo proxy for Excel
# A 'bridge' HTTP server that translates Excel web invocations to tiingo API calls
# Requirements: Python 3.4, Tornado 4.3
# JOS 2016-02-16
import socket
import logging
import os
import tornado.ioloop
import tornado.web
from tornado.httpclient import AsyncHTTPClient, HTTPRequest
@osullivj
osullivj / ss_schema1.py
Created April 10, 2016 21:22
SpreadServe Cloud Schema
# create SS cloud schema
import socket
import logging
import os
import rethinkdb as rdb
if __name__ == "__main__":
conn = rdb.connect( 'localhost', 28015)
@osullivj
osullivj / rdbtornado1.py
Last active March 16, 2020 13:28
Minimal Tornado Web Server & RethinkDB Python Client
# A test tornado HTTP server integrates with RethinkDB
# Requirements: Python 3.4, Tornado 4.3, RethinkDB 2.3.0
# JOS 2016-04-08
import socket
import logging
import os
import tornado.ioloop
import tornado.web
import rethinkdb as rdb
2015.10.18 20.11.05_553 INF : 9180 SpreadServeProcess ctor: InputTopic(/ss/engine/9172/input) OutputTopic(/ss/engine/9172/output) ServiceName(SpreadServeEngine9172)
2015.10.18 20.11.05_553 INF : 9180 host(JOHN-ULTRA) user(JOHN-ULTRA\John) pid(9172)
2015.10.18 20.11.05_553 INF : 9180 cmd line args: c:\ss\xl\bin\dbg\sseng.exe -PIPE_LOG J -ENV SIT -SUPPRESS_OUTPUT_LOG 1
2015.10.18 20.11.05_553 INF : 9180 ######################################################
2015.10.18 20.11.05_554 INF : 9180 SpreadServeProcess ctor: InputTopic(/ss/engine/9172/input) OutputTopic(/ss/engine/9172/output) ServiceName(SpreadServeEngine9172)
2015.10.18 20.11.05_554 INF : 9180 CCmdLineOpt::ParseFromString: opt(PIPE_LOG) val(J)
2015.10.18 20.11.05_555 INF : 9180 CCmdLineOpt::ParseFromString: opt(ENV) val(SIT)
2015.10.18 20.11.05_555 INF : 9180 CCmdLineOpt::ParseFromString: opt(SUPPRESS_OUTPUT_LOG) val(1)
2015.10.18 20.11.05_555 INF : 9180 CProcFwk::GenSessionId : sessionid : john-ultra_9172_a18191053627
2015.10.18 19.18.39_849 INF : 4536 SpreadServeProcess ctor: InputTopic(/ss/engine/4428/input) OutputTopic(/ss/engine/4428/output) ServiceName(SpreadServeEngine4428)
2015.10.18 19.18.39_849 INF : 4536 host(WIN-E2ABUUD2V1V) user(NT AUTHORITY\SYSTEM) pid(4428)
2015.10.18 19.18.39_849 INF : 4536 cmd line args: c:\SpreadServe\ss0.3.1\bin\sseng.exe -PIPE_LOG SX -env SIT -name SpreadServeEngine
2015.10.18 19.18.39_849 INF : 4536 ######################################################
2015.10.18 19.18.39_849 INF : 4536 SpreadServeProcess ctor: InputTopic(/ss/engine/4428/input) OutputTopic(/ss/engine/4428/output) ServiceName(SpreadServeEngine4428)
2015.10.18 19.18.39_850 INF : 4536 CCmdLineOpt::ParseFromString: opt(PIPE_LOG) val(SX)
2015.10.18 19.18.39_850 INF : 4536 CCmdLineOpt::ParseFromString: opt(ENV) val(SIT)
2015.10.18 19.18.39_850 INF : 4536 CCmdLineOpt::ParseFromString: opt(NAME) val(SpreadServeEngine)
2015.10.18 19.18.39_850 INF : 4536 CProcFwk::GenSessionId : sessionid : win-e2abuud2v1v_4428_a1819
# Copyright (c) Babbington Slade 2015 www.spreadserve.com
#
import sys
import socket
import blockspring
# To run this at the command line...
# c:\python27\python bspring_client2.py --sheet=BlackScholes.xls --age=31
# The JSON msg we send to SpreadServe's BlockSpringServer