summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/DBProblem/test3.py
blob: d600124633f61d125e1a15d18e1a3bc9b1c3c5cd (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
import sys
#import ClientClass
import DbClass
#import ControllerClass
#import classCheck
from time import sleep


db = DbClass.DBMySQLConnection('root', 'randompasswordSQL', 'localhost', 'gsmselftesting')
db.connectDB()
dbStatus = db.connectDB()
print 'i am inserting into the table something', db.insertTaskIn2('gsm4','sip8',2)
print 'i am inserting into the table something', db.insertTaskIn2('gsm4','sip8',2)
print 'i am inserting into the table something', db.insertTaskIn2('gsm4','sip8',2)
print 'i am inserting into the table something', db.insertTaskIn2('gsm4','sip8',2)
db.anyTasksToDo()
if db.anyTasksToDo() == 1:
	templist = db.tasksList
	for item in templist:
		taskID = item[0]
		taskNo = item[1]
		callFrom = item[2]
		callTo = item[3]

		print "Test ID	: " , taskID 
		print "Caller	: " , callFrom
		print "Receiver	: " , callTo
		templist.remove(item)
		#print item
		db.deleteTempTask(taskID)
		if callTo == 'sip':
			db.insertTaskIn2(callTo,callFrom,taskNo)


else:
	print "No job at all"