diff options
author | Nishanth Amuluru | 2011-01-11 22:41:51 +0530 |
---|---|---|
committer | Nishanth Amuluru | 2011-01-11 22:41:51 +0530 |
commit | b03203c8cb991c16ac8a3d74c8c4078182d0bb48 (patch) | |
tree | 7cf13b2deacbfaaec99edb431b83ddd5ea734a52 /parts/django/tests/regressiontests/expressions_regress | |
parent | 0c50203cd9eb94b819883c3110922e873f003138 (diff) | |
download | pytask-b03203c8cb991c16ac8a3d74c8c4078182d0bb48.tar.gz pytask-b03203c8cb991c16ac8a3d74c8c4078182d0bb48.tar.bz2 pytask-b03203c8cb991c16ac8a3d74c8c4078182d0bb48.zip |
removed all the buildout files
Diffstat (limited to 'parts/django/tests/regressiontests/expressions_regress')
3 files changed, 0 insertions, 207 deletions
diff --git a/parts/django/tests/regressiontests/expressions_regress/__init__.py b/parts/django/tests/regressiontests/expressions_regress/__init__.py deleted file mode 100644 index e69de29..0000000 --- a/parts/django/tests/regressiontests/expressions_regress/__init__.py +++ /dev/null diff --git a/parts/django/tests/regressiontests/expressions_regress/models.py b/parts/django/tests/regressiontests/expressions_regress/models.py deleted file mode 100644 index f2997ee..0000000 --- a/parts/django/tests/regressiontests/expressions_regress/models.py +++ /dev/null @@ -1,12 +0,0 @@ -""" -Model for testing arithmetic expressions. -""" -from django.db import models - -class Number(models.Model): - integer = models.IntegerField(db_column='the_integer') - float = models.FloatField(null=True, db_column='the_float') - - def __unicode__(self): - return u'%i, %.3f' % (self.integer, self.float) - diff --git a/parts/django/tests/regressiontests/expressions_regress/tests.py b/parts/django/tests/regressiontests/expressions_regress/tests.py deleted file mode 100644 index a662728..0000000 --- a/parts/django/tests/regressiontests/expressions_regress/tests.py +++ /dev/null @@ -1,195 +0,0 @@ -""" -Spanning tests for all the operations that F() expressions can perform. -""" -from django.test import TestCase, Approximate - -from django.conf import settings -from django.db import models, DEFAULT_DB_ALIAS -from django.db.models import F - -from regressiontests.expressions_regress.models import Number - -class ExpressionsRegressTests(TestCase): - - def setUp(self): - Number(integer=-1).save() - Number(integer=42).save() - Number(integer=1337).save() - self.assertEqual(Number.objects.update(float=F('integer')), 3) - - def test_fill_with_value_from_same_object(self): - """ - We can fill a value in all objects with an other value of the - same object. - """ - self.assertQuerysetEqual( - Number.objects.all(), - [ - '<Number: -1, -1.000>', - '<Number: 42, 42.000>', - '<Number: 1337, 1337.000>' - ] - ) - - def test_increment_value(self): - """ - We can increment a value of all objects in a query set. - """ - self.assertEqual( - Number.objects.filter(integer__gt=0) - .update(integer=F('integer') + 1), - 2) - - self.assertQuerysetEqual( - Number.objects.all(), - [ - '<Number: -1, -1.000>', - '<Number: 43, 42.000>', - '<Number: 1338, 1337.000>' - ] - ) - - def test_filter_not_equals_other_field(self): - """ - We can filter for objects, where a value is not equals the value - of an other field. - """ - self.assertEqual( - Number.objects.filter(integer__gt=0) - .update(integer=F('integer') + 1), - 2) - self.assertQuerysetEqual( - Number.objects.exclude(float=F('integer')), - [ - '<Number: 43, 42.000>', - '<Number: 1338, 1337.000>' - ] - ) - - def test_complex_expressions(self): - """ - Complex expressions of different connection types are possible. - """ - n = Number.objects.create(integer=10, float=123.45) - self.assertEqual(Number.objects.filter(pk=n.pk) - .update(float=F('integer') + F('float') * 2), - 1) - - self.assertEqual(Number.objects.get(pk=n.pk).integer, 10) - self.assertEqual(Number.objects.get(pk=n.pk).float, Approximate(256.900, places=3)) - -class ExpressionOperatorTests(TestCase): - def setUp(self): - self.n = Number.objects.create(integer=42, float=15.5) - - def test_lefthand_addition(self): - # LH Addition of floats and integers - Number.objects.filter(pk=self.n.pk).update( - integer=F('integer') + 15, - float=F('float') + 42.7 - ) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 57) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(58.200, places=3)) - - def test_lefthand_subtraction(self): - # LH Subtraction of floats and integers - Number.objects.filter(pk=self.n.pk).update(integer=F('integer') - 15, - float=F('float') - 42.7) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 27) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(-27.200, places=3)) - - def test_lefthand_multiplication(self): - # Multiplication of floats and integers - Number.objects.filter(pk=self.n.pk).update(integer=F('integer') * 15, - float=F('float') * 42.7) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 630) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(661.850, places=3)) - - def test_lefthand_division(self): - # LH Division of floats and integers - Number.objects.filter(pk=self.n.pk).update(integer=F('integer') / 2, - float=F('float') / 42.7) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 21) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(0.363, places=3)) - - def test_lefthand_modulo(self): - # LH Modulo arithmetic on integers - Number.objects.filter(pk=self.n.pk).update(integer=F('integer') % 20) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 2) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(15.500, places=3)) - - def test_lefthand_bitwise_and(self): - # LH Bitwise ands on integers - Number.objects.filter(pk=self.n.pk).update(integer=F('integer') & 56) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 40) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(15.500, places=3)) - - if settings.DATABASES[DEFAULT_DB_ALIAS]['ENGINE'] != 'django.db.backends.oracle': - def test_lefthand_bitwise_or(self): - # LH Bitwise or on integers - Number.objects.filter(pk=self.n.pk).update(integer=F('integer') | 48) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 58) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(15.500, places=3)) - - def test_right_hand_addition(self): - # Right hand operators - Number.objects.filter(pk=self.n.pk).update(integer=15 + F('integer'), - float=42.7 + F('float')) - - # RH Addition of floats and integers - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 57) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(58.200, places=3)) - - def test_right_hand_subtraction(self): - Number.objects.filter(pk=self.n.pk).update(integer=15 - F('integer'), - float=42.7 - F('float')) - - # RH Subtraction of floats and integers - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, -27) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(27.200, places=3)) - - def test_right_hand_multiplication(self): - # RH Multiplication of floats and integers - Number.objects.filter(pk=self.n.pk).update(integer=15 * F('integer'), - float=42.7 * F('float')) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 630) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(661.850, places=3)) - - def test_right_hand_division(self): - # RH Division of floats and integers - Number.objects.filter(pk=self.n.pk).update(integer=640 / F('integer'), - float=42.7 / F('float')) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 15) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(2.755, places=3)) - - def test_right_hand_modulo(self): - # RH Modulo arithmetic on integers - Number.objects.filter(pk=self.n.pk).update(integer=69 % F('integer')) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 27) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(15.500, places=3)) - - def test_right_hand_bitwise_and(self): - # RH Bitwise ands on integers - Number.objects.filter(pk=self.n.pk).update(integer=15 & F('integer')) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 10) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(15.500, places=3)) - - if settings.DATABASES[DEFAULT_DB_ALIAS]['ENGINE'] != 'django.db.backends.oracle': - def test_right_hand_bitwise_or(self): - # RH Bitwise or on integers - Number.objects.filter(pk=self.n.pk).update(integer=15 | F('integer')) - - self.assertEqual(Number.objects.get(pk=self.n.pk).integer, 47) - self.assertEqual(Number.objects.get(pk=self.n.pk).float, Approximate(15.500, places=3)) - |