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