python - 问题正则表达式，如何使用搜索表单处理带有可选参数的多个查看 URL

Question

几周以来，我一直在尝试学习 Django，但此时我完全迷失了。我对正则表达式了解不多，也看不出我的错误在哪里。

我构建了一个在不同学科领域进行研究的应用程序。我用模板和 url 创建了第一个视图 (view.index_cleint)。在学习使用正则表达式管理 URL 的过程中，我决定使用不同的查询过滤器制作另一个视图 (view.test_api)。（我有 2 个模板链接到 2 个不同的视图以显示每个正确的信息）。

这是带有正则表达式的 URL 文件：

from django.urls import path, re_path
from . import views

urlpatterns = [
    path('search/', views.index_client, name='dashboard'),
    re_path('^search/(?P<param>\w+)/$', views.index_client, name='dashboard'),
    path('dash/', views.test_api, name='test_dash'),
    re_path('^dash/(?P<param>\w+)/$', views.test_api, name='test_dash'),
   ]

前两个网址用于我的视图 1 并用于处理搜索表单。两个鞋楦用于我的第二个视图并处理搜索表单。

这是我的第一个视图的代码：

def index_client(request, param='company_name'):
    print("test all")

    if request.method == 'GET' and 'q' in request.GET:
        query = request.GET['q']
        if query is None or query == '':
            query = ''
    else:
        query = ''

    list_param_query = ['company_name', 'email', 'status', 'id']

    if param not in list_param_query:
        param = 'company_name'
    url_param = param + '/'

    try:
        last_update_obj = UpdateDatabase.objects.latest('last_update')
    except UpdateDatabase.DoesNotExist:
        diff_date = None
        hours = 0
        minutes = 0
        seconds = 0
        print("No last_update in database")
    else:
        last_update = last_update_obj.last_update
        date_now = timezone.now()
        diff_date = date_now - last_update
        days, seconds = diff_date.days, diff_date.seconds
        hours = days * 24 + seconds // 3600
        minutes = (seconds % 3600) // 60
        seconds = seconds % 60

    try:
        customer_list = Client.objects.filter(
            Q(company_name__contains=query) | Q(email__contains=query)
            | Q(status__contains=query) | Q(first_name__contains=query)
            | Q(last_name__contains=query)).order_by(str(param))
        print(customer_list)
    except Client.DoesNotExist:
        return render(request, 'maintenance/dashboard.html', locals())

    print(customer_list.count())
    page = request.GET.get('page', 1)
    paginator = Paginator(customer_list, 1000)
    try:
        customers = paginator.page(page)
    except PageNotAnInteger:
        customers = paginator.page(1)
    except EmptyPage:
        customers = paginator.page(paginator.num_pages)

    try:
        total_confirmed = Client.objects.filter(status="CONFIRMED").count()
    except Client.DoesNotExist:
        total_confirmed = 0
        print("Error can't count customers")

    if diff_date is not None:
        return render(request, 'maintenance/dashboard.html', {'customers': customers,
                                                                  'total_confirmed': total_confirmed,
                                                                  'diff_date': diff_date, 'hours': hours,
                                                                  'minutes': minutes, 'seconds': seconds})
    return render(request, 'maintenance/dashboard.html', {'customers': customers,
                                                                  'total_confirmed': total_confirmed,
                                                                  'diff_date': diff_date})

这里是我的第二个观点的代码：

