def test_null_to_python(self):
        self.conn.execute("INSERT INTO tab VALUES(NULL, NULL)")

        r = self.conn.execute("SELECT * FROM _audit").fetchone()
        py_val = audit.to_python(r[4])

        self.assertEqual(py_val, [['c1', None], ['c2', None]])
    def test_nums_to_python(self):
        self.conn.execute("INSERT INTO tab VALUES(5, 3.14)")

        r = self.conn.execute("SELECT * FROM _audit").fetchone()
        py_val = audit.to_python(r[4])

        self.assertEqual(py_val, [['c1', 5], ['c2', 3.14]])
    def test_string_to_python(self):
        self.conn.execute("INSERT INTO tab VALUES('a', 'b')")

        r = self.conn.execute("SELECT * FROM _audit").fetchone()
        py_val = audit.to_python(r[4])

        self.assertEqual(py_val, [['c1', 'a'], ['c2', 'b']])
    def test_null_to_python(self):
        self.conn.execute("INSERT INTO tab VALUES(NULL, NULL)")

        r = self.conn.execute("SELECT * FROM _audit").fetchone()
        py_val = audit.to_python(r[4])

        self.assertEqual(py_val,
                         [['c1', None],
                          ['c2', None]])
    def test_nums_to_python(self):
        self.conn.execute("INSERT INTO tab VALUES(5, 3.14)")

        r = self.conn.execute("SELECT * FROM _audit").fetchone()
        py_val = audit.to_python(r[4])

        self.assertEqual(py_val,
                         [['c1', 5],
                          ['c2', 3.14]])
    def test_string_to_python(self):
        self.conn.execute("INSERT INTO tab VALUES('a', 'b')")

        r = self.conn.execute("SELECT * FROM _audit").fetchone()
        py_val = audit.to_python(r[4])

        self.assertEqual(py_val,
                         [['c1', 'a'],
                          ['c2', 'b']])