summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/12-09-2011/DbClass.py
diff options
context:
space:
mode:
Diffstat (limited to 'For Weekly Test/12-09-2011/DbClass.py')
-rw-r--r--For Weekly Test/12-09-2011/DbClass.py15
1 files changed, 14 insertions, 1 deletions
diff --git a/For Weekly Test/12-09-2011/DbClass.py b/For Weekly Test/12-09-2011/DbClass.py
index d312b63..3e4a610 100644
--- a/For Weekly Test/12-09-2011/DbClass.py
+++ b/For Weekly Test/12-09-2011/DbClass.py
@@ -12,6 +12,7 @@ class DBMySQLConnection:
self.tasksList = list()
self.callerLists = list()
self.errCode = None
+ self.deviceUpdate = None
global debugMode
debugMode = 0
@@ -97,7 +98,7 @@ class DBMySQLConnection:
def deviceAddress(self,deviceName):
if self.connectionCreated == 1:
try:
- successful = self.cur.execute("SELECT `deviceIP`,`number`, `username`, `password`, `server` FROM DeviceAddressTable where `deviceName`=%s", deviceName)
+ successful = self.cur.execute("SELECT `portName`,`number`, `username`, `password`, `server` FROM DeviceAddressTable where `deviceName`=%s", deviceName)
output = self.cur.fetchall()
deviceAddr = ''
for record in output:
@@ -117,6 +118,18 @@ class DBMySQLConnection:
else:
return 0 #I am not connected
+ def updateGSMDevice(self, deviceName, newPortName, newNumber):
+ if self.connectionCreated == 1:
+ try:
+ stmt = "UPDATE DeviceAddressTable SET portName = '"+ newPortName + "', number = '"+ newNumber+ "' WHERE deviceName = '" + deviceName+ "'"
+ self.cur.execute(stmt)
+
+ except MySQLdb.Error, e:
+ if debugMode == 1:
+ print str(e)
+ return 3
+ else:
+ return 0
def updatePingResult(self, taskNo, sipServer, sipGate, unisip, gsmBox1, gsmBox2):
if self.connectionCreated == 1: