summaryrefslogtreecommitdiffstats
path: root/notFinishedCode/dbTest.py
diff options
context:
space:
mode:
Diffstat (limited to 'notFinishedCode/dbTest.py')
-rw-r--r--notFinishedCode/dbTest.py52
1 files changed, 0 insertions, 52 deletions
diff --git a/notFinishedCode/dbTest.py b/notFinishedCode/dbTest.py
deleted file mode 100644
index c980764..0000000
--- a/notFinishedCode/dbTest.py
+++ /dev/null
@@ -1,52 +0,0 @@
-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