def deleteDomain(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') ok = mdb.delete_domain(domainName) return getDomainList(sessid)
def deleteDomain(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') ok = mdb.delete_domain(domainName) return getDomainList(sessid)
def deleteItem(sessid): domainName = ewd.getSessionValue("domainName", sessid) itemName = ewd.getSessionValue("itemName", sessid) username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') ok = mdb.delete_attributes(domainName, itemName) return getItemList(sessid)
def deleteItem(sessid): domainName=ewd.getSessionValue("domainName",sessid) itemName=ewd.getSessionValue("itemName",sessid) username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') ok = mdb.delete_attributes(domainName,itemName) return getItemList(sessid)
def saveDomain(sessid): domainName=ewd.getRequestValue("domainName",sessid) if domainName == "": return "You did not enter a Domain Name" username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') ok = mdb.create_domain(domainName) return getDomainList(sessid)
def saveDomain(sessid): domainName = ewd.getRequestValue("domainName", sessid) if domainName == "": return "You did not enter a Domain Name" username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') ok = mdb.create_domain(domainName) return getDomainList(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 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 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 getDomainList(sessid): username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') domains = mdb.get_all_domains() domainList = {} no = 0 for domain in domains: no = no + 1 item = {} nvp = {'Name':domain.name.encode('ascii','xmlcharrefreplace')} item.update(nvp) nvp = {no:item} domainList.update(nvp) ewd.mergeDictionaryToSession(domainList,"yuiTemp",sessid) ewd.deleteFromSession("domainList",sessid) if domainList != {}: result = ewd.m_python.m_proc(0, "createiWDMenuFromDictionary^%zewdPython","Name","domainList",sessid) ewd.deleteFromSession("yuiTemp",sessid) return ""
def getCDTracksXArtist(sessid): artist = ewd.getSessionValue('cdArtist', sessid) if artist == '': return "You must specify an artist" mdb = ewd.mdb_connect('rob', '1234567', '127.0.0.1') query = "SELECT Name FROM itunes where Artist = '" + artist + "'" items = mdb.select('itunes', query) noOfItems = len(items) if noOfItems == 0: return "No matches found" ewd.createiWDMenuFromDictionary(items, "Name", "TrackList", sessid) return ""
def getCDTracksXArtist(sessid): artist = ewd.getSessionValue('cdArtist',sessid) if artist == '': return "You must specify an artist" mdb = ewd.mdb_connect('rob','1234567','127.0.0.1') query="SELECT Name FROM itunes where Artist = '" + artist + "'" items=mdb.select('itunes',query) noOfItems = len(items) if noOfItems == 0: return "No matches found" ewd.createiWDMenuFromDictionary(items,"Name","TrackList",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 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 getDomainList(sessid): username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') domains = mdb.get_all_domains() domainList = {} no = 0 for domain in domains: no = no + 1 item = {} nvp = {'Name': domain.name.encode('ascii', 'xmlcharrefreplace')} item.update(nvp) nvp = {no: item} domainList.update(nvp) ewd.mergeDictionaryToSession(domainList, "yuiTemp", sessid) ewd.deleteFromSession("domainList", sessid) if domainList != {}: result = ewd.m_python.m_proc( 0, "createiWDMenuFromDictionary^%zewdPython", "Name", "domainList", sessid) ewd.deleteFromSession("yuiTemp", 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 deleteAttribute(sessid): domainName = ewd.getSessionValue("domainName", sessid) itemName = ewd.getSessionValue("itemName", sessid) attributeName = ewd.getSessionValue("attributeName", sessid) attributeValue = ewd.getSessionValue("editAttributeValue", sessid) username = ewd.getSessionValue("username", sessid) password = ewd.getSessionValue("password", sessid) mdb = ewd.mdb_connect(username, password, '127.0.0.1') attr = {attributeName: [attributeValue]} ok = mdb.delete_attributes(domainName, itemName, attr) return getAttributes(sessid)
def deleteAttribute(sessid): domainName=ewd.getSessionValue("domainName",sessid) itemName=ewd.getSessionValue("itemName",sessid) attributeName=ewd.getSessionValue("attributeName",sessid) attributeValue=ewd.getSessionValue("editAttributeValue",sessid) username=ewd.getSessionValue("username",sessid) password=ewd.getSessionValue("password",sessid) mdb = ewd.mdb_connect(username,password,'127.0.0.1') attr = {attributeName:[attributeValue]} ok = mdb.delete_attributes(domainName,itemName,attr) 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 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)