summaryrefslogtreecommitdiff
path: root/tests/update
diff options
context:
space:
mode:
authorFlorian Apolloner <florian@apolloner.eu>2013-02-26 09:53:47 +0100
committerFlorian Apolloner <florian@apolloner.eu>2013-02-26 14:36:57 +0100
commit89f40e36246100df6a11316c31a76712ebc6c501 (patch)
tree6e65639683ddaf2027908d1ecb1739e0e2ff853b /tests/update
parentb3d2ccb5bfbaf6e7fe1f98843baaa48c35a70950 (diff)
Merged regressiontests and modeltests into the test root.
Diffstat (limited to 'tests/update')
-rw-r--r--tests/update/__init__.py0
-rw-r--r--tests/update/models.py40
-rw-r--r--tests/update/tests.py118
3 files changed, 158 insertions, 0 deletions
diff --git a/tests/update/__init__.py b/tests/update/__init__.py
new file mode 100644
index 0000000000..e69de29bb2
--- /dev/null
+++ b/tests/update/__init__.py
diff --git a/tests/update/models.py b/tests/update/models.py
new file mode 100644
index 0000000000..08472d98b1
--- /dev/null
+++ b/tests/update/models.py
@@ -0,0 +1,40 @@
+"""
+Tests for the update() queryset method that allows in-place, multi-object
+updates.
+"""
+
+from django.db import models
+from django.utils import six
+from django.utils.encoding import python_2_unicode_compatible
+
+
+@python_2_unicode_compatible
+class DataPoint(models.Model):
+ name = models.CharField(max_length=20)
+ value = models.CharField(max_length=20)
+ another_value = models.CharField(max_length=20, blank=True)
+
+ def __str__(self):
+ return six.text_type(self.name)
+
+@python_2_unicode_compatible
+class RelatedPoint(models.Model):
+ name = models.CharField(max_length=20)
+ data = models.ForeignKey(DataPoint)
+
+ def __str__(self):
+ return six.text_type(self.name)
+
+
+class A(models.Model):
+ x = models.IntegerField(default=10)
+
+class B(models.Model):
+ a = models.ForeignKey(A)
+ y = models.IntegerField(default=10)
+
+class C(models.Model):
+ y = models.IntegerField(default=10)
+
+class D(C):
+ a = models.ForeignKey(A)
diff --git a/tests/update/tests.py b/tests/update/tests.py
new file mode 100644
index 0000000000..7a1177c1fd
--- /dev/null
+++ b/tests/update/tests.py
@@ -0,0 +1,118 @@
+from __future__ import absolute_import, unicode_literals
+
+from django.test import TestCase
+
+from .models import A, B, C, D, DataPoint, RelatedPoint
+
+
+class SimpleTest(TestCase):
+ def setUp(self):
+ self.a1 = A.objects.create()
+ self.a2 = A.objects.create()
+ for x in range(20):
+ B.objects.create(a=self.a1)
+ D.objects.create(a=self.a1)
+
+ def test_nonempty_update(self):
+ """
+ Test that update changes the right number of rows for a nonempty queryset
+ """
+ num_updated = self.a1.b_set.update(y=100)
+ self.assertEqual(num_updated, 20)
+ cnt = B.objects.filter(y=100).count()
+ self.assertEqual(cnt, 20)
+
+ def test_empty_update(self):
+ """
+ Test that update changes the right number of rows for an empty queryset
+ """
+ num_updated = self.a2.b_set.update(y=100)
+ self.assertEqual(num_updated, 0)
+ cnt = B.objects.filter(y=100).count()
+ self.assertEqual(cnt, 0)
+
+ def test_nonempty_update_with_inheritance(self):
+ """
+ Test that update changes the right number of rows for an empty queryset
+ when the update affects only a base table
+ """
+ num_updated = self.a1.d_set.update(y=100)
+ self.assertEqual(num_updated, 20)
+ cnt = D.objects.filter(y=100).count()
+ self.assertEqual(cnt, 20)
+
+ def test_empty_update_with_inheritance(self):
+ """
+ Test that update changes the right number of rows for an empty queryset
+ when the update affects only a base table
+ """
+ num_updated = self.a2.d_set.update(y=100)
+ self.assertEqual(num_updated, 0)
+ cnt = D.objects.filter(y=100).count()
+ self.assertEqual(cnt, 0)
+
+class AdvancedTests(TestCase):
+
+ def setUp(self):
+ self.d0 = DataPoint.objects.create(name="d0", value="apple")
+ self.d2 = DataPoint.objects.create(name="d2", value="banana")
+ self.d3 = DataPoint.objects.create(name="d3", value="banana")
+ self.r1 = RelatedPoint.objects.create(name="r1", data=self.d3)
+
+ def test_update(self):
+ """
+ Objects are updated by first filtering the candidates into a queryset
+ and then calling the update() method. It executes immediately and
+ returns nothing.
+ """
+ resp = DataPoint.objects.filter(value="apple").update(name="d1")
+ self.assertEqual(resp, 1)
+ resp = DataPoint.objects.filter(value="apple")
+ self.assertEqual(list(resp), [self.d0])
+
+ def test_update_multiple_objects(self):
+ """
+ We can update multiple objects at once.
+ """
+ resp = DataPoint.objects.filter(value="banana").update(
+ value="pineapple")
+ self.assertEqual(resp, 2)
+ self.assertEqual(DataPoint.objects.get(name="d2").value, 'pineapple')
+
+ def test_update_fk(self):
+ """
+ Foreign key fields can also be updated, although you can only update
+ the object referred to, not anything inside the related object.
+ """
+ resp = RelatedPoint.objects.filter(name="r1").update(data=self.d0)
+ self.assertEqual(resp, 1)
+ resp = RelatedPoint.objects.filter(data__name="d0")
+ self.assertEqual(list(resp), [self.r1])
+
+ def test_update_multiple_fields(self):
+ """
+ Multiple fields can be updated at once
+ """
+ resp = DataPoint.objects.filter(value="apple").update(
+ value="fruit", another_value="peach")
+ self.assertEqual(resp, 1)
+ d = DataPoint.objects.get(name="d0")
+ self.assertEqual(d.value, 'fruit')
+ self.assertEqual(d.another_value, 'peach')
+
+ def test_update_all(self):
+ """
+ In the rare case you want to update every instance of a model, update()
+ is also a manager method.
+ """
+ self.assertEqual(DataPoint.objects.update(value='thing'), 3)
+ resp = DataPoint.objects.values('value').distinct()
+ self.assertEqual(list(resp), [{'value': 'thing'}])
+
+ def test_update_slice_fail(self):
+ """
+ We do not support update on already sliced query sets.
+ """
+ method = DataPoint.objects.all()[:2].update
+ self.assertRaises(AssertionError, method,
+ another_value='another thing')