处理Django模型

Question

我正在尝试处理TradeOrder模型数据库中的查询：

class TradeOrder(models.Model):
    #denoted in 2 three letter tickers with underscore such as anc_btc
    pair = models.CharField(max_length=50)
    #buy_order or sell_order
    order_type = models.CharField(max_length=50)
    #number e.g. .3455 or .190  
    trade_rate = models.PositiveIntegerField()
    trade_amount = models.PositiveIntegerField()
    #name of the account
    trade_order_account = models.CharField(max_length=50)

    def __str__(self):
        return '%s %s %s %s %s'  % (self.pair, self.order_type, self.trade_rate, self.trade_amount, self.trade_order_account)

当我在视图.py对于我的应用程序

buyorders=TradeOrder.objects.filter(pair="anc_btc", order_type="buy_order")

我得到的列表如下：

[<TradeOrder: anc_btc buy_order 7987 7897 a>, <TradeOrder: anc_btc buy_order 7897 789 a>, <TradeOrder: anc_btc buy_order 7897 789 a>]

因此，我们首先要处理和细化这些数据，将每个项目与新订单进行比较

比如：

            if new_order_type=="buy_order":
                #crosscheck against sell orders
                market_sell_orders = TradeOrder.objects.filter(pair="anc_btc", order_type="sell_order", trade_order_account=price)
                #now i need to sort the orders for trade rates above/greater than $new_order_price
                #how do i do this?

我现在知道，这可以通过添加.order_by('trade_order_price')来实现 到查询的结尾

                if potential_sell_orders is not None:
                #trade
                    do=1
                else: 
                    #no sell orders to fill, submit to order book
                    try:
                        tradeordersubmit=TradeOrder(pair=order_pair, order_type=order_type, trade_rate=price, trade_amount=quantity, trade_order_account=request.user.username) 
                        tradeordersubmit.save()
                        order_error=0
                    except:
                        order_error="1"

Answer 1

now i need to sort the orders for trade rates above/greater than $new_order_price

您应该使用QuerySet方法适当地优化QuerySet：

 market_sell_orders = TradeOrder.objects.filter(pair="anc_btc", order_type="sell_order", trade_order_account=price, trade_rate__gt=<trade_rate>).order_by('-trade_rate')

您可以找到QuerySethere的教程