summaryrefslogtreecommitdiff
path: root/parts/django/tests/modeltests/custom_columns
diff options
context:
space:
mode:
Diffstat (limited to 'parts/django/tests/modeltests/custom_columns')
-rw-r--r--parts/django/tests/modeltests/custom_columns/__init__.py0
-rw-r--r--parts/django/tests/modeltests/custom_columns/models.py40
-rw-r--r--parts/django/tests/modeltests/custom_columns/tests.py71
3 files changed, 0 insertions, 111 deletions
diff --git a/parts/django/tests/modeltests/custom_columns/__init__.py b/parts/django/tests/modeltests/custom_columns/__init__.py
deleted file mode 100644
index e69de29..0000000
--- a/parts/django/tests/modeltests/custom_columns/__init__.py
+++ /dev/null
diff --git a/parts/django/tests/modeltests/custom_columns/models.py b/parts/django/tests/modeltests/custom_columns/models.py
deleted file mode 100644
index 651f8a6..0000000
--- a/parts/django/tests/modeltests/custom_columns/models.py
+++ /dev/null
@@ -1,40 +0,0 @@
-"""
-17. Custom column/table names
-
-If your database column name is different than your model attribute, use the
-``db_column`` parameter. Note that you'll use the field's name, not its column
-name, in API usage.
-
-If your database table name is different than your model name, use the
-``db_table`` Meta attribute. This has no effect on the API used to
-query the database.
-
-If you need to use a table name for a many-to-many relationship that differs
-from the default generated name, use the ``db_table`` parameter on the
-``ManyToManyField``. This has no effect on the API for querying the database.
-
-"""
-
-from django.db import models
-
-class Author(models.Model):
- first_name = models.CharField(max_length=30, db_column='firstname')
- last_name = models.CharField(max_length=30, db_column='last')
-
- def __unicode__(self):
- return u'%s %s' % (self.first_name, self.last_name)
-
- class Meta:
- db_table = 'my_author_table'
- ordering = ('last_name','first_name')
-
-class Article(models.Model):
- headline = models.CharField(max_length=100)
- authors = models.ManyToManyField(Author, db_table='my_m2m_table')
-
- def __unicode__(self):
- return self.headline
-
- class Meta:
- ordering = ('headline',)
-
diff --git a/parts/django/tests/modeltests/custom_columns/tests.py b/parts/django/tests/modeltests/custom_columns/tests.py
deleted file mode 100644
index f38f087..0000000
--- a/parts/django/tests/modeltests/custom_columns/tests.py
+++ /dev/null
@@ -1,71 +0,0 @@
-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
- )