给定以下模型:
from django.db import models
from django.conf import settings
class UserMessage(models.Model):
user = models.ForeignKey(settings.AUTH_USER_MODEL)
path = models.CharField(max_length=255)
message = models.TextField()
并给出以下模型实例:
UserMessage.objects.create(
user=request.user,
path='^/dashboard/(.*)+$',
message='Welcome to your dashboard!'
)
我希望能够根据 UserMessage.path 的值执行当前请求路径的查找。这意味着我需要在查询的右侧有“路径”,例如:
SELECT * FROM user_message WHERE '/dashboard/foo/' ~ path;
然而,Django ORM 的正则表达式查找会产生相反的顺序,例如:
SELECT * FROM user_message WHERE path ~ '/dashboard/foo/';
有没有一种方法可以使用 ORM 查找轻松地扭转这一情况以获得我想要的结果?或者这更适合 .extra() 或自定义查找表达式?
extra()
UserMessage.objects.extra(where=['%s ~ path'], params=[request.path])
自定义查找
模型.py
from django.db.models import Lookup
@models.CharField.register_lookup
class NotEqual(Lookup):
lookup_name = 'test'
def as_postgresql(self, compiler, connection):
lhs, lhs_params = self.process_lhs(compiler, connection)
rhs, rhs_params = self.process_rhs(compiler, connection)
params = lhs_params + rhs_params
return '%s ~ %s' % (rhs, lhs), params
Usage: UserMessages.objects.get(path__test=request.path)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)