def writeData(self, req, tblName): try: res = writeDataSrvResponse() db_username, db_password = self.getLogin() con = mdb.connect('localhost', db_username, db_password, 'RappStore') cur = con.cursor() returncols = self.constructCommaColumns(req.req_cols) if (len(returncols) > 1): returncols = "(" + returncols + ")" print returncols values = "" for i in range(len(req.req_data)): if (i == 0): values = values + "(" + self.constructCommaColumns( req.req_data[i].s) + ")" else: values = values + ",(" + self.constructCommaColumns( req.req_data[i].s) + ")" query = "Insert into " + tblName + " " + returncols + " values " + values cur.execute("LOCK TABLES " + tblName + " WRITE") cur.execute(query) cur.execute("UNLOCK TABLES") 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 writeData(self,req,tblName): #generic db write function try: res = writeDataSrvResponse() db_username,db_password=self.getLogin() con = mdb.connect('localhost', db_username, db_password, 'RappStore'); cur = con.cursor() returncols=self.constructCommaColumns(req.req_cols) if (len(returncols)>1): returncols="("+returncols+")" print returncols values="" for i in range(len(req.req_data)): if (i==0): values=values+"("+self.constructCommaColumns(req.req_data[i].s)+")" else: values=values+",("+self.constructCommaColumns(req.req_data[i].s)+")" #print values query="Insert into "+tblName+" "+ returncols+" values "+values #print query cur.execute("LOCK TABLES "+tblName+" WRITE") cur.execute(query) cur.execute("UNLOCK TABLES") 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 tblUsersOntologyInstancesWriteDataHandler(self, req): res = writeDataSrvResponse() res = self.writeData(req, "tblUsersOntologyInstances") return res
def tblAppsRobotsWriteDataHandler(self, req): res = writeDataSrvResponse() res = self.writeData(req, "tblAppsRobots") return res
def tblRappWriteDataHandler(self, req): res = writeDataSrvResponse() res = self.writeData(req, "tblRapp") return res
def tblUsersOntologyInstancesWriteDataHandler(self,req): res = writeDataSrvResponse() res=self.writeData(req,"tblUsersOntologyInstances") return res
def tblAppsRobotsWriteDataHandler(self,req): res = writeDataSrvResponse() res=self.writeData(req,"tblAppsRobots") return res
def tblRappWriteDataHandler(self,req): res = writeDataSrvResponse() res=self.writeData(req,"tblRapp") return res
def tblCloudAgentServiceArgumentsWriteDataHandler(self,req): res = writeDataSrvResponse() res=self.writeData(req,"cloud_agent_service_arguments") return res
def tblCloudAgentWriteDataHandler(self,req): res = writeDataSrvResponse() res=self.writeData(req,"cloud_agent") return res
def tblUserWriteDataHandler(self,req): res = writeDataSrvResponse() res=self.writeData(req,"users") return res