#!/usr/bin/env python
#-*-coding:utf-8-*-
""" Загружаем историю торгов """
import sys
import init
from datasource import Datasource
ds = Datasource()
ds.switch_datasource('request')
if len(sys.argv) != 3:
print(
"Укажите fin_id и файл с исходниками торгов: \"update.py fin_id source_file\""
)
for row in ds.get_finances({'disabled =': 0}):
print("{rate_category_name} \t{curr_name}: \t{fin_id}".format(**row))
quit()
fin_id = int(sys.argv[1])
if len(ds.get_finances({'disabled =': 0, 'fin_id =': fin_id})) != 1:
print("В БД нет записи fin_id = {}".format(fin_id))
quit()
import os
file_name = str(sys.argv[2])
if not os.path.isfile(file_name):
print("Не найден файл \"{}\"".format(file_name))
quit()
#!/usr/bin/env python
#-*-coding:utf-8-*-
""" Модуль проверки кода """
import init
from datasource import Datasource
ds = Datasource()
ds.switch_datasource('stat')
for fin_row in ds.get_finances({'disabled =': 0}):
[top_rate] = ds.get_top_rate({'RL.fin_id': fin_row['fin_id']})
top_rate['event_dt_dispaly'] = top_rate['event_dt'].strftime(
'%Y.%m.%d %H:%M:%S')
top_rate['change_percent'] = ds.get_change_percent(fin_row['fin_id'])
print(
"{event_dt_dispaly} {curr_name} \tbuy: {buy_price} \tsell: {sell_price}\tchange percent: {change_percent:+05.2f}%"
.format(**top_rate))
