#mysite/news/models.py

from django.db import models

class Reporter(models.Model):

    full_name = models.CharField(max_length=70)

    def __str__(self):

        return self.full_name

class Article(models.Model):

    pub_date = models.DateField()

    headline = models.CharField(max_length=200)

    content = models.TextField()

    reporter = models.ForeignKey(Reporter)

    def __str__(self):

        return self.headline

# 导入模型

>>> from news.models import Reporter, Article

# 查看实例.

>>> Reporter.objects.all()

[]

# 创建一个实例.

>>> r = Reporter(full_name='John Smith')

# 保存对象.

>>> r.save()

# 查看Id.

>>> r.id

1

# 显示数据库的信息.

>>> Reporter.objects.all()

[<Reporter: John Smith>]

# Fields are represented as attributes on the Python object.

>>> r.full_name

'John Smith'

# Django provides a rich database lookup API.

>>> Reporter.objects.get(id=1)

<Reporter: John Smith>

>>> Reporter.objects.get(full_name__startswith='John')

<Reporter: John Smith>

>>> Reporter.objects.get(full_name__contains='mith')

<Reporter: John Smith>

>>> Reporter.objects.get(id=2)

Traceback (most recent call last):

    ...

DoesNotExist: Reporter matching query does not exist.

# Create an article.

>>> from datetime import date

>>> a = Article(pub_date=date.today(), headline='Django is cool',

...     content='Yeah.', reporter=r)

>>> a.save()

# Now the article is in the database.

>>> Article.objects.all()

[<Article: Django is cool>]

# Article objects get API access to related Reporter objects.

>>> r = a.reporter

>>> r.full_name

'John Smith'

# And vice versa: Reporter objects get API access to Article objects.

>>> r.article_set.all()

[<Article: Django is cool>]

# The API follows relationships as far as you need, performing efficient

# JOINs for you behind the scenes.

# This finds all articles by a reporter whose name starts with "John".

>>> Article.objects.filter(reporter__full_name__startswith='John')

[<Article: Django is cool>]

# Change an object by altering its attributes and calling save().

>>> r.full_name = 'Billy Goat'

>>> r.save()

# Delete an object with delete().

>>> r.delete()

#mysite/news/admin.py

from django.contrib import admin

from . import models

admin.site.register(models.Article

#mysite/news/urls.py

from django.conf.urls import url

from . import views

urlpatterns = [

    url(r'^articles/([0-9]{4})/$', views.year_archive),

    url(r'^articles/([0-9]{4})/([0-9]{2})/$', views.month_archive),

    url(r'^articles/([0-9]{4})/([0-9]{2})/([0-9]+)/$', views.article_detail),

]

#mysite/news/views.py

from django.shortcuts import render

from .models import Article

def year_archive(request, year):

    a_list = Article.objects.filter(pub_date__year=year)

    context = {'year': year, 'article_list': a_list}

    return render(request, 'news/year_archive.html', context)