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)
s.connect(config.AXXESS_IP, config.AXXESS_PORT) # Introduce ourselves s.send("02000000".decode("hex")) s.send("8400".decode("hex")) # Receive data forever while (1): line = s.receive(RECORD_LENGTH) cleaned_line = clean_line(line) if (raw_file is not None): f = open(raw_file, "a") if (f is not None): f.write(cleaned_line) f.close() cdr = line_to_cdr(cleaned_line, None) if (cdr is not False): status = insert_cdr_record(cdr, cursor) if (status is 1): conn.commit() s.close() conn.close()
fileName = basename(fileWithPath) m = re.match(r'phone_log_(\d+?)-(\d+?)-(\d+?)\.log', fileName) if (m is None): logging.critical("Log file name is malformed.") logging.critical("Name must conform to phone_log_yyyy-mm-dd.log") sys.exit(1) # Assemble datetime from filename logYear = int(m.group(1)) logMonth = int(m.group(2)) logDay = int(m.group(3)) log_date = datetime.date(logYear, logMonth, logDay) conn = sqlite3.connect(config.DATABASE_NAME) cursor = conn.cursor() f = open(fileWithPath) for line in f: line = clean_line(line) cdr = line_to_cdr(line, log_date) insert_cdr_record(cdr, cursor) f.close() conn.commit() conn.close()