我想使用 django python ORM 獲取所有有時間在接下來的 5 秒記憶體活的物件。我正在嘗試以下方式,但我不知道為什么這不起作用或我做錯了什么......
查詢集.py
def ttl_expire_list(self):
query = self.filter(is_remove=False,ttl__range=[timezone.now() timedelta(seconds=5), timezone.now()]).order_by("-ttl")
# query = self.filter(is_remove=False).order_by("-ttl")
return query'
模型.py
class Notification(models.Model):
sender = models.CharField(_("Sender"), max_length=100,null=True,blank=True)
receiver = models.CharField(_("Receiver"), max_length=100,null=True,blank=True)
message = models.TextField(_("Message"),null=True,blank=True)
is_read = models.BooleanField(_("Read") ,default=False,null=True,blank=True)
ttl = models.DateTimeField(_("Time to live"),null=True,blank=True)
create_time = models.DateTimeField(_("Created Time"), default = timezone.now)
解決方案
def ttl_expire_list(self):
print("curen",timezone.now())
print("imte :",timezone.now() timedelta(seconds=5))
query = self.filter(is_remove=False,ttl__range=(timezone.now() , timezone.now() timedelta(seconds=50))).order_by("-ttl")
return query
uj5u.com熱心網友回復:
范圍的第一個引數應該是開始日期,然后結束日期只是交換引數:
ttl__range=[timezone.now(), timezone.now() timedelta(seconds=5)]
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/408773.html
標籤:
