根据管理员批准的帖子过滤Django中的博客帖子

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

class BlogPost(models.Model):
    title = models.CharField(max_length=100)
    content = models.TextField()
    approved = models.BooleanField(default=False)
    author = models.ForeignKey(User, on_delete=models.CASCADE)
    created_at = models.DateTimeField(auto_now_add=True)

from django.shortcuts import render
from .models import BlogPost

def approved_posts(request):
    posts = BlogPost.objects.filter(approved=True)
    return render(request, 'approved_posts.html', {'posts': posts})

{% for post in posts %}
    <h2>{{ post.title }}</h2>
    <p>{{ post.content }}</p>
    <p>Author: {{ post.author.username }}</p>
    <p>Created at: {{ post.created_at }}</p>
{% endfor %}