class BarTimeTestCase(TestCase): def setUp(self): self.date_string = "1380-08-02" self.datetime = jdatetime.datetime(1380, 8, 2, 12, 12, 12) self.bar_time = BarTime(name="foo time", datetime=self.datetime) self.bar_time.save() def test_save_date(self): self.assertEqual(self.bar_time.datetime, self.datetime) def test_save_specific_datetime(self): BarTime.objects.create(name='Test', datetime='1398-04-31 12:12:12') k = BarTime.objects.filter(datetime='1398-04-31 12:12:12') self.assertEqual(k[0].datetime.day, 31) def test_filter_by_exact_datetime(self): bar_times = BarTime.objects.filter(datetime=self.datetime) self.assertEqual(len(bar_times), 1) @requires_tz_support @skipUnlessDBFeature('has_zoneinfo_database') @override_settings(USE_TZ=True, TIME_ZONE='Asia/Tehran') def test_lookup_date_with_use_tz(self): jdt1 = jdatetime.datetime(1392, 3, 12, 10, 22, 23, 240000, tzinfo=timezone.get_current_timezone()) BarTime.objects.create(name="with timezone", datetime=jdt1) k = BarTime.objects.filter(datetime=jdt1) self.assertEqual(k[0].datetime.strftime('%z'), '+0326') @requires_tz_support @override_settings(USE_TZ=True, TIME_ZONE='Asia/Tehran') def test_lookup_date_with_use_tz_without_explicit_tzinfo(self): jdt1 = jdatetime.datetime(1392, 3, 12, 10, 22, 23, 240000) BarTime.objects.create(name="with timezone", datetime=jdt1) k = BarTime.objects.filter(datetime=jdt1) self.assertEqual(str(k[0].datetime), '1392-03-12 10:22:23.240000+0430') self.assertEqual(k[0].datetime.strftime('%z'), '+0430') @requires_tz_support @override_settings(USE_TZ=False, TIME_ZONE='Asia/Tehran') def test_lookup_date_with_no_tz(self): jdt1 = jdatetime.datetime(1392, 3, 12, 10, 22, 23, 240000) BarTime.objects.create(name="with timezone", datetime=jdt1) k = BarTime.objects.filter(datetime=jdt1) self.assertEqual(str(k[0].datetime), '1392-03-12 10:22:23.240000') self.assertEqual(k[0].datetime.strftime('%z'), '')
class BarTimeTestCase(TestCase): def setUp(self): self.date_string = "1380-08-02" self.datetime = jdatetime.datetime(1380, 8, 2, 12, 12, 12) self.bar_time = BarTime(name="foo time", datetime=self.datetime) self.bar_time.save() def test_save_date(self): self.assertEqual(self.bar_time.datetime, self.datetime) def test_filter_by_exact_datetime(self): bar_times = BarTime.objects.filter(datetime=self.datetime) self.assertEqual(len(bar_times), 1)
class BarTimeTestCase(TestCase): def setUp(self): self.date_string = "1380-08-02" self.datetime = jdatetime.datetime(1380,8,2,12,12,12) self.bar_time = BarTime(name="foo time", datetime=self.datetime) self.bar_time.save() def test_save_date(self): self.assertEqual(self.bar_time.datetime, self.datetime) def test_filter_by_exact_datetime(self): bar_times = BarTime.objects.filter(datetime=self.datetime) self.assertEqual(len(bar_times), 1)
class ExtractTestCase(TestCase): def setUp(self): self.date_string = "1380-08-02" self.datetime = jdatetime.datetime(1380, 8, 2, 12, 12, 12) self.bar_time = BarTime(name="foo time", datetime=self.datetime) self.bar_time.save() def test_extract_month(self): output = "08" item = {'BarMonth': False} try: item = Bar.objects.filter(date="1380-08-02").annotate( BarMonth=Extract('date', 'month')).values('BarMonth')[0] except Exception as e: self.assertEqual(e, None) self.assertEqual(item['BarMonth'], output)
class BarTimeTestCase(TestCase): def setUp(self): self.date_string = "1380-08-02" self.datetime = jdatetime.datetime(1380,8,2,12,12,12) self.bar_time = BarTime(name="foo time", datetime=self.datetime) self.bar_time.save() def test_save_date(self): self.assertEqual(self.bar_time.datetime, self.datetime) def test_filter_by_exact_datetime(self): bar_times = BarTime.objects.filter(datetime=self.datetime) self.assertEqual(len(bar_times), 1) @requires_tz_support @skipUnlessDBFeature('has_zoneinfo_database') @override_settings(USE_TZ=True, TIME_ZONE='Asia/Tehran') def test_lookup_date_with_use_tz(self): jdt1 = jdatetime.datetime(1392, 3, 12, 10, 22, 23, 240000, tzinfo=timezone.get_current_timezone()) m1 = BarTime.objects.create(name="with timezone", datetime=jdt1) k = BarTime.objects.filter(datetime=jdt1) self.assertEqual(k[0].datetime.strftime('%z'), '+0326') @requires_tz_support @override_settings(USE_TZ=True, TIME_ZONE='Asia/Tehran') def test_lookup_date_with_use_tz_without_explicit_tzinfo(self): jdt1 = jdatetime.datetime(1392, 3, 12, 10, 22, 23, 240000) m1 = BarTime.objects.create(name="with timezone", datetime=jdt1) k = BarTime.objects.filter(datetime=jdt1) self.assertEqual(k[0].datetime.strftime('%z'), '+0430') @requires_tz_support @override_settings(USE_TZ=False, TIME_ZONE='Asia/Tehran') def test_lookup_date_with_no_tz(self): jdt1 = jdatetime.datetime(1392, 3, 12, 10, 22, 23, 240000) m1 = BarTime.objects.create(name="with timezone", datetime=jdt1) k = BarTime.objects.filter(datetime=jdt1) self.assertEqual(k[0].datetime.strftime('%z'), '')
class BarTimeTestCase(TestCase): def setUp(self): self.date_string = "1380-08-02" self.datetime = jdatetime.datetime(1380,8,2,12,12,12) self.bar_time = BarTime(name="foo time", datetime=self.datetime) self.bar_time.save() def test_save_date(self): self.assertEqual(self.bar_time.datetime, self.datetime) def test_filter_by_exact_datetime(self): bar_times = BarTime.objects.filter(datetime=self.datetime) self.assertEqual(len(bar_times), 1) @requires_tz_support @skipUnlessDBFeature('has_zoneinfo_database') @override_settings(USE_TZ=True, TIME_ZONE='Asia/Tehran') def test_lookup_date_with_use_tz(self): jdt1 = jdatetime.datetime(1392, 3, 12, 10, 22, 23, 240000, tzinfo=timezone.get_current_timezone()) m1 = BarTime.objects.create(name="with timezone", datetime=jdt1) k = BarTime.objects.filter(datetime=jdt1) self.assertEqual(k[0].datetime.strftime('%z'), '+0326')
def setUp(self): self.date_string = "1380-08-02" self.datetime = jdatetime.datetime(1380, 8, 2, 12, 12, 12) self.bar_time = BarTime(name="foo time", datetime=self.datetime) self.bar_time.save()
def setUp(self): self.date_string = "1380-08-02" self.datetime = jdatetime.datetime(1380,8,2,12,12,12) self.bar_time = BarTime(name="foo time", datetime=self.datetime) self.bar_time.save()