Django学习_简易博客(三)

$ python manage.py shell
>>> from django.contrib.auth.models import User
>>> from blog.models import Post
>>> user = User.objects.get(username='admin')
>>> post = Post(title='Another post',
...             slug='anotjer-post',
...             body='Post bodu.',
...             author=user)
>>> post.save()

>>> post.title = 'New title'
>>> post.save()

>>> all_posts = Post.objects.all()
>>> Post.objects.all()
<QuerySet [<Post: New title>, <Post: zx>]>

>>> Post.objects.filter(publish__year=2019)
<QuerySet [<Post: New title>, <Post: zx>]>
>>> Post.objects.filter(publish__year=2019,author__username='admin')
<QuerySet [<Post: New title>, <Post: zx>]>
>>> Post.objects.filter(publish__year=2019) \
            .filter(author__username='admin')
<QuerySet [<Post: New title>, <Post: zx>]>

>>> Post.objects.filter(publish__year=2019) \
        .exclude(title__startswith='zx')

>>> Post.objects.order_by('title')
<QuerySet [<Post: New title>, <Post: zx>]>
>>> Post.objects.order_by('-title')
<QuerySet [<Post: zx>, <Post: New title>]>

>>> post = Post.objects.get(id=1)
>>> post.delete()
(1, {'blog.Post': 1})

class PublishedManager(models.Manager):
    def get_queryset(self):
        return super(PublishedManager, self) \
            .get_queryset() \
            .filter(status='published')


class Post(models.Model):
    object = models.Manager()
    published = PublishedManager()
    ...

>>> Post.published.filter(title__startswith='zx')
<QuerySet []>