def test_algo20_pass(self):
        db = Workbook().active
        ref = Workbook().active

        db.append(("etc", "DD - End", "MM - End", "YYYY - End", "Activity Status"))
        db.append(("**", "12", "12", "1890", "it is completed"))
        db.append(("**", "12", "12", "1890", "completed"))

        self.assertEqual(clean.algo20(db, ref)[2][1], [])
    def test_algo20_fail(self):
        db = Workbook().active
        ref = Workbook().active

        db.append(("etc", "DD - End", "MM - End", "YYYY - End", "Activity Status"))
        db.append(("**", "12", "12", "1890", "breakit"))
        db.append(("**", "12", "12", "1890", "completed"))

        self.assertEqual(clean.algo20(db, ref)[2][1], [("1890-12-12 00:00:00 row 2")])
    def test_algo20_pass(self):
        db = Workbook().active
        ref = Workbook().active

        db.append(
            ('etc', 'DD - End', 'MM - End', 'YYYY - End', 'Activity Status'))
        db.append(('**', '12', '12', '1890', 'it is completed'))
        db.append(('**', '12', '12', '1890', 'completed'))

        self.assertEqual(clean.algo20(db, ref)[2][1], [])
    def test_algo20_fail(self):
        db = Workbook().active
        ref = Workbook().active

        db.append(
            ('etc', 'DD - End', 'MM - End', 'YYYY - End', 'Activity Status'))
        db.append(('**', '12', '12', '1890', 'breakit'))
        db.append(('**', '12', '12', '1890', 'completed'))

        self.assertEqual(
            clean.algo20(db, ref)[2][1], [("1890-12-12 00:00:00 row 2")])