def test_api(request, param='company_name'):
    print("test2")

    if request.method == 'GET' and 'q' in request.GET:
        query = request.GET['q']
        if query is None or query == '':
            query = ''
    else:
        query = ''

    list_param_query = ['company_name', 'email', 'status', 'id']

    if param not in list_param_query:
        param = 'company_name'
    url_param = param + '/'

    try:
        last_update_obj = UpdateDatabase.objects.latest('last_update')
    except UpdateDatabase.DoesNotExist:
        diff_date = None
        hours = 0
        minutes = 0
        seconds = 0
        print("No last_update in database")
    else:
        last_update = last_update_obj.last_update
        date_now = timezone.now()
        diff_date = date_now - last_update
        days, seconds = diff_date.days, diff_date.seconds
        hours = days * 24 + seconds // 3600
        minutes = (seconds % 3600) // 60
        seconds = seconds % 60

    try:
        search_1 = Q(status__contains="CONFIRMED")
        customer_list = Client.objects.filter(search_1 &
            Q(company_name__contains=query) | Q(email__contains=query)
            | Q(status__contains=query) | Q(first_name__contains=query)
            | Q(last_name__contains=query)).order_by(str(param))
        print(customer_list)
    except Client.DoesNotExist:
        return render(request, 'maintenance/dashboard_p1.html', locals())

    print(customer_list.count())
    page = request.GET.get('page', 1)
    paginator = Paginator(customer_list, 1000)
    try:
        customers = paginator.page(page)
    except PageNotAnInteger:
        customers = paginator.page(1)
    except EmptyPage:
        customers = paginator.page(paginator.num_pages)

    try:
        total_confirmed = Client.objects.filter(status="CONFIRMED", priority=1).count()
    except Client.DoesNotExist:
        total_confirmed = 0
        print("Error can't count customers")

    if diff_date is not None:
        return render(request, 'maintenance/dashboard_p1.html', {'customers': customers,
                                                                         'total_confirmed': total_confirmed,
                                                                         'diff_date': diff_date, 'hours': hours,
                                                                         'minutes': minutes, 'seconds': seconds})
    return render(request, 'maintenance/dashboard_p1.html', {'customers': customers,
                                                                     'total_confirmed': total_confirmed,
                                                                     'diff_date': diff_date})

如果这是我用于视图的模型：

class Client(models.Model):
    company_name = models.CharField(max_length=100)
    first_name = models.CharField(max_length=100)
    last_name = models.CharField(max_length=100)
    email = models.EmailField(max_length=70, unique=True)
    is_confirmed = models.BooleanField(default=False)
    is_open = models.BooleanField(default=False)
    priority = models.IntegerField(default=0)
    date_open = models.DateTimeField(null=True, blank=True)
    date_confirmed = models.DateTimeField(null=True, blank=True)
    CONFIRMED = 'CONFIRMED'
    WAITING = 'WAITING'
    OPEN = 'OPEN'

    MNT_STATUS = [
        (CONFIRMED, 'Confirmed'),
        (OPEN, 'Open'),
        (WAITING, 'Waiting'),
    ]
    status = models.CharField(
        max_length=11,
        choices=MNT_STATUS,
        default=WAITING,
    )

第一个和第二个视图之间的唯一区别是过滤器可以获取所有优先级为 1 的客户：

在第一个视图中：

    try:
        customer_list = Client.objects.filter(
            Q(company_name__contains=query) | Q(email__contains=query)
            | Q(status__contains=query) | Q(first_name__contains=query)
            | Q(last_name__contains=query)).order_by(str(param))
        print(customer_list)
    except Client.DoesNotExist:
        return render(request, 'maintenance/dashboard.html', locals())

在第二种观点中：

    try:
        search_1 = Q(status__contains="CONFIRMED")
        customer_list = Client.objects.filter(search_1 &
            Q(company_name__contains=query) | Q(email__contains=query)
            | Q(status__contains=query) | Q(first_name__contains=query)
            | Q(last_name__contains=query)).order_by(str(param))
        print(customer_list)
    except Client.DoesNotExist:
        return render(request, 'maintenance/dashboard_p1.html', locals())

在创建我的第二个视图 test_api 并添加最后两个 URL 之前一切正常，当单击我的搜索表单时，我被重定向到我的视图 1 并且搜索成功。

但是，由于我每次从视图 2 中的模板进行研究时都会添加第二个视图，因此会显示视图 1 查询的结果。我不仅得到优先级 1，而且得到所有对象

当我从“127.0.0.1:8000/dash/”（视图 2）进行研究时，我看到了一个 printf(2)，这是我的第二个视图，但查询没有得到尊重，我从视图 1 中得到结果.

你看到我犯了什么错误吗？

提前发送！

标签： pythondjangodjango-viewsdjango-urls

Answer 1

一切似乎都是正确的。我认为问题就在这里search_1 = Q(status__contains="CONFIRMED")。

请向我们展示您的客户模型。（对不起，我不能发表评论）