Django:基于用户实例检索数据库条目

# models.py
from django.db import models
from django.contrib.auth.models import User

class Article(models.Model):
    title = models.CharField(max_length=100)
    content = models.TextField()
    author = models.ForeignKey(User, on_delete=models.CASCADE)

# views.py
from django.shortcuts import render
from django.contrib.auth.models import User
from .models import Article

def user_articles(request, user_id):
    user = User.objects.get(id=user_id)
    articles = Article.objects.filter(author=user)
    return render(request, 'user_articles.html', {'articles': articles})

# 使用select_related优化一对一或外键关系
articles = Article.objects.select_related('author').filter(author=user)

# 使用prefetch_related优化多对多或多对一关系
articles = Article.objects.prefetch_related('tags').filter(author=user)