From 25128f34cdfae5318d1a38441bf09781ef91a2ba Mon Sep 17 00:00:00 2001 From: Triatmoko Date: Thu, 17 Nov 2011 04:24:51 +0100 Subject: update loging files for every handler and fic device configuration function --- Under-Testing/Server-Code-New/DbClass.py | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'Under-Testing/Server-Code-New/DbClass.py') diff --git a/Under-Testing/Server-Code-New/DbClass.py b/Under-Testing/Server-Code-New/DbClass.py index e3b2b5c..d937eb1 100644 --- a/Under-Testing/Server-Code-New/DbClass.py +++ b/Under-Testing/Server-Code-New/DbClass.py @@ -19,7 +19,7 @@ class DBMySQLConnection: def connectDB(self): try: - #try the connection + #try to connect self.datBaseConn=MySQLdb.connect(self.host,self.usern, self.passw,self.db) self.datBaseConn.paramstyle = 'format' self.cur = self.datBaseConn.cursor() #make the cursor, used for sending queries @@ -171,6 +171,13 @@ class DBMySQLConnection: def updateGSMDevice(self, deviceName, newPortName, newNumber): if self.connectionCreated == 1: try: + try: + #delete old device portName which assign to this port, to prevent double port address in the table. + stmt = "UPDATE DeviceAddressTable SET portName = 'missing' WHERE portName = '"+newPortName+"'" + self.cur.execute(stmt) + except ValueError: + print "Error execute query" + stmt = "UPDATE DeviceAddressTable SET portName = '"+ newPortName + "', number = '"+ newNumber+ "' WHERE deviceName = '" + deviceName+ "'" self.cur.execute(stmt) return 1 -- cgit v1.2.3-55-g7522