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
