import dbClass user = 'root' passw = 'randompasswordSQL' host = 'localhost' dbname = 'gsmselftesting' x = dbClass.DBMySQLConnection(user, passw, host, dbname) print "connected to the DB ", x.connectDB() print "do i have anything to do", x.anyTasksToDo() print 'i am inserting into the table something', x.insertTaskIn2('gsm4','sip8',2) print 'i am inserting into the table something', x.insertTaskIn2('gsm4','sip8',2) print 'i am inserting into the table something', x.insertTaskIn2('gsm4','sip8',2) print 'i am inserting into the table something', x.insertTaskIn2('gsm4','sip8',2) for index in range(len(x.tasksList)): item = x.tasksList[index] tempItem = item taskID = item[0] taskNo = item[1] callFrom = item[2] callTo = item[3] testDone = item[4] print "call from to ", taskID , callFrom , callTo, taskNo, testDone if testDone == str(0): print item[0] tempItem[4]=str(1) print "delete a task from temp table", x.deleteTempTask(taskID) x.tasksList[index]=tempItem #del x.tasksList[index-1] print '\n\n\n\n' #new task to do #$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ #just made for Tri :)--------------------------------------------------------------- #print x.cleanTasksList() #print "do i have any task from SIP1 to GSM1 to do", x.anyTasksFromTo('SIP2', 'GSMu1', 2) #for item in x.tasksList: # taskID = item[0] # callFrom = item[1] # callTo = item[2] # print "call from to ", taskID , callFrom , callTo #----------------------------------------------------------------------------------- #$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ for item in x.tasksList[:]: taskID = item[0] taskNo = item[1] callFrom = item[2] callTo = item[3] testDone = item[4] print "call from to ", taskID , callFrom , callTo, taskNo, testDone print "close connection to the DB", x.closeDBConn() del x