def test_algo19_pass(self):
db = Workbook().active
ref = Workbook().active
db.append(("etc", "DD - Start", "MM - Start", "YYYY - Start", "DD - End", "MM - End", "YYYY - End", "etc"))
db.append(("**", "12", "12", "1980", "12", "12", "1990"))
db.append(("**", "12", "12", "1890", "12", "12", "1990"))
self.assertEqual(clean.algo19(db, ref)[2][1], [])
def test_algo19_fail(self):
db = Workbook().active
ref = Workbook().active
db.append(("etc", "DD - Start", "MM - Start", "YYYY - Start", "DD - End", "MM - End", "YYYY - End", "etc"))
db.append(("**", "12", "12", "1990", "12", "12", "1990"))
db.append(("**", "12", "12", "2990", "12", "12", "1990"))
self.assertEqual(clean.algo19(db, ref)[2][1], ["2990-12-12 00:00:00 @ row 3"])
def test_algo19_pass(self):
db = Workbook().active
ref = Workbook().active
db.append(('etc', 'DD - Start', 'MM - Start', 'YYYY - Start',
'DD - End', 'MM - End', 'YYYY - End', 'etc'))
db.append(('**', '12', '12', '1980', '12', '12', '1990'))
db.append(('**', '12', '12', '1890', '12', '12', '1990'))
self.assertEqual(clean.algo19(db, ref)[2][1], [])
def test_algo19_fail(self):
db = Workbook().active
ref = Workbook().active
db.append(('etc', 'DD - Start', 'MM - Start', 'YYYY - Start',
'DD - End', 'MM - End', 'YYYY - End', 'etc'))
db.append(('**', '12', '12', '1990', '12', '12', '1990'))
db.append(('**', '12', '12', '2990', '12', '12', '1990'))
self.assertEqual(
clean.algo19(db, ref)[2][1], ["2990-12-12 00:00:00 @ row 3"])
