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"