在Django中使用raw 原生SQL查询后,怎么获取查询结果
我希望统计指定条件下,买入和卖出的总和,此sql语句我直接中mysql中执行,可以正确的获取到我想要的结果,但是中django中不知道怎么读取查询的内容,代码如下:
sql = "SELECT sum(CASE WHEN direction = 1 THEN money END ) as buy,sum(CASE WHEN direction = 0 THEN money END) as sell FROM buy_currency WHERE trend_id = '{}' and name ='{}'".format(times, name)
res = Buy_currency.objects.raw(sql)
print(res)
打印的res为:
<RawQuerySet: SELECT sum(CASE WHEN direction = 1 THEN money END ) as buy,sum(CASE WHEN direction = 0 THEN money END) as sell FROM buy_currency WHERE trend_id = '1587385560' and name ='bts'
这个查询用于统计 买入的总和 以及 卖出的总和 可是我怎么从res读取这结果呢