Beispiel #1
0
 def list_commands(self):
     comands = mdb_get_table(table.name)
     liste = ['Umschalten']
     for comand in comands:
         liste.append(comand.get("Name"))
     liste.remove("Name")
     return liste
Beispiel #2
0
 def list_commands(self,gruppe='default'):    
     table = mdb_get_table(constants.sql_tables.szenen.name)
     liste = {'':''}
     if gruppe == "default":
         for szene in table:
             if szene.get("Gruppe") <>"Intern":
                 if str(szene.get("Beschreibung")) <> "None":
                     liste[szene.get("Name")] = szene.get("Beschreibung")
                 else:
                     liste[szene.get("Name")] = szene.get("Name")
     elif gruppe == "alle" or gruppe == "":
         for szene in table:
             if int(szene.get("Id")) > 19:
                 if str(szene.get("Beschreibung")) <> "None":
                     liste[szene.get("Name")] = szene.get("Beschreibung")
                 else:
                     liste[szene.get("Name")] = szene.get("Name")                        
     else:
         for szene in table:
             if szene.get("Gruppe") == gruppe:
                 if str(szene.get("Beschreibung")) <> "None":
                     liste[szene.get("Name")] = szene.get("Beschreibung")
                 else:
                     liste[szene.get("Name")] = szene.get("Name")           
     return (liste)
Beispiel #3
0
 def list_commands(self):
     comands = mdb_get_table(table.name)
     liste = ["Pause","Play","Save","Announce_Time","Durchsage",'Ansage',"Return","resume","lauter",
              "leiser","inc_leiser","inc_lauter","WeckerAnsage", "EingangWohnzi"]
     for comand in comands:
         liste.append(comand.get("Name"))
     #liste.remove("Name")
     return liste
def  get_satellite(name):
    list = mdb_get_table(constants.sql_tables.satellites.name)
    simplelist = []
    x = None
    for satellite in list:
        if satellite.get("Name") == name:
            x = sputnik(satellite.get("Name"),satellite.get("IP"),satellite.get("PORT"),satellite.get("Type"),satellite.get("USER"),satellite.get("PASS"),satellite.get("command_set"))
            x.attr = satellite
    return x
 def __init__(self, expand = None, isInputs = True, inputsGroup = None, cmdTable = None):
     self.p = None
     self.name = None
     self.expand = expand
     self._szn_lst = sorted(szn.list_commands(gruppe="alle"))
     if isInputs:
         self.inputs = mdb_get_table(db='cmd_inputs')
     else:
         self.inputs = mdb_get_table(db=cmdTable)
     if inputsGroup == None:
         self.inputsGroup = ''
     else:
         self.inputsGroup = inputsGroup
     self.eingaenge = []
     for inpu in self.inputs:
         self.eingaenge.append(str(inpu.get('Id')))
     self.isInputs = isInputs
     self.cmdTable = cmdTable
     self.set_paratree()
Beispiel #6
0
 def send_direkt(self, to, titel, text):
     success = True
     data = {'titel': titel, 'message': text}
     gcm_users = mdb_get_table(table.name)
     for user in gcm_users:
         if user.get('Name') <> None:
             if (user.get('Name') in to) and (str(setting_r(str('Notify_'+ user.get('Name')))) == "True") and constants.redundancy_.master:
                 response = self.gcm.json_request(registration_ids=[user.get('gcm_regid')], data=data)
                 print response
                 if response <> {}:
                     success = False
     return success
 def list_commands(self,device='alle'):
     liste = [] 
     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:
                 liste.append(comand.get("Name"))
     return liste        
 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)
Beispiel #10
0
from mysql_con import mdb_get_table, mdb_set_table

app = QtGui.QApplication([])
from pyqtgraph.parametertree import Parameter, ParameterTree

from cmd_szenen import szenen
from cmd_satellites import satelliten

szn = szenen()
szn_lst = sorted(szn.list_commands('alle'))

cmdLsts = ['out_hue','out_Sonos']
sate = satelliten()
cmdLsts += sate.listCommandTable('alle')

sets = mdb_get_table(constants.sql_tables.settings.name)


class SzenenTreeInputs():
    def __init__(self, isInputs = True, cmdTable = None):
        self.p = None
        self.name = None
        self.set_paratree()
        
    def __return_enum__(self,eingabe):
        if (type(eingabe) == str):
            try:
                if type(eval(eingabe)) == list or type(eval(eingabe)) == dict or type(eval(eingabe)) == tuple:
                    kommandos = eval(eingabe)
                else:
                    kommandos = [eingabe]