fuzzysteve

import socket
import ssl
from ssl import CERT_OPTIONAL
import datetime
import logging

def ssl_cert_info(hostname):
    ssl_date_fmt = r'%b %d %H:%M:%S %Y %Z'

    context = ssl.create_default_context()

fuzzysteve

// ==UserScript==
// @name         New Userscript
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  try to take over the world!
// @author       You
// @match        https://zkillboard.com/*
// @grant        none
// ==/UserScript==

fuzzysteve

let
    Source = Json.Document(Web.Contents("https://www.fuzzwork.co.uk/blueprint/api/blueprint.php?typeid="&Text.From(Excel.CurrentWorkbook(){[Name="blueprintid"]}[Content]{0}[Column1]))),
    blueprintDetails = Source,
    activityMaterials = blueprintDetails[activityMaterials],
    #"1" = activityMaterials[1],
    #"Converted to Table" = Table.FromList(#"1", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"typeid", "name", "quantity", "maketype"}, {"Column1.typeid", "Column1.name", "Column1.quantity", "Column1.maketype"})
in
    #"Expanded Column1"

fuzzysteve

import requests
from sqlalchemy import create_engine,MetaData,Table,Column,INTEGER,FLOAT,VARCHAR,UnicodeText,DECIMAL,Boolean,select,literal_column
import requests_cache
from requests_futures.sessions import FuturesSession
import requests_futures
from concurrent.futures import as_completed

from tqdm import tqdm

fuzzysteve

import requests
import os
import json

appkey="nope"
userid="nuhu"
apikey="nahmate"


basedir="export"

fuzzysteve

let
    Source = Binary.Decompress(Web.Contents("https://market.fuzzwork.co.uk/aggregatecsv.csv.gz"),Compression.GZip),
    #"Imported CSV" = Csv.Document(Source,[Delimiter=",", Columns=10, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Imported CSV", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"what", type text}, {"weightedaverage", type number}, {"maxval", type number}, {"minval", type number}, {"stddev", type number}, {"median", type number}, {"volume", Int64.Type}, {"numorders", Int64.Type}, {"fivepercent", type number}, {"orderSet", Int64.Type}})
in
    #"Changed Type"

fuzzysteve

from collections import defaultdict

import sys

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

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

fuzzysteve

let
    Source = Json.Document(Web.Contents("https://market.fuzzwork.co.uk/aggregates/?region=10000002&types="&Text.Combine(Table.ToList(Table.TransformColumnTypes(Table.SelectRows(Excel.CurrentWorkbook(){[Name="typelist"]}[Content], each ([Column1] <> null)),{{"Column1", type text}})),","))),
    #"Converted to Table" = Record.ToTable(Source),
    #"Expanded Value" = Table.ExpandRecordColumn(#"Converted to Table", "Value", {"buy", "sell"}, {"Value.buy", "Value.sell"}),
    #"Expanded Value.buy" = Table.ExpandRecordColumn(#"Expanded Value", "Value.buy", {"weightedAverage", "max", "min", "stddev", "median", "volume", "orderCount", "percentile"}, {"Value.buy.weightedAverage", "Value.buy.max", "Value.buy.min", "Value.buy.stddev", "Value.buy.median", "Value.buy.volume", "Value.buy.orderCount", "Value.buy.percentile"}),
    #"Expanded Value.sell" = Table.ExpandRecordColumn(#"Expanded Value.buy", "Value.sell", {"weightedAverage", "max", "min", "stddev", "median", "volume", "orderCount", "percentile"}, {"Value.sell.

fuzzysteve

Keybase proof

I hereby claim:

• I am fuzzysteve on github.
• I am fuzzysteve (https://keybase.io/fuzzysteve) on keybase.
• I have a public key ASCYnNQiwS_Lg2CqNj8Du_8BocVRuHkuTVb8fU-7y-2EPQo

To claim this, I am signing this object:

fuzzysteve

<?php

session_start();

require 'vendor/autoload.php';

use GuzzleHttp\Client;

$client = new Client();