2
from django.db import models
9
class Article(models.Model):
10
headline = models.CharField(max_length=100, default='Default headline')
11
pub_date = models.DateTimeField()
12
status = models.IntegerField(blank=True, null=True, choices=CHOICES)
13
misc_data = models.CharField(max_length=100, blank=True)
14
article_text = models.TextField()
17
ordering = ('pub_date','headline')
18
# A utf-8 verbose name (Ångström's Articles) to test they are valid.
19
verbose_name = "\xc3\x85ngstr\xc3\xb6m's Articles"
21
def __unicode__(self):
24
class Movie(models.Model):
25
#5218: Test models with non-default primary keys / AutoFields
26
movie_id = models.AutoField(primary_key=True)
27
name = models.CharField(max_length=60)
29
class Party(models.Model):
30
when = models.DateField()
32
class Event(models.Model):
33
when = models.DateTimeField()
35
class Department(models.Model):
36
id = models.PositiveIntegerField(primary_key=True)
37
name = models.CharField(max_length=200)
39
def __unicode__(self):
42
class Worker(models.Model):
43
department = models.ForeignKey(Department)
44
name = models.CharField(max_length=200)
46
def __unicode__(self):
49
__test__ = {'API_TESTS': """
50
(NOTE: Part of the regression test here is merely parsing the model
51
declaration. The verbose_name, in particular, did not always work.)
53
An empty choice field should return None for the display name.
55
>>> from datetime import datetime
56
>>> a = Article(headline="Look at me!", pub_date=datetime.now())
58
>>> a.get_status_display() is None
61
Empty strings should be returned as Unicode
62
>>> a2 = Article.objects.get(pk=a.id)
66
# TextFields can hold more than 4000 characters (this was broken in Oracle).
67
>>> a3 = Article(headline="Really, really big", pub_date=datetime.now())
68
>>> a3.article_text = "ABCDE" * 1000
70
>>> a4 = Article.objects.get(pk=a3.id)
71
>>> len(a4.article_text)
74
# Regression test for #659
76
>>> p = Party.objects.create(when = datetime.datetime(1999, 12, 31))
77
>>> p = Party.objects.create(when = datetime.datetime(1998, 12, 31))
78
>>> p = Party.objects.create(when = datetime.datetime(1999, 1, 1))
79
>>> [p.when for p in Party.objects.filter(when__month=2)]
81
>>> [p.when for p in Party.objects.filter(when__month=1)]
82
[datetime.date(1999, 1, 1)]
83
>>> [p.when for p in Party.objects.filter(when__month=12)]
84
[datetime.date(1999, 12, 31), datetime.date(1998, 12, 31)]
85
>>> [p.when for p in Party.objects.filter(when__year=1998)]
86
[datetime.date(1998, 12, 31)]
88
# Regression test for #8510
89
>>> [p.when for p in Party.objects.filter(when__day='31')]
90
[datetime.date(1999, 12, 31), datetime.date(1998, 12, 31)]
91
>>> [p.when for p in Party.objects.filter(when__month='12')]
92
[datetime.date(1999, 12, 31), datetime.date(1998, 12, 31)]
93
>>> [p.when for p in Party.objects.filter(when__year='1998')]
94
[datetime.date(1998, 12, 31)]
96
# Check that get_next_by_FIELD and get_previous_by_FIELD don't crash when we
97
# have usecs values stored on the database
99
# [It crashed after the Field.get_db_prep_* refactor, because on most backends
100
# DateTimeFields supports usecs, but DateTimeField.to_python didn't recognize
101
# them. (Note that Model._get_next_or_previous_by_FIELD coerces values to
104
>>> e = Event.objects.create(when = datetime.datetime(2000, 1, 1, 16, 0, 0))
105
>>> e = Event.objects.create(when = datetime.datetime(2000, 1, 1, 6, 1, 1))
106
>>> e = Event.objects.create(when = datetime.datetime(2000, 1, 1, 13, 1, 1))
107
>>> e = Event.objects.create(when = datetime.datetime(2000, 1, 1, 12, 0, 20, 24))
108
>>> e.get_next_by_when().when
109
datetime.datetime(2000, 1, 1, 13, 1, 1)
110
>>> e.get_previous_by_when().when
111
datetime.datetime(2000, 1, 1, 6, 1, 1)
113
# Check Department and Worker
114
>>> d = Department(id=10, name='IT')
116
>>> w = Worker(department=d, name='Full-time')