SIP SIMPLE Client SDK

#!/usr/bin/python2.6

import os

import re

import sqlite3

from datetime import datetime

try: os.remove('data.db')

except: pass

conn = sqlite3.connect('data.db')

cursor = conn.cursor()

cursor.execute('CREATE VIRTUAL TABLE sip_trace USING fts3(timestamp, direction, source_address, source_port, destination_address, destination_port, protocol, packet)')

second_line = False

second_line_re = re.compile(r'^(?P<date>.+?):\s+(?P<srcaddr>.+?):(?P<srcport>\d+?)\s*-\((?P<proto>.+?)\)->\s*(?P<dstaddr>.+?):(?P<dstport>\d+?)$')

data = None

packet = ''

direction = None

for line in open('../../../.sipclient/logs/sip_trace.txt.0'):

    line = line.strip()

    if second_line:

        second_line = False

        data = second_line_re.match(line).groupdict()

        data['date'] = datetime.strptime(data['date'], '%Y-%m-%d %H:%M:%S.%f')

        data['srcport'] = int(data['srcport'])

        data['dstport'] = int(data['dstport'])

    elif line.startswith('RECEIVED:'):

        direction = 'incoming'

        data = None

        packet = ''

        second_line = True

    elif line.startswith('SENDING:'):

        direction = 'outgoing'

        data = None

        packet = ''

        second_line = True

    elif line == '--':

        cursor.execute('INSERT INTO sip_trace (timestamp, direction, source_address, source_port, destination_address, destination_port, protocol, packet) VALUES (?, ?, ?, ?, ?, ?, ?, ?)',

                       (data['date'], direction, data['srcaddr'], data['srcport'], data['dstaddr'], data['dstport'], data['proto'], packet))

        direction = None

    else:

        packet += line + '\r\n'

conn.commit()

conn.close()