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'}]"