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.                     )
About Sign Up Leave Feedback Contact