def deleteUserTable(databaseHandler): cmd = "DELETE FROM user" if not database.deleteDB_table(databaseHandler, cmd): systemlog.log_error("清空用户表失败!") return False insertUserTableData(databaseHandler, "admin", "123123", "MANAGER") return True
def deleteDeviceTableData(databaseHandler, typeName, value): cmd = "DELETE FROM device WHERE " + str(typeName) + " = '" + str( value) + "'" if not database.deleteDB_data(databaseHandler, cmd): systemlog.log_error("删除设备表数据失败!") return False return True
def updateUserTableData(databaseHandler, username, typeName=None, value=None): if typeName != None and value != None: cmd = "UPDATE user SET " + str(typeName) + " = '" + str( value) + "' WHERE name = '" + str(username) + "'" else: cmd = "" if not database.updateDB_data(databaseHandler, cmd): systemlog.log_error("更新用户表失败")
def run(self): try: self.tcpHandler = socketserver.ThreadingTCPServer( ("0.0.0.0", self.port), self.threadTcpHander) self.tcpHandler.daemon_threads = True self.tcpHandler.serve_forever() except Exception as e: systemlog.log_error(e)
def deleteUserTableData(databaseHandler, typeName, value): if value == "admin": return False cmd = "DELETE FROM user WHERE " + str(typeName) + " = '" + str(value) + "'" if not database.deleteDB_data(databaseHandler, cmd): systemlog.log_error("删除用户失败") return False return True
def run(self): while True: try: self.addPant() self.checkPant() except Exception as e: systemlog.log_error(e) time.sleep(1)
def insertDataTableData(databaseHandler, deviceName, saveTime, distance, azimuth, height, phase, speed, snr, channel, default): cmd = "INSERT INTO data (device, time, distance, azimuth, height, phase, speed, snr, channel, range) VALUES ('" + str( deviceName) + "', '" + str(saveTime) + "', '" + str( distance) + "', '" + str(azimuth) + "', '" + str( height) + "', '" + str(phase) + "', '" + str( speed) + "', '" + str(snr) + "', '" + str( channel) + "', '" + str(default) + "')" if not database.insertDB_data(databaseHandler, cmd): systemlog.log_error("插入数据表数据失败!")
def connectDB(databaseName): try: #conn = getattr(g, "_db", None) #if conn is None: #conn = g._db = sqlite3.connect(databaseName) conn = sqlite3.connect(databaseName) except Exception as e: systemlog.log_error(e) conn = None return conn
def updateDataTableData(databaseHandler, deviceName, typeName=None, value=None): if typeName != None and value != None: cmd = "UPDATE data SET " + str(typeName) + " = '" + str( value) + "' WHERE device = '" + str(deviceName) + "'" else: cmd = "" if not database.updateDB_data(databaseHandler, cmd): systemlog.log_error("更新数据表数据失败!")
def updateDB_data(databaseHandler, cmd): status = False try: databaseHandler.execute(cmd) databaseHandler.commit() status = True except Exception as e: systemlog.log_error(e) databaseHandler.rollback() finally: return status
def selectDB_data(databaseHandler, cmd): res_row = {} try: databaseHandler.row_factory = sqlite3.Row res = databaseHandler.cursor() res.execute(cmd) res_row = res.fetchall() except Exception as e: systemlog.log_error(e) finally: return res_row
def insertDeviceTableData(databaseHandler, deviceName, deviceIP, serverIP, deviceStatus=0, linkStatus=0): cmd = "INSERT INTO device (deviceName, deviceIP, serverIP, deviceStatus, linkStatus) VALUES ('" + str( deviceName) + "', '" + str(deviceIP) + "', '" + str( serverIP) + "', '" + str(deviceStatus) + "', '" + str( linkStatus) + "')" if not database.insertDB_data(databaseHandler, cmd): systemlog.log_error("插入设备表数据失败!")
def initDB(): if not os.path.isfile(setting.DATABASENAME) or not os.path.getsize( setting.DATABASENAME): conn = database.createDB(setting.DATABASENAME) if conn: createUserTable(conn) createDeviceTable(conn) createDataTable(conn) insertUserTableData(conn, "admin", "123123", "MANAGER") else: systemlog.log_error("初始化数据库失败!") disconnectDB(conn)
def run(self): #加快物理按钮和前端按钮的响应速度,提高读取发送速率 btnSendData = list(self.defList.keys())[0] while True: try: for k , v in self.defList.items(): conn = threadfunc.get_ActiveSocket(v) if conn: conn.send(k) time.sleep(0.1) btnSock = threadfunc.get_ActiveSocket(self.defList.get(btnSendData)) if btnSock: btnSock.send(btnSendData) time.sleep(0.1) except Exception as e: systemlog.log_error(e)
def insertUserTableData(databaseHandler, username, password, role): cmd = "INSERT INTO user (name, password, role) VALUES ('" + str( username) + "', '" + str(password) + "', '" + str(role) + "')" if not database.insertDB_data(databaseHandler, cmd): systemlog.log_error("插入用户数据失败")
def createDeviceTable(databaseHandler): cmd = "CREATE TABLE device (deviceName TEXT, deviceIP TEXT, serverIP TEXT, deviceStatus TEXT, linkStatus TEXT)" if not database.createDB_table(databaseHandler, cmd): systemlog.log_error("创建设备表失败!")
def createDataTable(databaseHandler): cmd = "CREATE TABLE data (device TEXT, time TEXT, distance TEXT, azimuth TEXT, height TEXT, phase TEXT, speed TEXT, snr TEXT, channel TEXT, range TEXT)" if not database.createDB_table(databaseHandler, cmd): systemlog.log_error("创建数据表失败!")
def createUserTable(databaseHandler): cmd = "CREATE TABLE user (name TEXT, password TEXT, role TEXT)" if not database.createDB_table(databaseHandler, cmd): systemlog.log_error("创建用户表失败!")
def deleteDataTable(databaseHandler): cmd = "DELETE FROM data" if not database.deleteDB_table(databaseHandler, cmd): systemlog.log_error("清空数据表失败!") return False return True