def test_insert_db(self):

        cdr = file_to_cdr(self.CDR_FILE, None)

        for record in cdr:
            rowcount = insert_cdr_record(record, self.conn.cursor())
            self.assertEqual(rowcount, 1)

        self.conn.commit()
        rows = self.conn.cursor().execute("SELECT * FROM logviewer_phonerecord").fetchall()
        self.assertEqual(len(rows), 173)
    def test_file_to_cdr(self):

        cdr = file_to_cdr(self.CDR_FILE, None)
        self.assertEqual(len(cdr), 173)