summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/Advance/DbClass.py
diff options
context:
space:
mode:
Diffstat (limited to 'For Weekly Test/Advance/DbClass.py')
-rw-r--r--For Weekly Test/Advance/DbClass.py28
1 files changed, 27 insertions, 1 deletions
diff --git a/For Weekly Test/Advance/DbClass.py b/For Weekly Test/Advance/DbClass.py
index 3e4a610..8a5e69b 100644
--- a/For Weekly Test/Advance/DbClass.py
+++ b/For Weekly Test/Advance/DbClass.py
@@ -13,6 +13,9 @@ class DBMySQLConnection:
self.callerLists = list()
self.errCode = None
self.deviceUpdate = None
+ self.gsmRZList = None
+ self.gsmExtList = None
+ self.sipList = None
global debugMode
debugMode = 0
@@ -114,9 +117,32 @@ class DBMySQLConnection:
return 2 #the table doesn't exist
if debugMode == 1:
print str(e)
- return 3 #some error happened
+ return 3 #some error happened 07667929147--Fitri
else:
return 0 #I am not connected
+ def deviceList(self):
+ deviceLists = list()
+ print 'hallo'
+ if self.connectionCreated == 1:
+ try:
+ tuple = self.cur.execute("SELECT `deviceName` FROM DeviceAddressTable")
+ output = self.cur.fetchall()
+ print output
+ for data in output:
+ deviceLists.append(str(data))
+ return deviceLists
+
+#return deviceAddr
+ except MySQLdb.Error, e:
+ error = str(e)
+ if error[1:5] == '1146':
+ return 2 #the table doesn't exist
+ if debugMode == 1:
+ print str(e)
+ return 3 #some error happened
+ else:
+ print 'not conn'
+ return 0 #I am not connected
def updateGSMDevice(self, deviceName, newPortName, newNumber):
if self.connectionCreated == 1: