summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/tricode/DbClass.py
diff options
context:
space:
mode:
authorgsmselftest2011-10-27 18:49:14 +0200
committergsmselftest2011-10-27 18:49:14 +0200
commit8273298747a548b628e57539b74fe70521cac9ca (patch)
tree49fc1dbcd0fe6923a859f7535473af10faf1aa9e /For Weekly Test/tricode/DbClass.py
parenterror handle for GSM Eplus. (diff)
downloadgsm-selftest-8273298747a548b628e57539b74fe70521cac9ca.tar.gz
gsm-selftest-8273298747a548b628e57539b74fe70521cac9ca.tar.xz
gsm-selftest-8273298747a548b628e57539b74fe70521cac9ca.zip
finally
Diffstat (limited to 'For Weekly Test/tricode/DbClass.py')
-rwxr-xr-xFor Weekly Test/tricode/DbClass.py24
1 files changed, 24 insertions, 0 deletions
diff --git a/For Weekly Test/tricode/DbClass.py b/For Weekly Test/tricode/DbClass.py
index f8e75f5..00a6f1b 100755
--- a/For Weekly Test/tricode/DbClass.py
+++ b/For Weekly Test/tricode/DbClass.py
@@ -144,6 +144,30 @@ class DBMySQLConnection:
print 'not conn'
return 0 #I am not connected
+ def GSMPrefix(self):
+ if self.connectionCreated == 1:
+ try:
+ successful = self.cur.execute("SELECT * FROM GSMPrefix")
+ output = self.cur.fetchall() #get the mysql response
+ GSMListPrefix = list()
+ for record in output:
+ columns = list()
+ for entry in record:
+ columns.append(str(entry))
+ GSMListPrefix.append(columns)
+
+ return GSMListPrefix
+
+ 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:
+ return 0 #I am not connected
+
def updateGSMDevice(self, deviceName, newPortName, newNumber):
if self.connectionCreated == 1:
try: