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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
|
# Copyright (c) Microsoft Corporation.
# Licensed under the BSD license.
import datetime
from django.db import connection
from django.test import TestCase
from django.test.utils import override_settings
from ..models import TimeZone
class TestDateTimeField(TestCase):
def test_iso_week_day(self):
days = {
1: TimeZone.objects.create(date=datetime.datetime(2022, 5, 16)),
2: TimeZone.objects.create(date=datetime.datetime(2022, 5, 17)),
3: TimeZone.objects.create(date=datetime.datetime(2022, 5, 18)),
4: TimeZone.objects.create(date=datetime.datetime(2022, 5, 19)),
5: TimeZone.objects.create(date=datetime.datetime(2022, 5, 20)),
6: TimeZone.objects.create(date=datetime.datetime(2022, 5, 21)),
7: TimeZone.objects.create(date=datetime.datetime(2022, 5, 22)),
}
for k, v in days.items():
self.assertSequenceEqual(TimeZone.objects.filter(date__iso_week_day=k), [v])
class TestDateTimeToDateTimeOffsetMigration(TestCase):
def setUp(self):
# Want this to be a naive datetime so don't want
# to override settings before TimeZone creation
self.time = TimeZone.objects.create()
def tearDown(self):
TimeZone.objects.all().delete()
@override_settings(USE_TZ=True)
def test_datetime_to_datetimeoffset_utc(self):
dt = self.time.date
# Do manual migration from DATETIME2 to DATETIMEOFFSET
# and local time to UTC
with connection.schema_editor() as cursor:
cursor.execute("""
ALTER TABLE [testapp_timezone]
ALTER COLUMN [date] DATETIMEOFFSET;
UPDATE [testapp_timezone]
SET [date] = TODATETIMEOFFSET([date], 0) AT TIME ZONE 'UTC'
""")
dto = TimeZone.objects.get(id=self.time.id).date
try:
self.assertEqual(dt, dto.replace(tzinfo=None))
finally:
# Migrate back to DATETIME2 for other unit tests
with connection.schema_editor() as cursor:
cursor.execute("ALTER TABLE [testapp_timezone] ALTER column [date] datetime2")
@override_settings(USE_TZ=True, TIME_ZONE="Africa/Nairobi")
def test_datetime_to_datetimeoffset_local_timezone(self):
dt = self.time.date
# Do manual migration from DATETIME2 to DATETIMEOFFSET
# and local time to UTC
with connection.schema_editor() as cursor:
cursor.execute("""
ALTER TABLE [testapp_timezone]
ALTER COLUMN [date] DATETIMEOFFSET;
UPDATE [testapp_timezone]
SET [date] = TODATETIMEOFFSET([date], 180) AT TIME ZONE 'UTC'
""")
dto = TimeZone.objects.get(id=self.time.id).date
try:
# Africa/Nairobi (EAT) offset is +03:00
self.assertEqual(dt - datetime.timedelta(hours=3), dto.replace(tzinfo=None))
finally:
# Migrate back to DATETIME2 for other unit tests
with connection.schema_editor() as cursor:
cursor.execute("ALTER TABLE [testapp_timezone] ALTER column [date] datetime2")
@override_settings(USE_TZ=True, TIME_ZONE="Africa/Nairobi")
def test_datetime_to_datetimeoffset_other_timezone(self):
dt = self.time.date
# Do manual migration from DATETIME2 to DATETIMEOFFSET
# and local time to UTC
with connection.schema_editor() as cursor:
cursor.execute("""
ALTER TABLE [testapp_timezone]
ALTER COLUMN [date] DATETIMEOFFSET;
UPDATE [testapp_timezone]
SET [date] = TODATETIMEOFFSET([date], 420) AT TIME ZONE 'UTC'
""")
dto = TimeZone.objects.get(id=self.time.id).date
try:
self.assertEqual(dt - datetime.timedelta(hours=7), dto.replace(tzinfo=None))
finally:
# Migrate back to DATETIME2 for other unit tests
with connection.schema_editor() as cursor:
cursor.execute("ALTER TABLE [testapp_timezone] ALTER column [date] datetime2")
|
