summaryrefslogtreecommitdiffstats
path: root/For Weekly Test/tricode/DbClass.py
diff options
context:
space:
mode:
Diffstat (limited to 'For Weekly Test/tricode/DbClass.py')
-rwxr-xr-xFor Weekly Test/tricode/DbClass.py3
1 files changed, 2 insertions, 1 deletions
diff --git a/For Weekly Test/tricode/DbClass.py b/For Weekly Test/tricode/DbClass.py
index 8cde4e4..b130f68 100755
--- a/For Weekly Test/tricode/DbClass.py
+++ b/For Weekly Test/tricode/DbClass.py
@@ -163,7 +163,8 @@ class DBMySQLConnection:
def updatePingResult(self, taskNo, sipServer, sipGate, unisip, gsmBox1, gsmBox2):
if self.connectionCreated == 1:
try:
- successful = self.cur.execute("UPDATE PingResultTable SET sipServer=%i, sipGate=%i, unisip=%i, gsmBox1=%i, gsmBox2=%i WHERE taskNo=%i"%(int(sipServer), int(sipGate), int(unisip), int(gsmBox1), int(gsmBox2), int(taskNo)))
+ successful = self.cur.execute("INSERT INTO PingResultTable(taskNo, sipServer, sipGate, unisip, gsmBox1, gsmBox2) VALUES ('%i', '%i','%i', '%i','%i','%i')"%( int(taskNo),int(sipServer), int(sipGate), int(unisip), int(gsmBox1), int(gsmBox2)))
+ #successful = self.cur.execute("UPDATE PingResultTable SET sipServer=%i, sipGate=%i, unisip=%i, gsmBox1=%i, gsmBox2=%i WHERE taskNo=%i"%(int(sipServer), int(sipGate), int(unisip), int(gsmBox1), int(gsmBox2), int(taskNo)))
output = self.cur.fetchone()
if debugMode == 1: