row = cursor.fetchone() while row is not None: acctid = row[9] callerid = row[2] try: m = re.search('"(.+?)" <(.+?)>', callerid) callerid_name = m.group(1) callerid_number = m.group(2) except: callerid_name = '' callerid_number = callerid channel = row[3] duration = set_int_default(row[4], 0) billsec = set_int_default(row[5], 0) ast_disposition = row[6] try: id_disposition = dic_disposition.get( ast_disposition.encode("utf-8"), 0) transdisposition = DISPOSITION_TRANSLATION[id_disposition] except: transdisposition = 0 hangup_cause_id = get_hangupcause_id(transdisposition) accountcode = set_int_default(row[7], '') uniqueid = row[8] start_uepoch = datetime.fromtimestamp(int(row[1]))
while row is not None: acctid = row[9] callerid = row[2] try: m = re.search('"(.+?)" <(.+?)>', callerid) callerid_name = m.group(1) callerid_number = m.group(2) except: callerid_name = '' callerid_number = callerid channel = row[3] if not channel: channel = '' # Set empty string for channel in case is None duration = set_int_default(row[4], 0) billsec = set_int_default(row[5], 0) ast_disposition = row[6] try: id_disposition = dic_disposition.get( ast_disposition.encode("utf-8"), 0) transdisposition = DISPOSITION_TRANSLATION[id_disposition] except: transdisposition = 0 hangup_cause_id = get_hangupcause_id(transdisposition) accountcode = row[7] uniqueid = row[8] start_uepoch = datetime.fromtimestamp(int(row[1])) # Check Destination number
(settings.ASTERISK_PRIMARY_KEY, table_name)) row = cursor.fetchone() while row is not None: acctid = row[9] callerid = row[2] try: m = re.search('"(.+?)" <(.+?)>', callerid) callerid_name = m.group(1) callerid_number = m.group(2) except: callerid_name = '' callerid_number = callerid channel = row[3] duration = set_int_default(row[4], 0) billsec = set_int_default(row[5], 0) ast_disposition = row[6] try: id_disposition = dic_disposition.get( ast_disposition.encode("utf-8"), 0) transdisposition = DISPOSITION_TRANSLATION[id_disposition] except: transdisposition = 0 hangup_cause_id = get_hangupcause_id(transdisposition) accountcode = row[7] uniqueid = row[8] start_uepoch = datetime.fromtimestamp(int(row[1])) # Check Destination number