summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/30-07-2011/DbClass.py
diff options
context:
space:
mode:
Diffstat (limited to 'For Weekly Test/30-07-2011/DbClass.py')
-rw-r--r--For Weekly Test/30-07-2011/DbClass.py60
1 files changed, 0 insertions, 60 deletions
diff --git a/For Weekly Test/30-07-2011/DbClass.py b/For Weekly Test/30-07-2011/DbClass.py
index f2a9afb..65f8150 100644
--- a/For Weekly Test/30-07-2011/DbClass.py
+++ b/For Weekly Test/30-07-2011/DbClass.py
@@ -269,64 +269,4 @@ class DBMySQLConnection:
return 2 #that task wasn't found
else:
return 0
-user = 'root'
-passw = 'randompasswordSQL'
-host = 'localhost'
-dbname = 'gsmselftesting'
-x = DBMySQLConnection(user, passw, host, dbname)
-print "connected to the DB ", x.connectDB()
-print "do i have anything to do", x.anyTasksToDo()
-for item in x.tasksList:
- taskID = item[0]
- taskNo = item[1]
- callFrom = item[2]
- callTo = item[3]
- print "call from to ", taskID , callFrom , callTo, taskNo
-
-print "found", x.searchTaskList('S1IP2','GSM1')
-#if variable == 0:
-# print x.insertTaskIn2('gsm4','sip8',2)
-
-print "remove a task ",x.removeTaskFromList('2')
-
-#print x.cleanTasksList()
-
-for item in x.tasksList:
- device = item[1]
- print "device name", device
- print "device's IP", x.deviceAddress(device)
-
-print "update task result ", x.updateTaskResult(1,3)
-
-print "update ping Table", x.updatePingResult(1,5,4,3,2,1)
-print "delete a task from temp table", x.deleteTempTask(2)
-print "add a result to the table", x.addResult(4,34)
-
-#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
-
-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 item in x.tasksList:
- taskID = item[0]
- taskNo = item[1]
- callFrom = item[2]
- callTo = item[3]
- print "call from to ", taskID , callFrom , callTo, taskNo
-
-print "close connection to the DB", x.closeDBConn()
-
-del x #delete