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 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 ""
