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