def test_filtering(self): """test filtering""" today = jdatetime.date.today() jdm_model = jDateModel(date=today) jdm_model.save() #search by year jdm_date = jDateModel.objects.filter(date__year=today.year) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date.year, today.year) #search by string jdm_date = jDateModel.objects.filter(date="%s-%s-%s"%(today.year, today.month, today.day)) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date, today) #save by geregorian date and retrive by jalali date g_2009 = datetime.date(2009,9,9) jd_model = jDateModel(date=g_2009) jd_model.save() jdm_date = jDateModel.objects.filter(date=g_2009) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date, jdatetime.date.fromgregorian(date=g_2009)) jdm_date = jDateModel.objects.filter(date="%s-%s-%s"%(today.year, today.month, today.day)) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date, today) jdm_date = jDateModel.objects.filter(date__in =["%s-%s-%s"%(today.year, today.month, today.day)]) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date, today) try : s= str(jDateModel.objects.filter(date__how =["%s-%s-%s"%(today.year, today.month, today.day)])) except : self.assertTrue(True) #wrong day value with self.assertRaises(exceptions.ValidationError): jDateModel.objects.filter(date="%s-%s-%s"%(today.year, today.month, 35)) #invalid format with self.assertRaises(exceptions.ValidationError): jDateModel.objects.filter(date="%s%s/%s"%(today.year, today.month, 35)) #invalid search with self.assertRaises(ValueError): jDateModel.objects.filter(date__month="12")
def test_filtering(self): """test filtering""" today = jdatetime.date.today() jdm_model = jDateModel(date=today) jdm_model.save() # search by year jdm_date = jDateModel.objects.filter(date__year=today.year) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date.year, today.year) # search by string jdm_date = jDateModel.objects.filter(date="%s-%s-%s" % (today.year, today.month, today.day)) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date, today) # save by geregorian date and retrive by jalali date g_2009 = datetime.date(2009, 9, 9) jd_model = jDateModel(date=g_2009) jd_model.save() jdm_date = jDateModel.objects.filter(date=g_2009) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date, jdatetime.date.fromgregorian(date=g_2009)) jdm_date = jDateModel.objects.filter(date="%s-%s-%s" % (today.year, today.month, today.day)) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date, today) jdm_date = jDateModel.objects.filter(date__in=["%s-%s-%s" % (today.year, today.month, today.day)]) self.assertEqual(len(jdm_date), 1) self.assertEqual(jdm_date[0].date, today) try: s = str(jDateModel.objects.filter(date__how=["%s-%s-%s" % (today.year, today.month, today.day)])) except: self.assertTrue(True) # wrong day value with self.assertRaises(exceptions.ValidationError): jDateModel.objects.filter(date="%s-%s-%s" % (today.year, today.month, 35)) # invalid format with self.assertRaises(exceptions.ValidationError): jDateModel.objects.filter(date="%s%s/%s" % (today.year, today.month, 35)) # invalid search with self.assertRaises(ValueError): jDateModel.objects.filter(date__month="12")
def test_simple_save(self): """test simple function, including saving and retrieving jalali date from database""" jd_model = jDateModel(date=jdatetime.date.today()) jd_model.save() d = jDateModel.objects.filter(date=jdatetime.date.today()) self.assertEqual(d[0].date.togregorian(), datetime.date.today()) jd_model_auto_now = jDateModelAutoNow() jd_model_auto_now.save() self.assertEqual(jd_model_auto_now.date, jdatetime.date.today()) j_date_time = jdatetime.datetime.today() jdt_model = jDateTimeModel(date_time=j_date_time) jdt_model.save() dt = jDateTimeModel.objects.filter(date_time=j_date_time) self.assertEqual(dt[0].date_time.togregorian(), j_date_time.togregorian()) j_date_time_auto_now = jDateTimeModelAutoNow() j_date_time_auto_now.save() self.assertEqual(j_date_time_auto_now.date_time.date(), jdatetime.date.today())
def test_diffrent_saving(self): jd_model = jDateModel(date='1391-01-01') jd_model.save() jd_model = jDateModel(date=datetime.datetime.now()) jd_model.save() #jd_model = jDateModel() #jd_model.save() jd_model = jDateModel(date=jdatetime.datetime.now()) jd_model.save() #to_python jdt_model = jDateTimeModel(date_time='1391-01-01') #TODO: Find the correct exceptions #with self.assertRaises(Exception): # jdt_model.date_time = None jdt_model.date_time = datetime.datetime(1390,01,02) jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time=datetime.datetime(1390,01,02))[0].date_time , jdt_model.date_time) jdt_model.date_time = jdatetime.date.today() jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time=jdatetime.date.today())[0].date_time, jdt_model.date_time) jdt_model.date_time = datetime.date.today() jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time=datetime.date.today())[0].date_time, jdt_model.date_time) jdt_model.date_time = datetime.date(1390,01,01) jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time=jdatetime.date(1390,01,01))[0].date_time, jdt_model.date_time) jdt_model.date_time = '1391-01-01 12:12' jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time=jdatetime.datetime(1391,01,01,12,12))[0].date_time, jdt_model.date_time) jdt_model.date_time = '1391-01-01 12:12:12' jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time=jdatetime.datetime(1391,01,01,12,12,12))[0].date_time, jdt_model.date_time) jdt_model.date_time = '2012-01-01 12:12' jdt_model.save() #TODO: fixme, I'm broken ! I dunno if I ever should be exist #self.assertEqual(jDateTimeModel.objects.filter(date_time=datetime.datetime(2012, 01, 01, 12, 12))[0].date_time, jdt_model.date_time) self.assertEqual(jDateTimeModel.objects.filter(date_time='2012-01-01 12:12')[0].date_time, jdatetime.datetime(1390, 10, 11, 12, 12)) jdt_model.date_time = '2012-01-01' jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time='2012-01-01')[0].date_time, jdatetime.datetime(1390, 10, 11)) jdt_model.date_time = '2012-01-01 12:12:12' jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time='2012-01-01 12:12:12')[0].date_time, jdatetime.datetime(1390, 10, 11, 12, 12, 12)) jdt_model.date_time = '1391-01-01 12:12:12.2222' jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time = '1391-01-01 12:12:12.2222')[0] , jdt_model)
def test_diffrent_saving(self): jd_model = jDateModel(date="1391-01-01") jd_model.save() jd_model = jDateModel(date=datetime.datetime.now()) jd_model.save() # jd_model = jDateModel() # jd_model.save() jd_model = jDateModel(date=jdatetime.datetime.now()) jd_model.save() # to_python jdt_model = jDateTimeModel(date_time="1391-01-01") # TODO: Find the correct exceptions # with self.assertRaises(Exception): # jdt_model.date_time = None jdt_model.date_time = datetime.datetime(1390, 01, 02) jdt_model.save() self.assertEqual( jDateTimeModel.objects.filter(date_time=datetime.datetime(1390, 01, 02))[0].date_time, jdt_model.date_time ) jdt_model.date_time = jdatetime.date.today() jdt_model.save() self.assertEqual( jDateTimeModel.objects.filter(date_time=jdatetime.date.today())[0].date_time, jdt_model.date_time ) jdt_model.date_time = datetime.date.today() jdt_model.save() self.assertEqual( jDateTimeModel.objects.filter(date_time=datetime.date.today())[0].date_time, jdt_model.date_time ) jdt_model.date_time = datetime.date(1390, 01, 01) jdt_model.save() self.assertEqual( jDateTimeModel.objects.filter(date_time=jdatetime.date(1390, 01, 01))[0].date_time, jdt_model.date_time ) jdt_model.date_time = "1391-01-01 12:12" jdt_model.save() self.assertEqual( jDateTimeModel.objects.filter(date_time=jdatetime.datetime(1391, 01, 01, 12, 12))[0].date_time, jdt_model.date_time, ) jdt_model.date_time = "1391-01-01 12:12:12" jdt_model.save() self.assertEqual( jDateTimeModel.objects.filter(date_time=jdatetime.datetime(1391, 01, 01, 12, 12, 12))[0].date_time, jdt_model.date_time, ) jdt_model.date_time = "2012-01-01 12:12" jdt_model.save() # TODO: fixme, I'm broken ! I dunno if I ever should be exist # self.assertEqual(jDateTimeModel.objects.filter(date_time=datetime.datetime(2012, 01, 01, 12, 12))[0].date_time, jdt_model.date_time) self.assertEqual( jDateTimeModel.objects.filter(date_time="2012-01-01 12:12")[0].date_time, jdatetime.datetime(1390, 10, 11, 12, 12), ) jdt_model.date_time = "2012-01-01" jdt_model.save() self.assertEqual( jDateTimeModel.objects.filter(date_time="2012-01-01")[0].date_time, jdatetime.datetime(1390, 10, 11) ) jdt_model.date_time = "2012-01-01 12:12:12" jdt_model.save() self.assertEqual( jDateTimeModel.objects.filter(date_time="2012-01-01 12:12:12")[0].date_time, jdatetime.datetime(1390, 10, 11, 12, 12, 12), ) jdt_model.date_time = "1391-01-01 12:12:12.2222" jdt_model.save() self.assertEqual(jDateTimeModel.objects.filter(date_time="1391-01-01 12:12:12.2222")[0], jdt_model)