summaryrefslogblamecommitdiffstats
path: root/For Weekly Test/23-07-2011/Controller.py
blob: 0f8812f72f1295f900bbe9262eea770279a15a2c (plain) (tree)


















                                       











































                                                                                          
                                                                                          












                                                                                          
                                                                                                    












                                                                                                
                                                                                                   












                                                                                                
                                                                                              












                                                                                                
                                                                                              




                                                                                  



                                   
import sys
import os
import time
import MySQLdb
import subprocess


import classClient #import class socket
import classDb #import class db
import classPing
import classController
from time import sleep



sipNum		= "4661929"
landlnNum	= "076145875681"
unisipNum	= "076120397897"

# Main software

# Check DB connection
db = classDb.DBMySQLConnection('root', 'randompasswordSQL', 'localhost', 'gsmselftesting')
db.connectDB()
print ""
dbStatus = db.connectDB()


if dbStatus == 1:
	
	# Check Ping to the Every Handler
	sipServer = classPing.Ping('132.230.4.8')
	sipServerStatus = sipServer.ping(3)

	sipGateServer = classPing.Ping('sipgate.de')
	sipGateServerStatus = sipGateServer.ping(3)

	sipLocalServer = classPing.Ping('132.230.252.228')
	sipLocalServerStatus = sipLocalServer.ping(3)

# Fetch The task information from DB
	db.anyTasksToDo()	
	#x = ()

	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

		if callFrom == "sip":
 			if sipServerStatus == 0:
				print "[failed] 500 Server Internal Error"

			else:
			
				if callTo == "gsmrz1":

					x = classController.test('-S',"gsmBox1","4661455")
					x.FuncTest()
					
					db.addResult(taskID, x.testResult)

					if x.repeatTest == True:
						db.insertTaskIn2(callTo,callFrom,taskNo)
			
				if callTo == "gsmrz2":
	
					if gsmBox1Status == 0:
						print "[failed] 500 Server Internal Error"

					else:
						x = classController.test('-S', "gsmBox2", "4661404")
						x.FuncTest()
						
						db.addResult(taskID, x.testResult)

						if x.repeatTest == True:
							db.insertTaskIn2(callTo,callFrom,taskNo)

				if callTo == "gsmrz3":

					if gsmBox2Status == 0:
						print "[failed] 500 Server Internal Error"

					else:
						x = classController.test('-S', "gsmBox3","4661405")
						x.FuncTest()

						db.addResult(taskID, x.testResult)

						if x.repeatTest == True:
							db.insertTaskIn2(callTo,callFrom,taskNo)

				if callTo == "landline":

					if sipGateServerStatus == 0:
						print "[failed] 500 Server Internal Error"
			
					else:
						x = classController.test('-S', '-L',landlnNum)
						x.FuncTest()

						db.addResult(taskID, x.testResult)
			
						if x.repeatTest == True:
							db.insertTaskIn2(callTo,callFrom,taskNo)
						sleep(5)

				if callTo == "localsip":
					if sipLocalServerStatus == 0:
						print "[failed] 500 Server Internal Error"

					else:
						x = classController.test('-S', '-U',unisipNum)
						x.FuncTest()

						db.addResult(taskID, x.testResult)
						sleep(5)

# will exit if DB connection failed
else:
	sys.exit(5)