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
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]))
