def getTrackDetails(sessid): trackTitle = ewd.getSelectediWDMenuValue("TrackList",sessid) trackName = ewd.double_up_quotes(trackTitle) artist = ewd.getSessionValue('cdArtist',sessid) mdb = ewd.mdb_connect('rob','1234567','127.0.0.1') query="SELECT * FROM itunes where Artist = '" + artist + "' and Name = '" + trackName +"'" items=mdb.select('itunes',query) ewd.setSessionValue("trackName",trackTitle,sessid) ewd.setSessionValue("albumName",items[0]["Album"],sessid) ewd.setSessionValue("composer",items[0]["Composer"],sessid) ewd.setSessionValue("trackNo",items[0]["Track Number"],sessid) ewd.setSessionValue("time",items[0]["Time"],sessid) return ""
def getTrackDetails(sessid): trackTitle = ewd.getSelectediWDMenuValue("TrackList", sessid) trackName = ewd.double_up_quotes(trackTitle) artist = ewd.getSessionValue('cdArtist', sessid) mdb = ewd.mdb_connect('rob', '1234567', '127.0.0.1') query = "SELECT * FROM itunes where Artist = '" + artist + "' and Name = '" + trackName + "'" items = mdb.select('itunes', query) ewd.setSessionValue("trackName", trackTitle, sessid) ewd.setSessionValue("albumName", items[0]["Album"], sessid) ewd.setSessionValue("composer", items[0]["Composer"], sessid) ewd.setSessionValue("trackNo", items[0]["Track Number"], sessid) ewd.setSessionValue("time", items[0]["Time"], sessid) return ""
def saveAttribute(sessid): domainName=ewd.getSessionValue("domainName",sessid) itemName=ewd.getSessionValue("itemName",sessid) attributeName=ewd.getRequestValue("attrName",sessid) if attributeName == "": return "You must enter an Attribute Name" ewd.setSessionValue("attrName",attributeName,sessid) value=ewd.getRequestValue("attrValue",sessid) ewd.setSessionValue("attrValue",value,sessid) username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') attr = {attributeName:value} ok = mdb.put_attributes(domainName,itemName,attr,False) return getAttributes(sessid)
def saveAttributeValue(sessid): newValue=ewd.getRequestValue("attrValue",sessid) domainName=ewd.getSessionValue("domainName",sessid) itemName=ewd.getSessionValue("itemName",sessid) attributeName=ewd.getSessionValue("attributeName",sessid) oldValue=ewd.getSessionValue("editAttributeValue",sessid) ewd.setSessionValue("attrValue",newValue,sessid) username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') attr2 = {attributeName:newValue} ok = mdb.put_attributes(domainName,itemName,attr2,False) attr = {attributeName:[oldValue]} ok = mdb.delete_attributes(domainName,itemName,attr) return getAttributes(sessid)
def saveAttribute(sessid): domainName = ewd.getSessionValue("domainName", sessid) itemName = ewd.getSessionValue("itemName", sessid) attributeName = ewd.getRequestValue("attrName", sessid) if attributeName == "": return "You must enter an Attribute Name" ewd.setSessionValue("attrName", attributeName, sessid) value = ewd.getRequestValue("attrValue", sessid) ewd.setSessionValue("attrValue", value, sessid) username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') attr = {attributeName: value} ok = mdb.put_attributes(domainName, itemName, attr, False) return getAttributes(sessid)
def saveAttributeValue(sessid): newValue = ewd.getRequestValue("attrValue", sessid) domainName = ewd.getSessionValue("domainName", sessid) itemName = ewd.getSessionValue("itemName", sessid) attributeName = ewd.getSessionValue("attributeName", sessid) oldValue = ewd.getSessionValue("editAttributeValue", sessid) ewd.setSessionValue("attrValue", newValue, sessid) username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') attr2 = {attributeName: newValue} ok = mdb.put_attributes(domainName, itemName, attr2, False) attr = {attributeName: [oldValue]} ok = mdb.delete_attributes(domainName, itemName, attr) return getAttributes(sessid)
def getItemList(sessid): selectedNo = ewd.getRequestValue('menuItemNo',sessid) if selectedNo != "": domainName = ewd.getSelectediWDMenuValue("domainList",sessid) ewd.setSessionValue("domainName",domainName,sessid) else: domainName = ewd.getSessionValue("domainName",sessid) username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') query="select itemName() from " + domainName items=mdb.select(domainName,query) ewd.deleteFromSession("itemList",sessid) if items != []: ewd.createiWDMenuFromDictionary(items,"itemName()","itemList",sessid) return ""
def getItemList(sessid): selectedNo = ewd.getRequestValue('menuItemNo', sessid) if selectedNo != "": domainName = ewd.getSelectediWDMenuValue("domainList", sessid) ewd.setSessionValue("domainName", domainName, sessid) else: domainName = ewd.getSessionValue("domainName", sessid) username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') query = "select itemName() from " + domainName items = mdb.select(domainName, query) ewd.deleteFromSession("itemList", sessid) if items != []: ewd.createiWDMenuFromDictionary(items, "itemName()", "itemList", sessid) return ""
def getAttributes(sessid): selectedNo = ewd.getRequestValue('menuItemNo',sessid) if selectedNo != "": itemName = ewd.getSelectediWDMenuValue("itemList",sessid) ewd.setSessionValue("itemName",itemName,sessid) else: itemName = ewd.getSessionValue("itemName",sessid) domainName=ewd.getSessionValue("domainName",sessid) username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') query="select * from " + domainName + " where itemName() = '" + itemName + "'" items=mdb.select(domainName,query) dic = items[0] ewd.deleteFromSession("iwdTemp",sessid) ewd.deleteFromSession("attributeValues",sessid) ewd.mergeDictionaryToSession(dic,"iwdTemp",sessid) result = ewd.m_python.m_proc(0, "createAttrList^MDBMgr","attributeValues","iwdTemp",sessid) ewd.deleteFromSession("iwdTemp",sessid) return ""
def getAttributes(sessid): selectedNo = ewd.getRequestValue('menuItemNo', sessid) if selectedNo != "": itemName = ewd.getSelectediWDMenuValue("itemList", sessid) ewd.setSessionValue("itemName", itemName, sessid) else: itemName = ewd.getSessionValue("itemName", sessid) domainName = ewd.getSessionValue("domainName", sessid) username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') query = "select * from " + domainName + " where itemName() = '" + itemName + "'" items = mdb.select(domainName, query) dic = items[0] ewd.deleteFromSession("iwdTemp", sessid) ewd.deleteFromSession("attributeValues", sessid) ewd.mergeDictionaryToSession(dic, "iwdTemp", sessid) result = ewd.m_python.m_proc(0, "createAttrList^MDBMgr", "attributeValues", "iwdTemp", sessid) ewd.deleteFromSession("iwdTemp", sessid) return ""
def getAttributeDetails(sessid): selectedNo = ewd.getRequestValue('menuItemNo',sessid) dic = ewd.mergeDictionaryFromSession("attributeValues",sessid) ewd.setSessionValue("attribute",dic[selectedNo]['text'],sessid) ewd.setSessionValue("attributeName",dic[selectedNo]['name'],sessid) ewd.setSessionValue("editAttributeValue",dic[selectedNo]['value'],sessid) return ""
def getAttributeDetails(sessid): selectedNo = ewd.getRequestValue('menuItemNo', sessid) dic = ewd.mergeDictionaryFromSession("attributeValues", sessid) ewd.setSessionValue("attribute", dic[selectedNo]['text'], sessid) ewd.setSessionValue("attributeName", dic[selectedNo]['name'], sessid) ewd.setSessionValue("editAttributeValue", dic[selectedNo]['value'], sessid) return ""