fuzzysteve

WITH RECURSIVE child_groups(marketGroupID) AS ( Values(4) union select invMarketGroups.marketGroupID from invMarketGroups, child_groups where invMarketGroups.parentGroupID=child_groups.marketGroupID) select typename from child_groups join invTypes on invTypes.marketGroupID=child_groups.marketGroupID order by typename

fuzzysteve

#!/usr/bin/env pythonimport zlib
# This can be replaced with the built-in json module, if desired.
import simplejson
import datetime
from datetime import datetime
import gevent
from gevent.pool import Pool
from gevent import monkey; gevent.monkey.patch_all()
import zmq.green as zmq
import zlib

fuzzysteve

from sqlalchemy import create_engine
import redis
import time
import requests
import datetime
import memcache


def RateLimited(maxPerSecond):
    minInterval = 1.0 / float(maxPerSecond)

fuzzysteve

import base64
from email.mime.text import MIMEText
import mimetypes
import httplib2
import os
import ConfigParser
import re
import datetime
from email import utils

fuzzysteve

import argparse
import textwrap
import wx
from wx.lib.pubsub import pub
import os
import csv
import requests
import grequests
import time
import locale

fuzzysteve

from collections import defaultdict

import sys

# --------
# - Read in the BLT file
# --------

fname = sys.argv[2]
fp = open(fname, "r")

fuzzysteve

Sub LoadPrices()
    Dim oHttp As Object
    Dim jsonText As String
    Dim jsonObj As Dictionary
    Dim jsonRows As Collection
    Dim jsonRow As Dictionary
    Dim costInex As Collection
    Dim ws As Worksheet
    Dim currentRow As Long
    Dim startColumn As Long

fuzzysteve

/*

Doesn't currently do anything other than dump some region information into the log.

Uses https://github.com/googlesamples/apps-script-oauth2

Details for the setup of that are on the page. short version:
Add the library MswhXl8fVhTFUH_Q3UOJbXvxhMjh3Sh48 to your sheet code. Resources -> libraries

get the project key from file-> project properties

fuzzysteve

function loadSystemVolume(typeid,systemID,sellbuy,cachebuster){
  if (typeof systemID == 'undefined'){
    systemID=30000142;
  }
  if (typeof typeid == 'undefined'){
    throw 'need typeids';
  }
  if (typeof cachebuster == 'undefined'){
    cachebuster=1;
  }

fuzzysteve

<?php
namespace FuzzyCrest;

use FuzzyCrest;

class CrestHandler
{

    private $useragent="Fuzzwork Market agent 1.0";
    private $expiry=0;