class StockHistory():
def __init__(self):
self.api_bridge = MySQL()
logging.basicConfig(filename='jobs.log', level=logging.DEBUG)
def get_stock_history(self):
raw_data = requests.get(
"http://s.cafef.vn/ajax/bieudokythuat.ashx?symbol=VNINDEX,VN30INDEX,HNX30INDEX,HNXINDEX,VNINDEX&type=compare"
)
str_data = raw_data.content.decode('utf-8')
result = re.findall(r'.*\[(.*?)\].*', str_data)
# print(len(result))
del result[1:3]
with open('stock_history.txt', 'a') as outFile:
outFile.write('\n' + str(datetime.now()) + "***Stock:" +
str(result[1]))
try:
for index, data in enumerate(result):
symbol = self.api_bridge.get_symbol(index)
for ele in re.findall(r'({.*?})', data):
detail = json.loads(ele)
self.api_bridge.insert_stock(detail, symbol)
# sys.exit()
finally:
# close connection
self.api_bridge.close()
class CurrencyHistory():
def __init__(self):
self.api_bridge = MySQL()
def get_currency_history(self):
with open('currency_history.txt', 'a') as outFile:
now = str(datetime.now().date())
raw_data = requests.get(
"https://api.exchangeratesapi.io/history?start_at=2000-01-01&end_at="
+ now + "&symbols=USD")
result = json.loads(raw_data.content.decode('utf-8'))["rates"]
try:
for key, value in result.items():
outFile.write('\n' + str(datetime.now()) + ":**currency:" +
str(key) + ", " + str(value))
self.api_bridge.insert_currency(key,
value["USD"],
symbol="USD")
finally:
# close connection
self.api_bridge.close()