def setRemWelCalToAgent(self,agentId, rem, allocatingStatus, welCalStatusToPick,host,user,password,database,port): qry = 'UPDATE welcome_calls SET agent_id='+str(agentId)+',status='+str(allocatingStatus)+' WHERE ' qry = qry + self.getMultipleStatusQryStr(welCalStatusToPick) qry = qry + ' limit '+str(rem) logging.debug(qry) updatedCount = DBUtils.executeUpdateQuery(qry, host, user, password, database, port) return updatedCount
def testSetup(): updateQuery = 'UPDATE welcome_calls SET status=4,agent_id=100 where id=2' DBUtils.executeUpdateQuery(updateQuery)