def end(self):
row = self.get_job_project()
dtFrom = datetime.strptime(row["dtFrom"], "%Y-%m-%d")
dtTo = datetime.strptime(row["dtTo"], "%Y-%m-%d")
dr = DateRange(dtFrom,dtTo)
end = dr.get_day(self.start,self.days)
return end
def range_test():
dtFrom = datetime.strptime("2015-09-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-12-31", "%Y-%m-%d")
rozsah = DateRange(dtFrom, dtTo)
lst = rozsah.get_range_days()
print("nalezeno dni:" + str(len(lst)))
for d in lst:
print(str(d))
def range_test():
dtFrom = datetime.strptime("2015-09-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-12-31", "%Y-%m-%d")
rozsah = DateRange(dtFrom,dtTo)
lst = rozsah.get_range_days()
print("nalezeno dni:" + str(len(lst)))
for d in lst:
print(str(d))
def test_kolikaty_after(self):
"""Between 1.10.2015 and 31.10.2015 02.11.2015 should be index=-2"""
dtFrom = datetime.strptime("2015-10-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-10-31", "%Y-%m-%d")
dtRange = DateRange(dtFrom,dtTo)
svatek = datetime.strptime("2015-10-28", "%Y-%m-%d")
dtRange.svatky = [svatek]
index = dtRange.kolikaty(datetime.strptime("2015-11-02", "%Y-%m-%d"))
self.assertEqual(-2,index)
def test_kolikaty_before(self):
"""Between 1.10.2015 and 31.10.2015 30.09.2015 should be index=-1"""
dtFrom = datetime.strptime("2015-10-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-10-31", "%Y-%m-%d")
dtRange = DateRange(dtFrom,dtTo)
svatek = datetime.strptime("2015-10-28", "%Y-%m-%d")
dtRange.svatky = [svatek]
index = dtRange.kolikaty(datetime.strptime("2015-09-30", "%Y-%m-%d"))
self.assertEqual(-1,index)
def test_kolikaty_right(self):
"""Between 1.10.2015 and 31.10.2015 9.10.2015 should be index=6"""
dtFrom = datetime.strptime("2015-10-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-10-31", "%Y-%m-%d")
dtRange = DateRange(dtFrom,dtTo)
svatek = datetime.strptime("2015-10-28", "%Y-%m-%d")
dtRange.svatky = [svatek]
index = dtRange.kolikaty(datetime.strptime("2015-10-09", "%Y-%m-%d"))
self.assertEqual(6,index)
def test_get_range_days(self):
"""Between 1.10.2015 and 31.10.2015 should be 21 working days"""
dtFrom = datetime.strptime("2015-10-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-10-31", "%Y-%m-%d")
dtRange = DateRange(dtFrom,dtTo)
svatek = datetime.strptime("2015-10-28", "%Y-%m-%d")
dtRange.svatky = [svatek]
days = dtRange.get_range_days()
self.assertEqual(21,len(days))
def test_kolikaty_after(self):
"""Between 1.10.2015 and 31.10.2015 02.11.2015 should be index=-2"""
dtFrom = datetime.strptime("2015-10-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-10-31", "%Y-%m-%d")
dtRange = DateRange(dtFrom, dtTo)
svatek = datetime.strptime("2015-10-28", "%Y-%m-%d")
dtRange.svatky = [svatek]
index = dtRange.kolikaty(datetime.strptime("2015-11-02", "%Y-%m-%d"))
self.assertEqual(-2, index)
def test_kolikaty_before(self):
"""Between 1.10.2015 and 31.10.2015 30.09.2015 should be index=-1"""
dtFrom = datetime.strptime("2015-10-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-10-31", "%Y-%m-%d")
dtRange = DateRange(dtFrom, dtTo)
svatek = datetime.strptime("2015-10-28", "%Y-%m-%d")
dtRange.svatky = [svatek]
index = dtRange.kolikaty(datetime.strptime("2015-09-30", "%Y-%m-%d"))
self.assertEqual(-1, index)
def test_kolikaty_right(self):
"""Between 1.10.2015 and 31.10.2015 9.10.2015 should be index=6"""
dtFrom = datetime.strptime("2015-10-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-10-31", "%Y-%m-%d")
dtRange = DateRange(dtFrom, dtTo)
svatek = datetime.strptime("2015-10-28", "%Y-%m-%d")
dtRange.svatky = [svatek]
index = dtRange.kolikaty(datetime.strptime("2015-10-09", "%Y-%m-%d"))
self.assertEqual(6, index)
def test_get_range_days(self):
"""Between 1.10.2015 and 31.10.2015 should be 21 working days"""
dtFrom = datetime.strptime("2015-10-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-10-31", "%Y-%m-%d")
dtRange = DateRange(dtFrom, dtTo)
svatek = datetime.strptime("2015-10-28", "%Y-%m-%d")
dtRange.svatky = [svatek]
days = dtRange.get_range_days()
self.assertEqual(21, len(days))
def job_enddate_test():
sql = "select * from job where id=?"
row = Database().get_one_record(sql,[3,])
job = Job(row)
print(job)
print("end=" + str(job.end))
dtFrom = datetime.strptime("2015-01-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-06-30", "%Y-%m-%d")
rozsah = DateRange(dtFrom,dtTo)
lst = rozsah.get_range_days()
print("nalezeno dni:" + str(len(lst)))
counter = 1
for i,d in enumerate(lst):
if d >= datetime.strptime("2015-01-14", "%Y-%m-%d"):
print(str(counter) + " -> " + str(d))
counter += 1
def job_enddate_test():
sql = "select * from job where id=?"
row = Database().get_one_record(sql, [
3,
])
job = Job(row)
print(job)
print("end=" + str(job.end))
dtFrom = datetime.strptime("2015-01-01", "%Y-%m-%d")
dtTo = datetime.strptime("2015-06-30", "%Y-%m-%d")
rozsah = DateRange(dtFrom, dtTo)
lst = rozsah.get_range_days()
print("nalezeno dni:" + str(len(lst)))
counter = 1
for i, d in enumerate(lst):
if d >= datetime.strptime("2015-01-14", "%Y-%m-%d"):
print(str(counter) + " -> " + str(d))
counter += 1
