如何在Django中基于给定模型结构从数据库获取正确结果？

Great question! Let's walk through some common query scenarios for your Django model setup, including how to handle relationships efficiently. I'll cover the most useful cases with clear code examples:

1. Fetch a NewFeature with all related Details and Groups (Eager Loading) #

To avoid the N+1 query problem (where Django makes a separate query for each related object), use select_related for ForeignKey relationships and prefetch_related for ManyToMany:

from django.db.models import Prefetch

# Get a single feature with all its details and linked groups
feature = NewFeature.objects.select_related('newfeaturedetails_set').prefetch_related('groups').get(id=1)

# Filter details to only fetch a specific culture (e.g., English) using Prefetch
en_details = Prefetch('newfeaturedetails_set', queryset=NewFeatureDetails.objects.filter(culture='en'))
feature = NewFeature.objects.prefetch_related(en_details, 'groups').get(id=1)

Pro Tip: To make reverse relationships more readable, add related_name='details' to the new_feature ForeignKey in NewFeatureDetails:

new_feature = models.ForeignKey(to=NewFeature, related_name='details')

Then you can access details as feature.details.all() instead of the default feature.newfeaturedetails_set.all().

2. Filter NewFeatures by Application Name #

# Get all features for a specific application
features = NewFeature.objects.filter(application='MyDashboardApp')

# Combine with eager loading to avoid extra queries later
features = NewFeature.objects.filter(application='MyDashboardApp').select_related('details').prefetch_related('groups')

3. Get Localized Details for a Feature #

# Fetch English details for a specific feature
en_details = NewFeatureDetails.objects.filter(new_feature__id=1, culture='en').first()

# Get all details across features for a specific culture (e.g., French)
all_fr_details = NewFeatureDetails.objects.filter(culture='fr').select_related('new_feature')

4. Find Features Linked to a Specific Group #

from myapp.models import Group

# Get all features associated with a group named "Beta Testers"
beta_group = Group.objects.get(name='Beta Testers')
beta_features = NewFeature.objects.filter(groups=beta_group)

# Or query directly using the group's ID
beta_features = NewFeature.objects.filter(groups__id=beta_group.id)

5. Fetch Active Features #

Assuming "active" means the feature has started and hasn't ended yet:

from django.utils import timezone

now = timezone.now()
# Features that started before now and end after now
active_features = NewFeature.objects.filter(start__lte=now, stop__gte=now)

# Include features that started but never expire (stop is null)
active_features = NewFeature.objects.filter(
    start__lte=now,
    stop__isnull=True
) | NewFeature.objects.filter(
    start__lte=now,
    stop__gte=now
)

6. Create a NewFeature with Related Details and Groups #

import timezone

# Create the base feature
new_feature = NewFeature.objects.create(
    application='MyDashboardApp',
    name='Real-Time Notifications',
    start=timezone.now()
)

# Link existing groups to the feature
group1 = Group.objects.get(id=1)
group2 = Group.objects.get(id=2)
new_feature.groups.add(group1, group2)

# Add localized details
NewFeatureDetails.objects.create(
    new_feature=new_feature,
    culture='en',
    text='Get instant alerts for important updates.'
)
NewFeatureDetails.objects.create(
    new_feature=new_feature,
    culture='es',
    text='Recibe alertas instantáneas para actualizaciones importantes.'
)

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