from django.contrib.auth.models import User
from blog.models import Post
from datetime import date

user = User.objects.get(username='admin')
post = Post(title='ブログのタイトル', slug='blog-title', body='body part', author=user)
post.save()

posts = Post.objects.filter(title='search key')
print(posts.query)

Post.objects.filter(id__exact=1)

Post.objects.filter(title__iexact='search key')

Post.objects.filter(title__contains='search key')
Post.objects.filter(id__in=[1,2])
Post.objects.filter(id__gt=3)
Post.objects.filter(id__lt=3)

Post.objects.filter(published_at__date=date(2025,1,1))
Post.objects.filter(published__year=2025)
Post.objects.filter(published__month=4)
Post.objects.filter(published_day=10)
Post.objects.filter(published_at__date__gt=date(2025,1,1))
Post.objects.filter(author__username='admin')

Post.objects.filter(Published_at__year=2025).filter(author__username='admin')
Post.objects.filter(published_at__year=2025).exclude(title='search key')

Post.objects.order_by('-title')
Post.objects.all()[3:6]

Post.objects.filter(id__lt=3).count()
Post.objects.filter(id__lt=3).exists()