def compare_filled_sum():
"""Compare sum of 'Filled' orders"""
responce = Utils.execute_db_query("select sum(price) from orders where status = 'Filled'")
res = 0
for i in Assembler.Data.orders:
if ' - Filled' in i.status or i.status == 'Filled':
res += int(i.price)
return res == list(responce.get_points(measurement = "orders"))[0]["sum"]
def compare_partially_filled():
"""Compare count of 'Partially Filled' orders"""
responce = Utils.execute_db_query("select count(dateTime) from orders where status = 'Partially Filled'")
res = 0
for i in Assembler.Data.orders:
if 'Partially Filled' in i.status:
res += 1
return res == list(responce.get_points(measurement = "orders"))[0]["count"]
def compare_to_provider():
"""Compare count of 'To Provider' orders"""
responce = Utils.execute_db_query("select count(dateTime) from orders where status = 'To Provider'")
res = 0
for i in Assembler.Data.orders:
if 'To Provider' in i.status:
res += 1
return res == list(responce.get_points(measurement = "orders"))[0]["count"]
def compare_statuses():
"""Compare count of all statused orders"""
responce = Utils.execute_db_query("select count(dateTime) from orders group by status")
partially_filled = 0
filled = 0
to_provider = 0
rejected = 0
new = 0
for i in Assembler.Data.orders:
if 'Partially Filled' in i.status:
partially_filled += 1
if ' - Filled' in i.status or i.status == 'Filled':
filled += 1
if 'To Provider' in i.status:
to_provider += 1
if 'Rejected' in i.status:
rejected += 1
if 'New' in i.status:
new += 1
return str(list(responce.get_points(measurement = "orders"))) == "[{u'count': " + str(filled) + ", u'time': u'1970-01-01T00:00:00Z'}, {u'count': " + str(new) + ", u'time': u'1970-01-01T00:00:00Z'}, {u'count': " + str(partially_filled) + ", u'time': u'1970-01-01T00:00:00Z'}, {u'count': " + str(rejected) + ", u'time': u'1970-01-01T00:00:00Z'}, {u'count': " + str(to_provider) + ", u'time': u'1970-01-01T00:00:00Z'}]"
