def listCommandTable(self,device='alle', nameReturn = True): liste = [] list_cmds_of = [] if device == 'alle': list_cmds_of = self.list_devices() elif device=="forSave": list_cmds_of = mdb_read_table_column(table.name,"Name") else: list_cmds_of.append(device) for sates in list_cmds_of: cmds_table=mdb_read_table_entry(table.name,sates) if self.__check_table_exists__(cmds_table.get('command_set')): if nameReturn: liste.append(cmds_table.get('Name')) else: liste.append(cmds_table.get('command_set')) return liste
def exec_data(data_ev): if ('Name' in data_ev) and ('Value' in data_ev): name = data_ev.get('Name') value = data_ev.get('Value') #print name, value szns = inputs(name,value) for szene in szns: if szene <> None: scenes.threadExecute(szene, check_bedingung=False, wert = value) # elif data_ev.get('Command')=='Update': # aes.new_event(description="System update", prio=0) # cmd_internal.git_update() elif ('Szene' in data_ev): name = data_ev.get('Szene') if name in mdb_read_table_column(constants.sql_tables.szenen.name, 'Name'): scenes.threadExecute(name) elif ('GCM-Client' in data_ev): aes.new_event('GCM Client: ' + data_ev.get('GCM-Client'))
def dict_commands(self,device='alle'): liste = {'':1,'man':2,'auto':3} itera = 3 list_cmds_of = [] if device == 'alle': list_cmds_of = self.list_devices() else: list_cmds_of.append(device) for sates in list_cmds_of: cmds_table=mdb_read_table_entry(table.name,sates).get('command_set') if self.__check_table_exists__(cmds_table): comands = mdb_get_table(cmds_table) for comand in comands: itera +=1 liste[comand.get("Name")] = itera elif cmds_table == 'server': comands = mdb_read_table_column(constants.sql_tables.szenen.name, 'Name') for comand in comands: itera +=1 liste[comand] = itera return liste
def update(): global inp,t,t2,t3,t4,sz, sets,cmds,seTre, comboBox, comboBox2, comboBox3, szn_lst, xs1_devs, xs1_cmds, hue_devs, hue_cmds, sns_devs, sns_cmds, tvs_devs, tvs_cmds, sat_devs, sat_cmds, cmd_devs szn_lst = sorted(szn.list_commands()) xs1_devs = xs1.list_devices() xs1_cmds = xs1.dict_commands() hue_devs = hue.list_devices() hue_cmds = hue.dict_commands() sns_devs = sn.list_devices() sns_cmds = sn.dict_commands() tvs_devs = tv.list_devices() tvs_cmds = tv.dict_commands() sat_devs = sat.list_devices() sat_cmds = sat.dict_commands() cmd_devs = xs1_devs + hue_devs + sns_devs + tvs_devs + sat_devs sets = mdb_get_table(constants.sql_tables.settings.name) selected(lastSelected) inp=InputsTree(isInputs = True, inputsGroup = str(comboBox5.currentText())) t2.setParameters(inp.p, showTop=False) cmds=InputsTree(isInputs = False, cmdTable = cmd_lsts[0]) t3.setParameters(cmds.p, showTop=False) seTre = SettingsTree() t4.setParameters(seTre.p, showTop=False) comboBox.clear() for szne in szn_lst: comboBox.addItem(szne) comboBox2.clear() for cmdLst in cmd_lsts: comboBox2.addItem(cmdLst) comboBox2.activated[str].connect(slctCmdLst) comboBox3.clear() inpts = sorted(mdb_read_table_column(db="cmd_inputs", column = 'Description')) for inpt in inpts: if str(inpt) <> "": comboBox3.addItem(str(inpt)) inp.p.sigTreeStateChanged.connect(change) sz.p.sigTreeStateChanged.connect(change_sz)