def whatRappsCanRun(self,req,tblName):
#generic db read function
try:
res = whatRappsCanRunSrvResponse()
db_username,db_password=self.getLogin()
con = mdb.connect('localhost', db_username, db_password, 'RappStore');
cur = con.cursor()
#returncols=self.constructCommaColumns(req.req_cols)
#print returncols
#where=self.constructAndQuery(req.where_data)
#print where
#query="SELECT "+returncols+" FROM "+tblName+where
query="SELECT rapp_id from tblRappsModelsVersion where model_id='"+req.model_id+"' and minimum_coreagent_version<='"+req.core_agent_version+"'";
#print "fetch called"
cur.execute(query)
result_set = cur.fetchall()
for i in range(len(result_set)):
line=StringArrayMsg()
for j in range(len(result_set[i])):
temp_s=String(result_set[i][j])
line.s.append((str(result_set[i][j])))#=line.s+[String(data=temp_s)]
res.res_data.append(line)
con.close()
res.success.data=True
res.trace.append("Success")
except mdb.Error, e:
res.trace.append(("Database Error %d: %s" % (e.args[0],e.args[1])))
res.success.data=False
print "Error %d: %s" % (e.args[0],e.args[1])
def whatRappsCanRun(self,req,tblName):
try:
res = whatRappsCanRunSrvResponse()
db_username,db_password=self.getLogin()
con = mdb.connect('localhost', db_username, db_password, 'RappStore');
cur = con.cursor()
query="SELECT rapp_id from tblRappsModelsVersion where model_id='"+req.model_id+"' and minimum_coreagent_version<='"+req.core_agent_version+"'";
cur.execute(query)
result_set = cur.fetchall()
for i in range(len(result_set)):
line=StringArrayMsg()
for j in range(len(result_set[i])):
temp_s=String(result_set[i][j])
line.s.append((str(result_set[i][j])))
res.res_data.append(line)
con.close()
res.success.data=True
res.trace.append("Success")
except mdb.Error, e:
res.trace.append(("Database Error %d: %s" % (e.args[0],e.args[1])))
res.success.data=False
res.error="Error %d: %s" % (e.args[0],e.args[1])
def whatRappsCanRunDataHandler(self, req):
res = whatRappsCanRunSrvResponse()
res = self.whatRappsCanRun(req, "tblRappsModelsVersion")
return res
def whatRappsCanRunDataHandler(self,req): res = whatRappsCanRunSrvResponse() res=self.whatRappsCanRun(req,"tblRappsModelsVersion") return res
