def get_all_orders(self):
"""
Return all orders in the database.
"""
db_result = self.execute(u"SELECT * FROM orders")
return [Order.from_database(db_item, self.get_reserved_ticks(
OrderId(TraderId(str(db_item[0])), OrderNumber(db_item[1])))) for db_item in db_result]
def get_order(self, order_id):
"""
Return an order with a specific id.
"""
try:
db_result = self.execute(u"SELECT * FROM orders WHERE trader_id = ? AND order_number = ?",
(unicode(order_id.trader_id), unicode(order_id.order_number))).next()
except StopIteration:
return None
return Order.from_database(db_result, self.get_reserved_ticks(order_id))
def get_order(self, order_id):
"""
Return an order with a specific id.
"""
db_result = self.execute(
u"SELECT * FROM orders WHERE trader_id = ? AND order_number = ?",
(unicode(order_id.trader_id), unicode(
order_id.order_number))).fetchone()
return Order.from_database(
db_result,
self.get_reserved_ticks(order_id)) if db_result else None
def get_order(self, order_id):
"""
Return an order with a specific id.
"""
try:
db_result = next(self.execute(u"SELECT * FROM orders WHERE trader_id = ? AND order_number = ?",
(database_blob(order_id.trader_id.to_bytes()),
text_type(order_id.order_number))))
except StopIteration:
return None
return Order.from_database(db_result, self.get_reserved_ticks(order_id))
def get_all_orders(self):
"""
Return all orders in the database.
"""
db_result = self.execute(u"SELECT * FROM orders")
return [
Order.from_database(
db_item,
self.get_reserved_ticks(
OrderId(TraderId(str(db_item[0])),
OrderNumber(db_item[1])))) for db_item in db_result
]
def get_order(self, order_id):
"""
Return an order with a specific id.
"""
try:
db_result = self.execute(
u"SELECT * FROM orders WHERE trader_id = ? AND order_number = ?",
(unicode(order_id.trader_id), unicode(
order_id.order_number))).next()
except StopIteration:
return None
return Order.from_database(db_result,
self.get_reserved_ticks(order_id))
def get_order(self, order_id):
"""
Return an order with a specific id.
"""
try:
db_result = next(
self.execute(
u"SELECT * FROM orders WHERE trader_id = ? AND order_number = ?",
(database_blob(order_id.trader_id.to_bytes()),
text_type(order_id.order_number))))
except StopIteration:
return None
return Order.from_database(db_result,
self.get_reserved_ticks(order_id))
