python-data/my_manager.py at main · kursadaydin/python-data · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110

import abbr as a
import urllib.parse, urllib.request, urllib.error
import xml.etree.ElementTree as ET
import json
from requests import Session
import pandas as pd

from datetime import datetime
import numpy as np
import openpyxl
import os


series = None
startDate = None
endDate = None
aggregationTypes = None
formulas =None
frequency = None


class My_Manager:
    def __init__(self,_series,start_Date, end_Date, aggregation_Types,_formulas,_frequency):
        self.series = _series
        self.startDate = start_Date
        self.endDate =end_Date
        self.aggregationTypes =aggregation_Types
        self.formulas = _formulas
        self.frequency = _frequency

    def convertTime(self,timestamp):
        time = datetime.fromtimestamp(int(timestamp)).strftime('%d-%m-%y')
        return time


    def get_data(self):
        temp={}
        url = a.MAIN_PART
        path ='{}series={}&startDate={}&endDate={}&type=json&key={}&aggregationTypes={}&Formulas={}&Frequency={}'.format(url,self.series,self.startDate,self.endDate,a.API_KEY,self.aggregationTypes,self.formulas,self.frequency)

        #df_path = pd.read_json(path)
        #df = pd.DataFrame(data=df_path, columns=['Tarih','TP_DK_EUR_A_YTL'])

        url_to_open = urllib.request.urlopen(path).read()
        data = json.loads(url_to_open)

        new_series = self.series.replace('.','_') #URL'deki seri adı ile JSON sonuçundaki seri adı farklı geliyor.
        for i in data['items']:
            if i[new_series] == None:
                continue
            #temp['Time'] = self.convertTime(i['UNIXTIME']['$numberLong'])
            #temp['Time'] = (i['Tarih'])
            #temp['Value'] = i[new_series]
            temp[i['Tarih']] = i[new_series]
            #my_np =np.array([[temp['Time']], [temp['Value']]])

        #for x, y in temp.items():
        #    print(x, y)


        return temp

    def exportToExcel(self,data):
        wb = openpyxl.Workbook()
        sheet = wb.active
        sheet.delete_rows(idx=1)
        tempRow = 1
        for x in data.keys():
             tempCell = sheet.cell(row = tempRow, column = 1)
             tempCell.value = x
             tempRow += 1

        tempRow = 1
        for y in data.values():
             tempCell = sheet.cell(row = tempRow, column = 2)
             tempCell.value = y
             tempRow += 1

        path = os.path.abspath(os.getcwd()) + "\\result.xlsx"
        wb.save(path)


        #if url_to_open.ok:
        #    pass
        #else:
        #    if url_to_open.status_code == 400:
        #        pass
        #    else:
        #        raise ConnectionError


        #url_to_open = urllib.request.urlopen(path).read()
        #tree = ET.fromstring(url_to_open)


        #url_to_open = urllib.request.urlopen(path).read()
        #tree = ET.parse(url_to_open)
        #root_node = tree.getroot()
        #lst = root_node.findall('TP_DK_USD_A_YTL')