def test_datetime_from_str_p04_match_ts_maintain(self): self.assertEqual(kvdate.datetime_from_str('2021-12-31'), datetime.datetime(2021, 12, 31)) self.assertEqual(kvdate.datetime_from_str('2021-12-31 00:00:00'), datetime.datetime(2021, 12, 31)) self.assertEqual(kvdate.datetime_from_str('12/31/2021'), datetime.datetime(2021, 12, 31)) self.assertEqual(kvdate.datetime_from_str('2021-12-31T00:00:00Z'), datetime.datetime(2021, 12, 31))
def test_datetime_from_str_p02_notzero_padded(self): self.assertEqual(kvdate.datetime_from_str('1/1/19'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('1/1/2019'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('1-1-19'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('1-1-2019'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('2019-1-1'), datetime.datetime(2019, 1, 1))
def xldate_to_datetime(xldate, skipblank=False): if isinstance(xldate, str): logger.debug( 'converting xldate string to date using kvdate.datetime_from_str:%s', xldate) return kvdate.datetime_from_str(xldate, skipblank) else: logger.debug('converting xldate float to date:%s', xldate) temp = datetime.datetime(1899, 12, 30) delta = datetime.timedelta(days=xldate) return temp + delta
def test_datetime_from_str_p01_zero_padded(self): self.assertEqual(kvdate.datetime_from_str('01/01/19'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('01/01/2019'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('01-01-19'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('01-01-2019'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('2019-01-01'), datetime.datetime(2019, 1, 1)) self.assertEqual(kvdate.datetime_from_str('20190101'), datetime.datetime(2019, 1, 1))
def test_datetime_from_str_f03_blank(self): with self.assertRaises(Exception) as context: kvdate.datetime_from_str('')
def test_datetime_from_str_f02_no_matching_format(self): with self.assertRaises(Exception) as context: kvdate.datetime_from_str('1/1/20019')
def test_datetime_from_str_f01_invalid_date(self): with self.assertRaises(Exception) as context: kvdate.datetime_from_str('20/1/19')
def test_datetime_from_str_p03_blank_stripblank(self): self.assertEqual(kvdate.datetime_from_str('', True), '')