1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
from django.core.exceptions import FieldError
from django.test import TestCase
from models import Author, Article
class CustomColumnsTests(TestCase):
def test_db_column(self):
a1 = Author.objects.create(first_name="John", last_name="Smith")
a2 = Author.objects.create(first_name="Peter", last_name="Jones")
art = Article.objects.create(headline="Django lets you build web apps easily")
art.authors = [a1, a2]
# Although the table and column names on Author have been set to custom
# values, nothing about using the Author model has changed...
# Query the available authors
self.assertQuerysetEqual(
Author.objects.all(), [
"Peter Jones", "John Smith",
],
unicode
)
self.assertQuerysetEqual(
Author.objects.filter(first_name__exact="John"), [
"John Smith",
],
unicode
)
self.assertEqual(
Author.objects.get(first_name__exact="John"),
a1,
)
self.assertRaises(FieldError,
lambda: Author.objects.filter(firstname__exact="John")
)
a = Author.objects.get(last_name__exact="Smith")
a.first_name = "John"
a.last_name = "Smith"
self.assertRaises(AttributeError, lambda: a.firstname)
self.assertRaises(AttributeError, lambda: a.last)
# Although the Article table uses a custom m2m table,
# nothing about using the m2m relationship has changed...
# Get all the authors for an article
self.assertQuerysetEqual(
art.authors.all(), [
"Peter Jones",
"John Smith",
],
unicode
)
# Get the articles for an author
self.assertQuerysetEqual(
a.article_set.all(), [
"Django lets you build web apps easily",
],
lambda a: a.headline
)
# Query the authors across the m2m relation
self.assertQuerysetEqual(
art.authors.filter(last_name='Jones'), [
"Peter Jones"
],
unicode
)
|
