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
