Debian Codegraph @

tests/db_typecasts/tests.py

raw
1 # Unit tests for typecast functions in django.db.backends.util
2
3 import datetime
4 import unittest
5
6 from django.db.backends import utils as typecasts
7
8 TEST_CASES = {
9 "typecast_date": (
10 ("", None),
11 (None, None),
12 ("2005-08-11", datetime.date(2005, 8, 11)),
13 ("1990-01-01", datetime.date(1990, 1, 1)),
14 ),
15 "typecast_time": (
16 ("", None),
17 (None, None),
18 ("0:00:00", datetime.time(0, 0)),
19 ("0:30:00", datetime.time(0, 30)),
20 ("8:50:00", datetime.time(8, 50)),
21 ("08:50:00", datetime.time(8, 50)),
22 ("12:00:00", datetime.time(12, 00)),
23 ("12:30:00", datetime.time(12, 30)),
24 ("13:00:00", datetime.time(13, 00)),
25 ("23:59:00", datetime.time(23, 59)),
26 ("00:00:12", datetime.time(0, 0, 12)),
27 ("00:00:12.5", datetime.time(0, 0, 12, 500000)),
28 ("7:22:13.312", datetime.time(7, 22, 13, 312000)),
29 ("12:45:30.126631", datetime.time(12, 45, 30, 126631)),
30 ("12:45:30.126630", datetime.time(12, 45, 30, 126630)),
31 ("12:45:30.123456789", datetime.time(12, 45, 30, 123456)),
32 ),
33 "typecast_timestamp": (
34 ("", None),
35 (None, None),
36 ("2005-08-11 0:00:00", datetime.datetime(2005, 8, 11)),
37 ("2005-08-11 0:30:00", datetime.datetime(2005, 8, 11, 0, 30)),
38 ("2005-08-11 8:50:30", datetime.datetime(2005, 8, 11, 8, 50, 30)),
39 ("2005-08-11 8:50:30.123", datetime.datetime(2005, 8, 11, 8, 50, 30, 123000)),
40 ("2005-08-11 8:50:30.9", datetime.datetime(2005, 8, 11, 8, 50, 30, 900000)),
41 (
42 "2005-08-11 8:50:30.312-05",
43 datetime.datetime(2005, 8, 11, 8, 50, 30, 312000),
44 ),
45 (
46 "2005-08-11 8:50:30.312+02",
47 datetime.datetime(2005, 8, 11, 8, 50, 30, 312000),
48 ),
49 # ticket 14453
50 (
51 "2010-10-12 15:29:22.063202",
52 datetime.datetime(2010, 10, 12, 15, 29, 22, 63202),
53 ),
54 (
55 "2010-10-12 15:29:22.063202-03",
56 datetime.datetime(2010, 10, 12, 15, 29, 22, 63202),
57 ),
58 (
59 "2010-10-12 15:29:22.063202+04",
60 datetime.datetime(2010, 10, 12, 15, 29, 22, 63202),
61 ),
62 (
63 "2010-10-12 15:29:22.0632021",
64 datetime.datetime(2010, 10, 12, 15, 29, 22, 63202),
65 ),
66 (
67 "2010-10-12 15:29:22.0632029",
68 datetime.datetime(2010, 10, 12, 15, 29, 22, 63202),
69 ),
70 ),
71 }
72
73
74 class DBTypeCasts(unittest.TestCase):
75 def test_typeCasts(self):
76 for k, v in TEST_CASES.items():
77 for inpt, expected in v:
78 with self.subTest(k=k, inpt=inpt):
79 got = getattr(typecasts, k)(inpt)
80 self.assertEqual(
81 got,
82 expected,
83 "In %s: %r doesn't match %r. Got %r instead."
84 % (k, inpt, expected, got),
85 )