如何在Django中用icontains查询单条记录？遇500错误求方案

Let's break down your problem first: your model stores full URLs (like https://google.com), but you're trying to query using short names (like google), which leads to a 500 error. The root cause is almost certainly a mismatch between your query criteria and the stored values—most likely using .get() without handling the case where no record is found, which throws an uncaught DoesNotExist exception.

Here are two solid solutions, neither requiring data migrations:

Option 1: Adjust Your Query Logic (No Model Changes) #

Instead of querying for an exact match, use a flexible filter that maps the short name to the full URL. You can make this as precise as needed depending on your URL structure:

Basic Contains Match (Quick & Simple) #

If your short name is always part of the full URL, use __icontains (case-insensitive) to find matches. Always wrap .get() in a try/except block to avoid 500s when no record exists:

from django.http import HttpResponseNotFound
from .models import YourModel

def get_record(short_name):
    try:
        # Match any URL containing the short name
        return YourModel.objects.get(full_url__icontains=short_name)
    except YourModel.DoesNotExist:
        return HttpResponseNotFound("Record not found")
    except YourModel.MultipleObjectsReturned:
        # Handle cases where multiple URLs match the short name
        return HttpResponseBadRequest("Multiple records found for this short name")

Precise Domain Match (More Reliable) #

If your short name corresponds to the domain part of the URL (e.g., google → google.com), parse the stored URLs to extract the domain and match exactly:

from urllib.parse import urlparse
from django.http import HttpResponseNotFound
from .models import YourModel

def get_record(short_name):
    matches = []
    for record in YourModel.objects.all():
        parsed_url = urlparse(record.full_url)
        # Extract the main domain (e.g., "google" from "https://www.google.com")
        domain_parts = parsed_url.netloc.split('.')
        # Handle subdomains like www.google.com
        main_domain = domain_parts[-2] if len(domain_parts) >=2 else domain_parts[0]
        if main_domain == short_name:
            matches.append(record)
    
    if len(matches) == 1:
        return matches[0]
    elif len(matches) > 1:
        return HttpResponseBadRequest("Multiple records found")
    else:
        return HttpResponseNotFound("Record not found")

Option 2: Add a Helper Method to Your Model (Cleaner Code) #

If you need to reuse this logic across your codebase, add a class method to your model. This keeps the query logic tied to the model where it belongs:

from django.db import models
from urllib.parse import urlparse

class YourModel(models.Model):
    full_url = models.URLField()

    @classmethod
    def get_by_short_name(cls, short_name):
        matches = []
        for record in cls.objects.all():
            parsed_url = urlparse(record.full_url)
            domain_parts = parsed_url.netloc.split('.')
            main_domain = domain_parts[-2] if len(domain_parts) >=2 else domain_parts[0]
            if main_domain == short_name:
                matches.append(record)
        
        if len(matches) == 1:
            return matches[0]
        elif len(matches) > 1:
            raise cls.MultipleObjectsReturned(f"Multiple {cls.__name__} records found for short name '{short_name}'")
        else:
            raise cls.DoesNotExist(f"No {cls.__name__} record found for short name '{short_name}'")

Then use it in your views like this (still with error handling to avoid 500s):

from django.http import HttpResponseNotFound
from .models import YourModel

def get_record(request, short_name):
    try:
        record = YourModel.get_by_short_name(short_name)
        # Return your response with the record
    except (YourModel.DoesNotExist, YourModel.MultipleObjectsReturned) as e:
        return HttpResponseNotFound(str(e))

Critical Note About 500 Errors
Always check your Django server logs to confirm the exact error. If it's not a DoesNotExist exception, you might have a different issue (like a database connection problem), but based on your description, the uncaught query exception is the most likely culprit.

内容的提问来源于stack exchange，提问作者david