Debian Codegraph @

tests/postgres_tests/test_bulk_update.py

raw
1 from datetime import date
2
3 from . import PostgreSQLTestCase
4 from .models import (
5 HStoreModel,
6 IntegerArrayModel,
7 NestedIntegerArrayModel,
8 NullableIntegerArrayModel,
9 OffByOneModel,
10 OtherTypesArrayModel,
11 RangesModel,
12 )
13
14 try:
15 from django.db.backends.postgresql.psycopg_any import DateRange, NumericRange
16 except ImportError:
17 pass # psycopg isn't installed.
18
19
20 class BulkSaveTests(PostgreSQLTestCase):
21 def test_bulk_update(self):
22 test_data = [
23 (IntegerArrayModel, "field", [], [1, 2, 3]),
24 (NullableIntegerArrayModel, "field", [1, 2, 3], None),
25 (NestedIntegerArrayModel, "field", [], [[1, 2, 3]]),
26 (HStoreModel, "field", {}, {1: 2}),
27 (RangesModel, "ints", None, NumericRange(lower=1, upper=10)),
28 (
29 RangesModel,
30 "dates",
31 None,
32 DateRange(lower=date.today(), upper=date.today()),
33 ),
34 (OtherTypesArrayModel, "ips", [], ["1.2.3.4"]),
35 (OtherTypesArrayModel, "json", [], [{"a": "b"}]),
36 ]
37 for Model, field, initial, new in test_data:
38 with self.subTest(model=Model, field=field):
39 instances = Model.objects.bulk_create(
40 Model(**{field: initial}) for _ in range(20)
41 )
42 for instance in instances:
43 setattr(instance, field, new)
44 Model.objects.bulk_update(instances, [field])
45 self.assertSequenceEqual(
46 Model.objects.filter(**{field: new}), instances
47 )
48
49 def test_bulk_create(self):
50 OffByOneModel.objects.bulk_create(OffByOneModel(one_off=0) for _ in range(20))
51
52 self.assertSequenceEqual(
53 [m.one_off for m in OffByOneModel.objects.all()], 20 * [1]
54 )