django_orm_crud_filter_and_queryset_operations_quickstart.py

1from blog.models import Blog, Entry
2from datetime import date
3
4# 1. Create and Save an object
5b = Blog(name="Beatles Blog", tagline="All the latest Beatles news.")
6b.save()
7
8# 2. Retrieve all objects
9all_entries = Entry.objects.all()
10
11# 3. Filter objects by attributes
12entry_list = Entry.objects.filter(pub_date__year=2006)
13
14# 4. Chaining filters
15chained_list = Entry.objects.filter(
16    headline__startswith="What"
17).exclude(
18    pub_date__gte=date.today()
19).filter(
20    pub_date__gte=date(2005, 1, 1)
21)
22
23# 5. Retrieving a single object with get()
24one_entry = Entry.objects.get(pk=1)
25
26# 6. Updating objects
27b.name = "New name"
28b.save()
29
30# 7. Slicing QuerySets (Limiting results)
31top_five = Entry.objects.all()[:5]