#!/usr/bin/env python

import sys
import mysql.connector
import datetime
import operator

# the list of current listeners
listeners = []

def main(arg):
    conn = mysql.connector.connect(user = "root",
                                   password = "PASS",
                                   database = "DB")

    cursor1 = conn.cursor(buffered = True)

    query = ("SELECT id, start, end FROM listeners ORDER BY start ASC LIMIT 1000")
    cursor1.execute(query)

    for (listenerid, start, end) in cursor1:

        listenerid = int(listenerid)

        # the list of listeners we've lost since last added client
        lost_listeners = []

        num_listeners = len(listeners)

        if listenerid == 466:
            for i, l in enumerate(listeners):
                print l[0]
        print "----"
        for i, l in enumerate(listeners):
            if listenerid == 466:
                print l[0]
            if start >= l[1]:
                if listenerid == 466 and l[0] == 385:
                    print "yes"
                lost_listeners.append(l)
                del(listeners[i])