summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/DBProblem/test3.py
blob: 4450790c066a20319572bc3080231e23cc6a42c7 (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:

	for item in db.tasksList:
		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"