Exemplo n.º 1
0
def request_cloud_to_json(request):
    req = request.GET or request.POST
    #    for key, value in req.iteritems():
    #        print key, value
    form_name = req.get("form_name", None)
    input_keys = req.getlist("input_keys[]", None)
    #    print input_keys
    selected_key = req.get("selected_key", input_keys[0])
    data_amount = int(req.get("data_amount", 0))
    year = int(req.get("start_year", 2010))
    month = int(req.get("start_month", 1))
    day = int(req.get("start_day", 1))
    insts = req.getlist("instruments[]", None)
    #    print form_name, input_keys, data_amount, year, month, day, insts, selected_key

    select_column = []

    file_name = request.session["file_name"]
    data = csv.DictReader(open(file_name))
    for row in data:
        select_column.append(row[selected_key])
    #    print data[selected_key]
    print select_column
    print year, month, day
    print insts
    print data_amount
    mongo_data = {}
    for currency in insts:
        cursor = get_currency_candles(currency=currency, start=datetime.datetime(year=year, month=month, day=day))
        cnt = 0
        mongo_data[currency] = []
        for row in cursor:
            mongo_data[currency].append(row["closeMid"])
            cnt += 1
            if cnt >= data_amount:
                break

    return HttpResponse(json.dumps({"a": 10, "b": 20}))
Exemplo n.º 2
0
def request_to_json(request):
    req = request.GET or request.POST
#    for key, value in req.iteritems():
#        print key, value
    form_name = req.get('form_name', None)
    input_keys = req.getlist('input_keys[]', None)
#    print input_keys
    selected_key = req.get('selected_key', input_keys[0])
    data_amount = int(req.get('data_amount', 0))
    year = int(req.get('start_year', None))
    month = int(req.get('start_month', None))
    day = int(req.get('start_day', None))
    insts = req.getlist('instruments[]', None)
#    print form_name, input_keys, data_amount, year, month, day, insts, selected_key
    
    select_column = []
    
    file_name = request.session['file_name']
    data = csv.DictReader(open(file_name))
    for row in data:
        select_column.append(row[selected_key])
#    print data[selected_key]
#    print select_column
#    print year, month, day
#    print insts
#    print data_amount
    mongo_data = {}
    for currency in insts:
        cursor = get_currency_candles(currency=currency, start=datetime.datetime(year=year, month=month, day=day))
        cnt = 0
        mongo_data[currency] = []
        for row in cursor:
            mongo_data[currency].append(row['closeMid'])
            cnt += 1
            if cnt >= data_amount: break
#        print '------------'
#        print currency, len(mongo_data[currency])
        # print mongo_data[currency]
        
#        print '------------'

    mat = []
    header = [selected_key]
    for currency in insts:
        header.append(currency)
    mat.append(','.join(header) + '\n')
    
    
    for i in range(0, data_amount - 1):
        print i
        line = [select_column[i]]
        for currency in insts:
            line.append(mongo_data[currency][i])
        mat.append(','.join(str(x) for x in line) + '\n')
#    print mat
    st = stepwise_regression(mat, selected_key, insts)
    
    res = filter(lambda f: len(str(f)) > 1, st.split())
    print res
    # stub here
    ret = {}
    for i in range(1, len(res)-5):
        if len(str(res[i]))==7:
            print i
            print res[i], res[i+5]
            ret[res[i]] = res[i+5]
    print '------------------'
    print ret
    print '------------------'

    return HttpResponse(json.dumps(ret))