def fetchData(self,req,tblName): #generic db read function try: res = fetchDataSrvResponse() 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 #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() if (returncols=="*"): res.res_cols=self.getTableColumnNames(tblName) else: res.res_cols=req.req_cols 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 fetchData(self, req, tblName): try: res = fetchDataSrvResponse() db_username, db_password = self.getLogin() con = mdb.connect('localhost', db_username, db_password, 'RappStore') cur = con.cursor() returncols = self.constructCommaColumns(req.req_cols) where = self.constructAndQuery(req.where_data) query = "SELECT " + returncols + " FROM " + tblName + where 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() if (returncols == "*"): res.res_cols = self.getTableColumnNames(tblName) else: res.res_cols = req.req_cols 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 viewUsersRobotsAppsFetchDataHandler(self, req): res = fetchDataSrvResponse() res = self.fetchData(req, "usersrobotsapps") return res
def tblUsersOntologyInstancesFetchDataHandler(self, req): res = fetchDataSrvResponse() res = self.fetchData(req, "tblUsersOntologyInstances") return res
def tblAppsRobotsFetchDataHandler(self, req): res = fetchDataSrvResponse() res = self.fetchData(req, "tblAppsRobots") return res
def tblRappFetchDataHandler(self, req): res = fetchDataSrvResponse() res = self.fetchData(req, "tblRapp") return res
def viewUsersRobotsAppsFetchDataHandler(self,req): res = fetchDataSrvResponse() res=self.fetchData(req,"usersrobotsapps") return res
def tblUsersOntologyInstancesFetchDataHandler(self,req): res = fetchDataSrvResponse() res=self.fetchData(req,"tblUsersOntologyInstances") return res
def tblAppsRobotsFetchDataHandler(self,req): res = fetchDataSrvResponse() res=self.fetchData(req,"tblAppsRobots") return res
def tblRappFetchDataHandler(self,req): res = fetchDataSrvResponse() res=self.fetchData(req,"tblRapp") return res
def tblCloudAgentServiceArgumentsFetchDataHandler(self,req): res = fetchDataSrvResponse() res=self.fetchData(req,"cloud_agent_service_arguments") return res
def tblCloudAgentFetchDataHandler(self,req): res = fetchDataSrvResponse() res=self.fetchData(req,"cloud_agent") return res
def tblUserFetchDataHandler(self,req): res = fetchDataSrvResponse() res=self.fetchData(req,"users") return res