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