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

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


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

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

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

select it.typeid,typename,
coalesce(a1.valuefloat,a1.valueint,0) Low,
coalesce(a2.valuefloat,a2.valueint,0) Medium,
coalesce(a3.valuefloat,a3.valueint,0) High,
coalesce(a4.valuefloat,a4.valueint,0) Drone,
coalesce(a5.valuefloat,a5.valueint,0) Rig,
coalesce(a6.valuefloat,a6.valueint,0) Subsystem,
it.raceID,
raceName,
coalesce(metagroupname,"Tech I") tech,

fuzzysteve

import time
import requests
from requests_futures.sessions import FuturesSession
import requests_futures
from concurrent.futures import as_completed
import datetime
import csv
import time
from tqdm import tqdm
import sys

fuzzysteve

 207356 | Jita IV - Moon 4 - Caldari Navy Assembly Plant
 113827 | Amarr VIII (Oris) - Emperor Family Academy
  68836 | Dodixie IX - Moon 20 - Federation Navy Assembly Plant
  45757 | Rens VI - Moon 8 - Brutor Tribe Treasury
  41056 | Hek VIII - Moon 12 - Boundless Creation Factory
  11556 | Saranen V - Moon 9 - Quafe Company Warehouse
  10494 | O1Y-ED VII - Shop Only dock and clone At cita
   8260 | Stacmon V - Moon 9 - Federation Navy Assembly Plant
   7699 | TVN-FM X - TVNo Carriers Near Thera Holes
   7407 | Tash-Murkon Prime II - Moon 1 - Kaalakiota Corporation Factory

fuzzysteve

DROP TABLE IF EXISTS `invVolumes`;
CREATE TABLE `invVolumes` (
  `typeid` int(11) NOT NULL,
  `volume` int(11) DEFAULT NULL,
  PRIMARY KEY (`typeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into invVolumes (typeid,volume)  select typeid,  2500 from invTypes where groupid=324 ;
insert into invVolumes (typeid,volume)  select typeid,  15000 from invTypes where groupid=1201 ;
insert into invVolumes (typeid,volume)  select typeid,  15000 from invTypes where groupid=27 ;

fuzzysteve

from sqlalchemy import create_engine, Column, MetaData, Table, Index
from sqlalchemy import Integer, String, Text, Float, Boolean, BigInteger, Numeric, SmallInteger, DateTime
import time
import requests
from requests_futures.sessions import FuturesSession
import requests_futures
from concurrent.futures import as_completed
import datetime
import csv
import time

fuzzysteve

from sqlalchemy import create_engine, Column, MetaData, Table, Index
from sqlalchemy import Integer, String, Text, Float, Boolean, BigInteger, Numeric, SmallInteger, DateTime
import time
import requests
from requests_futures.sessions import FuturesSession
import requests_futures
from concurrent.futures import as_completed
import datetime
import csv
import time