def delete_device(self, device_id): c = self.connect() # Delete commands from device Commands.delete_device(c, device_id) # Delete device Devices.delete(c, device_id) self.close() return "Device removed"
def create(self): c = self.connect() # Delete tables if exists Devices.drop(c) Commands.drop(c) # Create tables Devices.create(c) Commands.create(c) self.close()
def new_command(self, name, device_id, signal): c = self.connect() Commands.insert(c, device_id, name, signal) new_command_id = Commands.select_last_command_id(c) self.close() return new_command_id[0]['id']
def get_command(self, command_id): c = self.connect() data = Commands.select(c, command_id) self.close() return data[0]
def get_commands(self, device_id): c = self.connect() data = Commands.select_device(c, device_id) self.close() return data
def get_all_commands(self): c = self.connect() data = Commands.select_all(c) self.close() return data
def clean_commands(self): Commands.clean(self.connect()) self.close() return "Cleaned commands"
def delete_command(self, command_id): Commands.delete(self.connect(), command_id) self.close() return "Command removed"
def update_command_name(self, command_id, new_name): Commands.update_name(self.connect(), command_id, new_name) self.close() return "Command updated"
def update_command_signal(self, command_id, signal): Commands.update_signal(self.connect(), command_id, signal) self.close() return "Command updated"