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"])