def is_connection_ok(self):
try:
s = self.sock.get_connection()
if isinstance(self.server.address, dict):
self.server.address = Serializable.get_deserialized(self.server.address)
s.connect((self.server.address.address, self.server.address.port))
return True
except Exception as e:
print(e)
return False
def get_status(self):
status_cmd = CommandStruct(cmd=ServerCommand.Com_Status)
response = self.processor.check_response_ex(status_cmd)
response_data = response[1].data
if isinstance(response_data, dict):
response_data = Serializable.get_deserialized(response_data)
if not response[0]:
raise ValueError("get status failed")
elif response_data is not None and isinstance(response_data, ServerStatus):
if isinstance(self.out_data, list):
self.out_data.append(response_data)
self.server.status = response_data
def get_setting_info(self) -> SettingInfo: # need to improve this function
cmd = u"SELECT * FROM Settings WHERE Company=\'{0:s}\';".format(self.company,)
cur = self.cur.execute(cmd)
data = cur.fetchone()
self.db.commit()
if data is not None and len(data) > 0:
settings = SettingInfo(data[0])
try:
if data[1] is not None:
settings.db_filter = Serializable.get_deserialized_json(data[1])
except:
pass
return settings
else:
return None
def get_setting_info(self) -> SettingInfo: # need to improve this function
cmd = u"SELECT * FROM Settings WHERE Company=\'{0:s}\';".format(
self.company, )
cur = self.cur.execute(cmd)
data = cur.fetchone()
self.db.commit()
if data is not None and len(data) > 0:
settings = SettingInfo(data[0])
try:
if data[1] is not None:
settings.db_filter = Serializable.get_deserialized_json(
data[1])
except:
pass
return settings
else:
return None
def _read_from_power_save_db(self):
if os.path.exists(self._recovery_file_path):
data_converted = None
try:
db = sqlite3.connect(self._recovery_file_path)
cur = db.cursor()
cur_ex = cur.execute(
"SELECT STATE_V FROM STATE_TAB WHERE STATE={0:s};".format(
"state", ))
data = cur_ex.fetchone()[0]
db.close()
data_converted = Serializable.get_deserialized_json(data)
except Exception as ex:
ErrorLogger.log_error(
"FileBuffInterface", ex,
"_read_from_power_save_db() " + self._recovery_file_path)
self.recovery_from_power_cut(data_converted)
def parse_command(command: str) ->CommandStruct:
j = json.loads(command)
return Serializable.get_deserialized(j)
def parse_command(command: str) -> CommandStruct:
j = json.loads(command)
return Serializable.get_deserialized(j)
